Audit History created in OE_ORDER_LINES_HISTORY via Processing Constraint is inconsistent
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.