You are browsing the archive for Oracle Service.

Service Request Data Purge Worker Thread

 

NAME: Service Request Data Purge Worker Thread
SHORT CODE: CSSRPGW
MODULE: Oracle Service

Description: Service Request Data Purge Worker Thread 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_WORKER_ID : Worker Thread Id
  • P_PURGE_BATCH_SIZE : Number of Service Requests to be processed in a batch
  • P_PURGE_SET_ID : Purge Set Id
  • P_PURGE_SOURCE_WITH_OPEN_TASK : Purge a Service Request even if it has open Tasks
  • P_AUDIT_REQUIRED : Audit Required or Not

 

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

 

Service: Service Request Contact Points Audit Upgrade – Manager

 

NAME: Service: Service Request Contact Points Audit Upgrade – Manager
SHORT CODE: CSSRCPTAM
MODULE: Oracle Service

Description: Manager CP for Contact Points Audit Record
Navigation: Oracle Service Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_cutoff_date : Contact Point created on or after this date will be upgraded