You are browsing the archive for Oracle Provisioning.

XDP Purge

 

NAME: XDP Purge
SHORT CODE: XDP_PURGE
MODULE: Oracle Provisioning

Description: Program to purge obsolete application data
Navigation: Oracle Provisioning Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_NUMBER_OF_DAYS : Define the days before that data will be pured (number of days prior to sysdate)
  • P_RUN_MODE : Indicate if the run is to verify or purge
  • P_PURGE_DATA_SET : Indicate what to purge
  • P_PURGE_MSG_FLAG : Indicate whether msgs will be pured if their orders still exist.
  • P_PURGE_ORDER_FLAG : Indicate whether msgs associated with orders will be purged
  • P_MAX_EXCEPTIONS : Indicate maximum number of exceptions allowed before Purging terminates itself
  • P_LOG_MODE : Indicate what messages to be logged
  • P_ROLLBACK_SEGMENT : Specify rollback segment name

 

XDP Performance Benchmark Report Program

 

NAME: XDP Performance Benchmark Report Program
SHORT CODE: XDP_PERF_BM_REPORT_PROG
MODULE: Oracle Provisioning

Description: SFM Performance Benchmark report program
Navigation: Oracle Provisioning Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • order_prefix : Unique Order Prefix

 

XDP Performance Benchmark Program

 

NAME: XDP Performance Benchmark Program
SHORT CODE: XDP_PERF_BM_PROG
MODULE: Oracle Provisioning

Description: SFM Performance Benchmark test program
Navigation: Oracle Provisioning Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_order_number_prefix : Unique Order Prefix
  • p_number_of_orders : Number of Orders Per Process
  • p_number_of_lineitems : Number of LineItems Per Order
  • p_process_number : Process Number
  • p_organization_id : Organization Id
  • p_service_name : Service Name
  • p_action_code : Action Code