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 JULY 05, 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.
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