Archive and Purge

OIC Archive and Purge Concurrent Program

Oracle Incentive Compensation processes large volumes of data, which gives rise to storage and performance issues. Users can run the OIC Archive and Purge concurrent program to increase space in the system and improve its performance.

When you archive data, the application moves transaction data, within a give date range, to another table space. You can archive data to a specific table space or to a default location, depending on the concurrent program parameter.

While creating archive tables the application appends time stamp to the table name to signify the time when the table was archived.

Table_name: = <Table Name> ||’_’|| to_char (sysdate, ‘DDMMYYYYHH24MI’);

For example, if you have archived the CN_PAYMENT_API table on 20th May, 2009 at 9:00 Am, then application will create the following archive table:

CN_PAYMENT_API_200520090900

When you purge data, the application deletes all transaction data, within the specified date range. The application can purge data using a single process thread or multiple threads, depending on the concurrent program parameters.

Note: Transaction data once purged cannot be recovered.

Oracle Incentive Compensation maintains archive and purges details in the following audit tables:

• CN_ARC_AUDIT_ALL

• CN_ARC_AUDIT_DESC_ALL

Transaction data from the following tables will be available to the OIC Archive and Purge program:

• CN_COMMISSION_HEADERS_ALL

• CN_COMMISSION_LINES_ALL

• CN_COMM_LINES_API_ALL

• CN_IMP_HEADERS

• CN_IMP_LINES

• CN_INVOICE_CHANGES_ALL

• CN_LEDGER_JOURNAL_ENTRIES_ALL

• CN_NOT_TRX_ALL

• CN_PAYMENT_API_ALL

• CN_PAYMENT_TRANSACTIONS_ALL

• CN_PAYMENT_WORKSHEETS_ALL

• CN_PAYRUNS_ALL

• CN_PAY_APPROVAL_FLOW_ALL

• CN_POSTING_DETAILS_ALL

• CN_POSTING_DETAILS_SUM_ALL

• CN_PROCESS_AUDIT_LINES_ALL

• CN_PROCESS_AUDITS_ALL

• CN_PROCESS_BATCHES_ALL

• CN_SRP_INTEL_PERIODS_ALL

• CN_SRP_PAYEE_ASSIGNS_ALL

• CN_SRP_PERIODS_ALL

• CN_SRP_PERIOD_QUOTAS_ALL

• CN_SRP_PERIOD_QUOTAS_EXT_ALL

• CN_SRP_PER_QUOTA_RC_ALL

• CN_SRP_PLAN_ASSIGNS_ALL

• CN_SRP_QUOTA_ASSIGNS_ALL

• CN_SRP_QUOTA_RULES_ALL

• CN_SRP_RATE_ASSIGNS_ALL

• CN_SRP_RULE_UPLIFTS_ALL

• CN_TRX_ALL

• CN_TRX_LINES_ALL

• CN_TRX_SALES_LINES_ALL

• CN_WORKSHEET_BONUSES_ALL

• CN_WORKSHEET_QG_DTLS_ALL

Note: Before you archive or purge any data;

• The data should be in consistent state. The application should have completely processed the data.

• Navigate to the Accumulation Periods page and permanently close all the periods whose data is to be archived or purged.

• Test your archive purge process in a test environment before running on the production data.