My Oracle Support Banner

E1: 45: Price List Generation (R45522) Does Not Calculate All Unit Prices in a Large Price List (Doc ID 2385999.1)

Last updated on JULY 29, 2020

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.


When generating a Price List with many items , the unit prices are calculated only for some items. The batch Price List Generation (R45520) ends normally and the pdf is not generated. The system did not show any error messages for the unit prices that cannot be calculated.
There are customers that have more than 100,000 items per Sold To. Advanced Pricing via the Price List functionality is used to calculate unit prices. When generating a Price List, the unit prices are calculated only for 30,000 records. For the rest of the items, the prices are not calculated. The batch ends normally without errors.

After applying the solution for Bug 25148633, the R45522 report now shows an error message in the work center. However, it still stops calculating the next items in the price list. When it deletes/corrects the item which causes the error, from the price list, the R45522 has to rebuild and generate the price list again but stops calculating again at the next item with an error. For a very large price list, more than 100,000 items per Sold To, R45522 is useless because R45522 will stop for the first error encountered. The R45522 process should continue to calculate the prices for the complete price list and displays all error messages in the work center.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.