Adding New Items To Orders Does Not Trigger Revision (Doc ID 3062213.1)

Last updated on DECEMBER 05, 2024

Applies to:

Symptoms

Adding new items to orders does not trigger revision

ERROR
-----------------------
ordhead_rev, ordloc_rev, or ordsku_rev tables are not populated


STEPS
-----------------------
1. Create a new order, submit and approve the order
2. Check the tables
select * from rms01.ordhead_rev where order_no ='xxxxxxxx';
select * from rms01.ordloc_rev where order_no ='xxxxxxx';
select * from rms01.ordsku_rev where order_no ='xxxxxxxx';
to ensure that there are no entries present
3. Set the order back to Worksheet status
4. Add another item to the order
5. Submit and Approve the Order
6. Check the tables again. Now a revision 0 will be present where only entries for the original item.
7. Worksheet the order again
8. Add another unique item to the order and submit and approve the order
9. Check tables again, and the revisions UI and still only revision 0 is present with the original item.

Expected result:
Revisions continue to be created.

Actual result:
Revisions are not created.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.