Order Management - EBS (MOSC)

MOSC Banner

Audit History created in OE_ORDER_LINES_HISTORY via Processing Constraint is inconsistent

edited Oct 23, 2012 7:34AM in Order Management - EBS (MOSC) 2 commentsAnswered
Hi All,

My requirement is to capture Audit History for line changes when I change Schedule Ship Date or Promise Date on booked order line AND by looking at the audit history captured in OE_ORDER_LINES_HISTORY table I should be able to know how many touches have been done to a particular line.

For example: If my Schedule Ship Date and Promise Date is changed in one shot before the order line is saved, only one record with the old dates for both the columns should be inserted in the OE_ORDER_LINES_HISTORY table. And if each of the date is changed separately with transaction saves in between, 2 records must be inserted in the history table.

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