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 ?
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.
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.
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.
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