Report Name: QP: Upgrade Pricing Data for Bulk Loader
Report Short Code: QP_BLK_LOAD_UPG_HDR_MGR
Module: Oracle Advanced Pricing

Report Description:
This concurrent program prepares the data for price bulk updating.

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘QP: Upgrade Pricing Data for Bulk Loader’ -> Enter the parameters.

Upgrade Pricing Data for Bulk Load

Report Parameters:

• Commit Size:
• Number of Threads:

Click ‘OK to submit the request. Navigate to menu bar -> View -> Requests to view the request output.

Report Output:

• This request doesn’t generate any output.

Report Name: QP: Pattern Upgrade
Report Short Code: QPXVATG
Module: Oracle Advanced Pricing

Report Description:
Oracle introduced new pattern based search logic for improved pricing performance. To leverage this feature you must run the concurrent request ‘QP: Pattern upgrade’ and set the below profile options.

• QP: Pattern Search
• QP: Pattern Search Path
• QP: Debug to Time Log
• OM: Debug to 1
• OM: Debug Log Directory to utl directory

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘QP: Pattern Upgrade’ -> Enter the parameters.

QP Pattern Upgrade

Report Parameters:

• Price List / Modifier List:
• No. Of Threads:

Click ‘OK to submit the request. Navigate to menu bar -> View -> Requests to view the request output.

Report Output:

• This request doesn’t generate any output.

Report Name: QP: Maintains the denormalized data in QP Qualifiers
Report Short Code: QPXDENOB
Module: Oracle Advanced Pricing

Report Description:
This concurrent program ‘QP: Maintains the denormalized data in QP Qualifiers’ denormalizes the pricing column data. Running this program enhances the pricing engine performance.

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘QP: Maintains the denormalized data in QP Qualifiers’ -> Enter the parameters.

Denormalize Qualifiers

Report Parameters:

• List Header Id (Low):
• List Header id (High):
• Update Type:

Click ‘OK to submit the request. Navigate to menu bar -> View -> Requests to view the request output.

Report Output:

• This request doesn’t generate any output.