Report Name: QP: Bulk Import of Price List
Report Short Code: QPXVBLK
Module: Oracle Advanced Pricing

Report Description:
Bulk Import of Price List concurrent program imports price list information from interface tables. This will be very useful when you need to create/update the price list data. You can control the number of records to be processed by setting up the profile option QP: Batch size for Bulk upload.

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘QP: Bulk Import of Price List’ -> Enter the parameters.

Bulk Import of Price List

Report Parameters:

• Entity:
• Entity name:
• Process ID:
• Process Type:
• Process Parent:
• No. Of Threads:
• Turn Debug On:
• Enable Duplicate Line Check:

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

Report Output:

Bulk Import of Price List Output

Report Name: Purge Pricing Engine Requests
Report Short Code: QPXDLDBB
Module: Oracle Advanced Pricing

Report Description:
Purge pricing engine requests concurrent program purges the historical data from pricing debug tables. This program is recommended to run at regular intervals (once in a month) to improve the pricing efficiency.

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘Purge Pricing Engine Requests’ -> Enter the parameters.

Purge Pricing Engine Requests

Report Parameters:

• Keep Last (N) days of Requests:
• Request Name:

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

Request Output:

This request doesn’t generate any output.

Report Name: Pricing Forumals
Report Short Code: QPXPRFOR
Module: Oracle Advanced Pricing

Pricing Formulas Report is a standard oracle report in oracle pricing module that displays the pricing formula information based on parameters entered. It displays the formula header and lines information.

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

Pricing Formulas Report

Report Parameters:

• Formula From:
• Formula To:
• Start Date Active:
• End Date Active:

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

Report Output:

Pricing Formula Report Output