How To Determine The DISTRIBUTION_ACCOUNT_ID For Inventory Datafix Scripts
Last updated on FEBRUARY 01, 2017
Applies to:Oracle Cost Management - Version 220.127.116.11 and later
Oracle Inventory Management - Version 18.104.22.168 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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms