My Oracle Support Banner

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 later
Oracle 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: 

INV_TRX_MGR: error msg2 :Item cost should be defined before you transact

and/or: 

INV_TRX_MGR: ** Error .. :updated MMTT. ERR code :Transaction  processor error,msg:Item cost should be defined before you transact 

ERROR

Item cost should be defined before you transact
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:

APP-INV-05501: Transaction(s) failed
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

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