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