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

(Doc ID 2385999.1)

Last updated on APRIL 13, 2018

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

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 is customers, that have more than 100.000 items per sold to . They use Advanced Pricing via the Price List functionality in order to calculate unit prices . When generating a Price List, the unit prices are calculated only for 30.000 records. For the rest items the prices are not calculated but the batch ends normally without errors .

STEPS TO REPRODUCE:
1.Set up more items in P4101 (Item Master ) with different Units of Measure as follow :
1.1. The items APTEST1 > 7 have UOM = EA . For these items do not define conversion rules in P41002 (Item Unit of Measure Conversions) .
1.2. The items APLIST1 and APLIST3 have UOM = GN. Set up the conversion rule for this two items : 1GN = 5 EA
1.3.The items APLIST2 has UOM = CC and don¿t set conversion rule .
1.4.The items APLIST4 has UOM = AP and don¿t set conversion rule .
2. Enter all Items for the same branch in P41026 (Item Branch ).
3.Set up Unit Price (P4106 ) for all items using same Customer .
4.Enter a Price List (P45520) for this Customer with all Items defined above.

5.Apply a level break rule for all items of the list price with UOM = EA, using Row exit , Item Level Break .
6.Save the items selected in the list price.
7.Re-inquiry the list price in P45520 . The application P45520 will shows the rows of the list price for each items and level break .
8.Generate the prices for each rows of the list using Form exit, Generate Prices .
9. Run R45522
10. Re-inquiry the list price in P45520. For some rows of the list price , the application calculates the correct Unit price but for some items , did not.

After applying the solution for Bug 25148633, the R45522 report now shows an error message in the workcenter, 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 rebuilt 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.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms