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 APRIL 22, 2018

Applies to:

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

Goal

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.
 

Solution

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