My Oracle Support Banner

Container Items Tran Code 20 Value Calculated Incorrectly In The TRAN_DATA.TOTAL_COST (Doc ID 2512141.1)

Last updated on JUNE 04, 2019

Applies to:

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

Symptoms

The total_cost on TRAN_DATA table are incorrectly calculated for container items.

Steps To Recreate:

  1. Create a Content-Container Item and make sure it has one primary supplier and one secondary supplier.
  2. Maintain container unit_cost for secondary supplier as 0 and primary with different unit_cost (Ex: Unit_cost for primary as 0.15).
  3. Create a PO and Shipment against the secondary supplier.
  4. TRAN_DATA.TOTAL_COST will be calculated incorrectly i.e. (Primary supplier unit_cost*Qty), whereas in SHIPSKU cost will be 0.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.