My Oracle Support Banner

OEOIMP: Modifier With Attribute Mapping For LINE_ID Not Getting Applied During Order Import (Doc ID 557251.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
ConcurrentProgram:OEOIMP - Order Import


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


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.