Orders Are Not Updated by Batch Process ORDUPD When Emergency Price Changes Are Made

(Doc ID 1516385.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

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

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.




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms