How To Determine The DISTRIBUTION_ACCOUNT_ID For Inventory Datafix Scripts
(Doc ID 400088.1)
Last updated on FEBRUARY 05, 2024
Applies to:
Oracle Cost Management - Version 11.5.10.2 and laterOracle 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 |