My Oracle Support Banner

Processing Transactions Causes Error: Item Cost Should Be Defined Before You Transact (Doc ID 412110.1)

Last updated on FEBRUARY 06, 2019

Applies to:

Oracle Inventory Management - Version and later
Oracle Item Master - Version 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.




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

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