Container Items Tran Code 20 Value Calculated Incorrectly In The TRAN_DATA.TOTAL_COST
(Doc ID 2512141.1)
Last updated on APRIL 16, 2020
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
The total_cost on TRAN_DATA table are incorrectly calculated for container items.
Steps To Recreate:
- Create a Content-Container Item and make sure it has one primary supplier and one secondary supplier.
- Maintain container UNIT_COST for secondary supplier as 0 and primary with different UNIT_COST(Ex: Unit_cost for primary as 0.15).
- Create a Purchase Order(PO) and ship against the secondary supplier.
- TRAN_DATA.TOTAL_COST will be calculated incorrectly i.e. (Primary supplier UNIT_COST*QTY), whereas in SHIPSKU cost will be 0.
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