ORDDSCNT Batch Updates Wrong Item's UNIT_COST in ORDLOC Table (Doc ID 1184964.1)

Last updated on SEPTEMBER 17, 2015

Applies to:

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

Symptoms

After the cost change is executed on an approved Purchase Order (PO), the unit cost in the PO is updated correctly. However, after running orddscnt.pc batch, the unit cost is updated to the cost before cost change. 

Steps To Recreate:
---------------------


1. Create and approve a PO.
2. Create a cost change for the item in the PO (supplier level cost change) and check the 'Recalc PO' indicator.
3. Run sccext.pc and sccext post program
4. Check the item cost in ITEM_SUPP_COUNTRY,ITEM_SUPP_COUNTRY_LOC and ORDLOC table , UNIT_COST has been updated to the new cost.
5. Run orddscnt.pc batch.
6. Check the item cost in ITEM_SUPP_COUNTRY,ITEM_SUPP_COUNTRY_LOC table, the unit cost is still the new cost. However ORDLOC table UNIT_COST has been updated to the original cost.

Cause

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