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 laterInformation 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
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
Goal |
Solution |