My Oracle Support Banner

ORDUPD.PC Calculates Incorrect Unit Retail (unit_retail) on Open Purchase Orders (Doc ID 2040206.1)

Last updated on MARCH 09, 2019

Applies to:

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


ORDUPD.PC calculates wrong unit_retail because date condition is missing for price_hist.  It considers all the previous price changes from price hist for associated items of order. It calculates the difference and sums it up.
As a result, unit_retail in ORDLOC is wrong.  Sometimes it is a high negative value and sometimes it is high positive value which depends on existing data in price hist for associated items of the order.

Steps to Reproduce:

  1. Post and process a XTSF message in which requested item is not ranged to a ‘to location’ of transfer.
  2. Pick any open purchase order.
  3. Run ORDUPD base batch.
  4. Notice that the retail_value is incorrectly updated in the order.




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.