Order Management - EBS (MOSC)

MOSC Banner

Descriptive flexfield on OE Order Lines All not being updated consistently - Oracle R12

edited Aug 17, 2017 4:24PM in Order Management - EBS (MOSC) 2 commentsAnswered ✓

We use attribute9 on oe_order_lines_all to store information on pieces remaining to ship for an order line. When we ship partial and the line splits there is a before insert trigger on oe_order_lines_all that sets attribute9 on the newly created line equal to the line it was split from minus the amount shipped. Since going to R12 the values are not always being updated, seemingly at random. Most of the time the attribute updates correctly but occasionally it reverts back to its previous value from before the trigger updated them. After the problem was reported I created an after update

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center