Processing Transactions Causes Error: Item Cost Should Be Defined Before You Transact
(Doc ID 412110.1)
Last updated on OCTOBER 19, 2017
Applies to:
Oracle Inventory Management - Version 11.5.10.0 and laterOracle Item Master - Version 11.5.10.0 and later
Information in this document applies to any platform.
Form: INVTTMTX.fmb - Inventory Transactions
Form: INVIDITM.fmb - Define Item Information
This document is for all users of Oracle EBS 11i and R12 and later.
reviewed 0n 14-DEC-2012
Symptoms
When attempting to process an inventory transaction for a newly created item, the below error occurs.
You may also find error in debug INV file:
and/or:
ERROR
Action: Check if the cost-enabled flag is set correctly in the item master, and also check if the item cost is defined in the costing module.
Also, the following error could occur in the Miscellaneous Transactions form:
Item cost should be defined before you transact
STEPS
The issue can be reproduced at will with the following steps:
This example is for a Miscellaneous Transaction (Issue or Receipt) but can other for other types of Inventory transactions as well.
1. Go to Inventory > Transactions > Miscellaneous Transactions
2. The miscellaneous transaction header window appears
3. Choose the transaction date, miscellaneous issue (or receipt), and a source.
4. Choose transaction lines.
5. After entering the item and quantity while saving it errors out as
6. Receive the error.
The issue could also cause errored transactions to exist in the MTL_MATERIAL_TRANSACTIONS_TEMP (MMTT) table with the above error.
Checking the CST_ITEM_COSTS (CIC) table should show that there is no row for the new Item / organization combination, for the transaction item errored in the MMTT table.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |