My Oracle Support Banner

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:

Oracle Retail Merchandising System - Version 13.2 and later
Information in this document applies to any platform.


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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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