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

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 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

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

Java Pricing Engine Interface Cleanup is a concurrent request used for truncating the interface data based on parameters.

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

Java Pricing engine cleanup

Report Parameters:

• Cleanup the interface tables:    Select YES or NO
• Time out for X-lock on interface tables (in seconds): Enter the time out period.

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