My Oracle Support Banner

Why the Discounted Value of an Item is Reverted to the Original Cost in ORDLOC Table, when ever a Deal is Applied to the PO ? (Doc ID 2384790.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


If the deal is applied to the Purchase Order(PO) , the discounted value of an item is reverted to the original cost in ORDLOC Table whenever any new cost change is applied on this item.

StepsTo Recreate:
1: Create a new deal for one item (Annual Deal or PO specif Deal with 10% Percentage Offer).
2: Create a PO and use the above created Deal as cost source of the PO and don't receive the PO.Run orddscnt and ordrev batch.
3: Initially the first revision of the discount value is applied in the ORDLOC table .
4: Create a Cost change with future date.
5: ORDLOC table for the item gets updated back with the unit cost(Original) and same is seen in ORDLOC_REV ,FUTURE_COST and PRICE_HIST tables of the active date of the cost change.


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.