You are browsing the archive for Concurrent Requests & Reports.

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

Pricing Formula Performance Control Request

Report  Name: Performance Control
Report Short Code: QPXPRFCB

Module: Oracle Advanced Pricing

‘Performance Control’ is a concurrent request in Oracle pricing that improves the performance of pricing engine when it has formulas and factor lists associated with it. Before running this request set the profile option ‘QP: Performance Control’ to YES.
Run this concurrent program periodically whenever there are changes in pricing formulas and factors list or when performance is decreased.

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

Pricing Formula Performance Control Report

Pricing Formula Performance Control Report

Report Parameters:

  • Starting List Header Id:
  • Ending List Header Id:
  • Performance Type:

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

Report Output:

This report doesn’t generate any output.

Modifier Details Report

Modifier details reports displays the detail information of any modifier9s) based on parameters entered.

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

Modifier Details Report

Modifier Details Report

Report Parameters:

  • Modifier Number From:
  • Modifier Number To:
  • Modifier Name From:
  • Modifier Name To:
  • Modifier Version From:
  • Modifier Version To:
  • Start Date Active:
  • End Date Active:
  • Active Modifier Only:
  • Active Modifier Lines Only:
  • Item name:
  • Item Category:
  • Customer Name:
  • Customer Class:
  • Price List:

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

Modifier Details Report Output

Modifier Details Report Output