Use this program to manage stored procedures in FACTS. These stored procedures are used to maintain the stored procedures in SQL or PostgreSQL databases. Stored procedures are delivered with FACTS and cannot be renamed. The syntax of the stored procedures is specific to the type of database installed and used for Infor OS inbox/outbox connection point methodology. When revisions are made to the stored procedures within FACTS, the associated version number is incremented. Then, the version number within FACTS for the stored procedures is validated for the given database. If the version number is out of sync, the stored procedures in the database are deleted and the ones from FACTS are uploaded and saved for use. If the version number is not changed the database will not be updated for the revisions. Revisions should not be made to the store procedures within the database. Using CSSQL.pvc and the Connect() routine overwrites the database stored procedures when they become out of sync. Proper management of stored procedures is done using Stored Procedure Maintenance and associated version number updates.
This table describes the available stored procedures.
| PostgreSQL syntax | SQL syntax | FACTS background process used | Description |
| pgs_facts_create_outbox | facts_create_outbox | I2 (BKC201) | Creates database records in the outbox coming from FACTS. This sends a BOD from FACTS |
| pgs_facts_get_inbox | facts_get_inbox | I3 (BKC203) | Retrieves a database record at a time from the inbox for consumption by FACTS and the API system request. This is processing a BOD. |
| pgs_facts_clean_inbox | facts_clean_inbox | I4 (BKC204) | Cleans the inbox of processed database records. These are already processed BOD requests. |