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.