FRM-40105: unable to resolve reference to item MTL_TRX_LINE.TRANSACT error when trying to perform Misc. Receipt

(Doc ID 1507368.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
R12.1.3 Miscellaneous Receipt
FRM-40105: unable to resolve reference to item MTL_TRX_LINE.TRANSACT

Symptoms

On : 12.1.3 version, Inventory Transactions

When trying to perform Misc. Receipt from the Miscellaneous Transaction form, get the following error.

Although this error message, the transactions are successfully created and we can see the created transactions
in the mtl_material_transactions table.

This error is occurring only when trying to perform Misc.Receipt.
If we're trying to perform another transaction types like 'Misc.Issue' or 'Subinventory Transfer' so on then no error is occurring.

ERROR
-----------------------
FRM-40105: unable to resolve reference to item MTL_TRX_LINE.TRANSACT

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Inventory responsibility: Transactions> Miscellaneous Transaction
2. Enter some required data for Misc.Receipt transaction
3. Error occurs

Note: Issue occurs the lot information is entered directly in the Miscellaneous Receipt page, without clicking in the Lot/Serial button. If the Lot information is entered under Lot/Serial, the issue does not occur.

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