6 Archiving and Purging Data

In a production environment, the number of transactions increases over a period of time. To keep performance acceptable, data must be purged periodically from the active tables of the application. ORFM purges the data from the active tables and stores the data in history tables.

To enter a Nota Fiscal (for a PO, TO, or RTV), create a schedule in ORFM. After the schedule is in Financial Posted status and passes a certain number of days, all related data with that schedule are purged from the transaction tables. In addition, all the NFs that are inactive for a schedule are purged. An inactive schedule is also purged from the transaction table and the data is stored in the history table.

The history tables are also purged.

The table FM_NF_PURGE_DAYS_SETUP indicates the number of days for status.

Table 6-1 History Table of fm_system_options

Variable	Variable_Type	Description
HISTORY_DAYS_HIST_TABLES	NUMBER	Indicates the number of days the history table can hold the records.
HISTORY_DAYS_PROCESSED_EDI	NUMBER	Indicates the number of days the EDI NFs can exist in the EDI tables before getting purged.

For more information on Purging, see Chapter 13, "Understanding Batch Processes".