My Oracle Support Banner

Wrong Calculation on Tran_data for Sending Loss in Stock Order Reconciliation (Doc ID 2549789.1)

Last updated on APRIL 16, 2021

Applies to:

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


For transfer having pack items (ITEM_MASTER.PACK_IND = 'Y') with more then one component the Stock Order Reconciliation is not calculating the Tran_code 38 properly.
Instead of calculating the cost of a component, Retail Merchandising System (RMS) is looping the calculation based on the calculated component - each increment is addressing the cost of the previous component.

The issue can be reproduced at will with the following steps:

  1. Create transfer.
  2. Add a pack item that has more then one component in it.
  3. Approve and ship the transfer.
  4. Check the values of TRAN_CODE 38.
  5. Receive the shipment (Receipt -> Receive by ITEM -> Save and Close).
  6. Go to Stock Order Reconciliation.
  7. Indicate the Loss on behalf of the shipping location (Sending Loss).
  8. Check the tran_data - for tran_code 38 with the negative units (the TOTAL_COST at this point is not calculated properly).

Example: A Transfer which has a pack of 5 components, each component has a cost of 10 USD.
The PACK has quantity 2 in PACK_ITEM_QTY for each component, giving the total of 10 PCS in a pack that gives the total Cost of 100 USD per pack.
When shipping the transfer in TRAN_CODES are generated in TRAN_DATA. For each ITEM in the PACK, tran_code 38 is created with TOTAL_COST based on calculation the percentile of the pack component.
In our case each ITEM in the TRAN_DATA has a TOTAL_COST of 20 USD.
After receiving the SHIPMENT with 0 quantity for enabling the SO RECONCILIATION and indicating the loss on the SHIPPING LOCATION side, the new TRAN_DATA generated will have TRAN_CODE 38 where UNITS < 0.

TRAN_DATA will be calculated as follows:
ITEM 1: UNITS -2 TOTAL_COST 20 (100*20%) - this is calculated properly
ITEM 2: UNITS -2 TOTAL_COST 4 (20*20%) - this calculation and further calculations in the loop are incorrect.
ITEM 3: UNITS -2 TOTAL_COST 0.8 (4*20%)
ITEM 4: UNITS -2 TOTAL_COST 0.16 (0.8*20%)
ITEM 5: UNITS -2 TOTAL_COST 0.032 (0.16*20%)

However each ITEM in PACK should have percentile of 20% of the total PACK cost.
ITEM 1: UNITS -2 TOTAL_COST 20 (100*20%)
ITEM 2: UNITS -2 TOTAL_COST 20 (100*20%)
ITEM 3: UNITS -2 TOTAL_COST 20 (100*20%)
ITEM 4: UNITS -2 TOTAL_COST 20 (100*20%)
ITEM 5: UNITS -2 TOTAL_COST 20 (100*20%)


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

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