Last updated on SEPTEMBER 02, 2016
Applies to:Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
ConcurrentProgram:OEOIMP - Order Import
Checked for relevance: 10-MAYU2013
Find importing sales orders through the Order Import process, with the Calculate Price Flag is set to 'Y', that the function OE_ORDER_LINE_ID is always returning the value of the last line_id in the order (if the order had 5 lines, then only the line_id of the 5th line is returned). Hence the discount % getting applied to all the lines is the value in the DFF of the 5th line, instead of the DFF value in each line individually.
The order lines have DFF values of a Discount percent that needs to be applied at run-time based on a calculation. There is defined a Discount Modifer, with a Formula that uses the get_custom_price funtion. Within this the code uses the line_id using OE_ORDER_PUB.G_LINE.LINE_ID and then derives the value from that line's DFF to perform the calculation. This then determines the discount value to be returned to the Formula.
Expect line_id returned to be for the line being processed.
The issue can be reproduced at will with the following steps:
Run order import
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms