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 and later
Information in this document applies to any platform.
***Checked for relevance 14-Apr-2013***


On : version, Inventory Costing

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

to see the correct distribution values for the transactions in cause

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


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