My Oracle Support Banner

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

Last updated on MARCH 12, 2021

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

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
Goal
Solution
References

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