Processing Transactions Causes Error: Item Cost Should Be Defined Before You Transact
Last updated on OCTOBER 19, 2017
Applies to:Oracle Inventory Management - Version 220.127.116.11 and later
Oracle Item Master - Version 18.104.22.168 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
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:
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.
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