How To Determine The DISTRIBUTION_ACCOUNT_ID For Inventory Datafix Scripts (Doc ID 400088.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Cost Management - Version 11.5.10.2 and later
Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
This document includes all versions of 11i and R12 and later
FORM: INVTTMTX.FMB - Inventory Transactions
FORM: INVMATWB.FMB - Material Workbench
FORM: INVTVTXN.FMB - View Transactions
FORM: CSTFQITD.FMB - Material Transaction Distributions

Goal

Oracle Support may provide datafix scripts to correct the on-hand quantity information by creating new transactions. (typically miscellaneous or subinventory transfer transactions)
Example: Missing locator issues like described in <Note 282480.1>.
The datafix script would prompt the user to enter a value for DISTRIBUTION_ACCOUNT_ID. It is the internal identifier (eg "code combination ID") of the accounting key flexfield combination for the Inventory distribution account.

The DISTRIBUTION_ACCOUNT_ID is also required for datafix scripts that update the distribution account. (for instance when it is missing)
Example: Costing errors 'CST_NO_TXN_INVALID_ACCOUNT' like in <Note 178560.1>.

The purpose of this note is to assist customers in determining the correct value for DISTRIBUTION_ACCOUNT_ID.

Solution

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