Items costed with 0 distribution; mtl_transaction_accounts table shows BASE_TRANSACTION_VALUE = 0 and CONTRA_SET_ID <>1 (Doc ID 1360126.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Cost Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
.
***Checked for relevance 14-Apr-2013***

Symptoms

On : 11.5.10.2 version, Inventory Costing

ACTUAL BEHAVIOR
---------------
There are 645 transactions in mtl_material_transactions which have the correct item cost, but the distributions (mtl_transaction_accounts table) show BASE_TRANSACTION_VALUE = 0 and CONTRA_SET_ID <>1 for transaction types:

Subinventory Transfer
Sales order issue
Sales Order Pick
Int Order Intr Ship
Int Req Intr Rcpt
Move Order Transfer


EXPECTED BEHAVIOR
-----------------------
to see the correct distribution values for the transactions in cause

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. review the material transactions and distributions

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