Inventory Receiving and Misc Transactions Render Errors (FRM-40735, ORA-04062, FORM-FUNCTION) when Entering Transaction Lot Details
Last updated on DECEMBER 19, 2017
Applies to:Oracle Inventory Management - Version 11.5.10 to 12.0.1 [Release 11.5 to 12.0]
Information in this document applies to any platform.
INVTTELT.fmb (Lot Entry)
RCVTXERT.fmb (Receiving Transactions)
INVTTMTX.fmb (Miscellaneous Transactions)
In Inventory, when trying to deliver a lot controlled item the following errors are displayed:
1. Before entering the lot details in the Lot Entry form the following error is displayed in the Receiving Transactions form:
'ORA-01403: no data found'
2. When continuing and opening the Lot Entry form from the Receiving Transactions form to enter Lot details the following additional errors are displayed:
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-04062
FORM-FUNCTION NOT AVAILABLE
The same errors are displayed when entering the lot details for the same item through the Inventory Miscellaneous Transactions form.
No invalid objects are found in the database.
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