Service Request Data Purge
NAME: Service Request Data Purge
SHORT CODE: CSSRPGP
MODULE: Oracle Service
Description: Service Request Data Purge Concurrent Program
Navigation: Oracle Service Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.
Report Parameters:
- P_API_VERSION_NUMBER : API Version Number
- P_INIT_MSG_LIST : Initialize Message Stack
- P_COMMIT : Commit Purged Records
- P_VALIDATION_LEVEL : Validation Level
- P_INCIDENT_NUMBER : Service Request Number
- P_INCIDENT_STATUS_NAME : Service Request Status
- P_INCIDENT_TYPE_NAME : Service Request Type
- P_CREATION_FROM_DATE : Service Request Creation From Date
- P_CREATION_TO_DATE : Service Request Creation To Date
- P_LAST_UPDATE_FROM_DATE : Service Request Last Updated On From Date
- P_LAST_UPDATE_TO_DATE : Service Request Last Updated On To Date
- P_NOT_UPDATED_SINCE : Service Request Not Updated Since
- P_CUSTOMER_NUMBER : Service Request Customer Number
- P_CUSTOMER_ACC_NUMBER : Service Request Customer Account Number
- P_ITEM_CATEGORY_NAME : Service Request Item Category Name
- P_INVENTORY_ITEM_NUMBER : Service Request Item Number
- P_HISTORY_SIZE : Number of customer serv
Ashok said on February 8, 2016
Is there a way to use this program in a batch mode for a selective 10000 records of service request. Say If I store the Service Request Number in a temporary table and then pick 100 records per batch from this temporary table to purge the Service Request. Can you please provide the API details to use this in a Batch mode