You are browsing the archive for Service.

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

 

Automatic Assignment of Resource for Service Request

 

NAME: Automatic Assignment of Resource for Service Request
SHORT CODE: CSSRCONMAN
MODULE: Oracle Service

Description: Automatic Assignment of Resource for Service Request
Navigation: Oracle Service Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_GROUP1_ID : References group_id in jtf_rs_groups_vl
  • P_GROUP2_ID : References group_id in jtf_rs_groups_vl
  • P_GROUP3_ID : References group_id in jtf_rs_groups_vl
  • P_GROUP4_ID : References group_id in jtf_rs_groups_vl
  • P_GROUP5_ID : References group_id in jtf_rs_groups_vl
  • P_INCIDENT_TYPE1_ID : References incident_type_id in cs_incident_types_vl
  • P_INCIDENT_TYPE2_ID : References incident_type_id in cs_incident_types_vl
  • P_INCIDENT_TYPE3_ID : References incident_type_id in cs_incident_types_vl
  • P_INCIDENT_TYPE4_ID : References incident_type_id in cs_incident_types_vl
  • P_INCIDENT_TYPE5_ID : References incident_type_id in cs_incident_types_vl
  • P_INCIDENT_SEVERITY1_ID : References incident_severity_id in cs_incident_severites_vl
  • P_INCIDENT_SEVERITY2_ID : References incident_severity_id in cs_incident_severites_vl
  • P_INCIDENT_SEVERITY3_ID : References incident_severity_id in cs_incident_severites_vl