NAME: Consolidate and Update Transaction Data
SHORT CODE: QPRUSPLBM
MODULE: Oracle Deal Management

Description: Consolidate and Update Transaction Data
Navigation: Oracle Deal Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Instance_Id : Instance Name
• From_date : Date From
• To_date : Date To

NAME: Determine Regression Coefficients for Pricing Segments
SHORT CODE: QPRURGRB
MODULE: Oracle Deal Management

Description: Determine Regression Coefficients for Pricing Segments
Navigation: Oracle Deal Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Datamart :
• Start Date :
• End Date :
• Start Product :
• End Product :
• Start Pricing Segment :
• End Pricing Segment :

NAME: Load data to Pricing Datamart
SHORT CODE: QPRUMNTB
MODULE: Oracle Deal Management

Description: Load data to Pricing Datamart
Navigation: Oracle Deal Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• DataMart_Id : Data Mart
• From_date : Date From
• To_date : Date To
• Clear_temp : Clear Interface Tables
• Delete_all_dim_mem : Delete existing dimension members
• Clear_measure : Delete existing measure data
• Add_cube_dims : Add new dimension members