Data Pump Purge

 

NAME: Data Pump Purge
SHORT CODE: DATAPUMP_PURGE
MODULE: Oracle Human Resources

Description: Data Pump tables purge program.
Navigation: Oracle Human Resources Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Batch Name : Name of the batch to be purged. This parameter has precedence over the All Batches parameter.
  • All Batches : Specify whether or not all batches should be purged.
  • Preserve User Keys : Specify whether or not user keys should be preserved for use in further Data Pump runs.
  • Purge Unprocessed Batch Lines : Purge unprocessed lines from HR_PUMP_BATCH_LINES.
  • Purge Failed Batch Lines : Purge failed lines from HR_PUMP_BATCH_LINES.
  • Purge Completed Batch Lines : Purge completed lines from HR_PUMP_BATCH_LINES.
  • Delete Batch Header : Delete the batch header.
  • Action Parameter Group : Action parameter group for PAY_ACTION_PARAMETER configuration values.

 

Leave a reply

Your email address will not be published. Required fields are marked *