You are browsing the archive for Oracle Advanced Pricing.

Purge Pricing Engine Requests

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

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.

Pricing Formulas Report

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

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

Pricing Formula Report Output

Price Lists Report

Report Name: Price Lists Report
Report Short Code: QPXPRCST
Module: Oracle Advanced Pricing

Price Lists Report prints out the price list information for a given parameters. Output shows both the price list header details and price list line details.

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

Price List Report

Price List Report

Report Parameters:

  • Price List From:
  • Price List To:
  • Start Date Active:
  • End Date Active:
  • Active Flag:
  • To Currency Code:

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

Report Output:

Price List Report Output

Price List Report Output