Incorrect 20A Tran Data Posted For Trans.Container PO Level Obligation

(Doc ID 2383506.1)

Last updated on APRIL 12, 2018

Applies to:

Oracle Retail Trade Management - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

Incorrect 20A Tran data posting occurs if Item has more than one transportation record with item in 2 different containers, and there are 2 different obligations for each container at "Trans.container PO"  level.

Steps To Reproduce:

  1. Ensure RTM_TRNSPRT_OBL_ALLOC_METHOD is set to TRNSPRT in system_options.
  2. Create a buyer pack with component items.
  3. Create Purchase Order for the buyer pack receive as pack.
  4. Create Transportation records with item coming in 2 different containers.Each container having 5 pack quantities.
  5. Receive the PO. Stock on hand, Avg Cost and TRAN_DATA posting is accurate.
  6. Create 2 different obligations for each container at "Trans.container PO" level.
  7. Perform ALC Order Finalize.

Note Tran Data is posted for full units for each container, thereby causing 20A Value to double and incorrect Weighted Average Cost [WAC].

Changes

 

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