You can set up purge policies to purge archived transactions in the Transaction
Console based on your organization’s data retention policies.
Grant the PER_DEFINE_APPROVAL_TRANSACTION_PURGE_RULES_PRIV
privilege to the role performing this task.
-
In the Transaction Console, go to the Approval Rules tab.
-
Find the process for which you want to set up a purge policy.
-
In the Purge Transactions column, select a time when the archived transaction
for that process should be purged. By default, each process has been setup to
not purge the archived transactions. Select one of the predefined purge
periods.
-
Repeat the steps for all business processes for which you want to setup a purge
policy.
-
You then need to submit the Purge Archived Transactions scheduled process to
purge all the transactions that were archived prior to the time selected in the
purge policy.
Note: You can also add user-defined purge periods by adding new lookup codes
under the extensible lookup type ORA_HRC_TXN_PURGE_PERIOD_TYPES. Use the
following format while defining the lookup code:
- HRC_TXN_<nn>_MONTH, to add a 1-month period, define the
lookup code as HRC_TXN_1_MONTH
- HRC_TXN_<nn>_MONTHS, to add a 6-month period, define the
lookup code as HRC_TXN_6_MONTHS
- HRC_TXN_<nn>_YEAR, to add a 1-year period, define the lookup
code as HRC_TXN_1_YEAR
- HRC_TXN_<nn>_YEARS, to add a 10-year period, define the
lookup code as HRC_TXN_10_YEARS