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: 

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms