IEX: Purge Score History Table

 

NAME: IEX: Purge Score History Table
SHORT CODE: IEX_SCORE_HISTORY_PURGE
MODULE: Oracle Collections

Description: Deletes records from table IEX_SCORE_HISTORIES
Navigation: Oracle Collections Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_TRUNCATE : Truncate Table
  • P_SCORE_OBJECT_ID : Object ID for deletion
  • P_SCORE_OBJECT_CODE : Object Code for deletion
  • P_FROM_DATE : Delete From this date
  • P_TO_DATE : Delete to this date
  • P_REQUEST_ID : Delete this request
  • P_SAVE_LAST_RUN : Y or N Flag to save last run (default is Y)
  • P_BATCH_SIZE : Batch size for record deletion

 

Leave a reply

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