Orders Are Not Updated by Batch Process ORDUPD When Emergency Price Changes Are Made (Doc ID 1516385.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

Approved Purchase Orders (POs) are not updated for emergency price changes upon executing the batch ORDUPD.

Steps to Reproduce:

1. Create an item and note the unit retail of the item. Records are inserted into PRICE_HIST table.
2. Create an order for the item created in step 1.
3. Create a emergency price change for the item/location created in step 1. Note that a record will be inserted into PRICE_HIST table with tran_type = 4 and action_date = current date.
4. Notice that ITEM_LOC.UNIT_RETAIL is updated with the new unit retail.
5. Run ORDUPD batch.
6. Notice that ORDLOC.UNIT_RETAIL for the order created in step 2 is not updated with the new unit retail.

Changes

Cause

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