You are browsing the archive for Concurrent Requests & Reports.

QP Upgrade Pricing Data for Bulk Loader

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

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.

QP Pattern Upgrade

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

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.

QP Maintains the denormalized data in QP Qualifiers

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

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.