Cross Order Volume report generates the output of order volume information for each item/custom/period, this data is extracted from cross order volume tables which is populated by cross order volume load. So cross order volume load is a pre-requisite for running cross order volume report.

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘Cross Order volume report’

Cross Order volume load report

Report Parameters:

This report doesn’t have any parameters.

Click ‘OK to submit the request. Navigate to menu bar -> View -> Requests to view the status of the request. The sample output of this report is as below.

Cross Order Volume Report Output

Cross Order Volume load is a pre-requisite request to run cross-order volume report.
Cross order volume report lists out the order volume information for each item/custom/period, this data is extracted from cross order volume tables which is populated by cross order volume load. This program maintains the data based on list price (not the actual selling price). This report uses 3 profile options.

• QP: Cross order volume period 1
• QP: Cross order volume period 2
• QP: Cross order volume period 3

This profile maintains the number of days each cross volume period is. If period1 is 10 days then from the parameter effective date it calculates the date range for cross volume period 1.

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘Cross Order volume load’ -> Enter the parameters.

Cross Order Volume Load

Report Parameters:

• Operating Unit:
• Effective Date: Effective date is used to determine the date range for cross volume period based on cross volume period profile option.

Click ‘OK to submit the request. Navigate to menu bar -> View -> Requests to view the status of the request. This request doesn’t generate any output.

Build Formula Package Request is a concurrent request that builds the formula package. This formula package (PL/SQL package) is used in pricing to determine the price. This request must be run every time there is a change in formula.

Navigation:
Oracle Advanced pricing responsibility -> Reports -> Run Reports -> Select Report name as ‘Build Formula Package’.

Build Formula Package

Report Parameters:

This request don’t have any parameters.

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