My Oracle Support Banner

Inventory Receiving and Misc Transactions Render Errors (FRM-40735, ORA-04062, FORM-FUNCTION) when Entering Transaction Lot Details (Doc ID 1060766.1)

Last updated on MARCH 01, 2023

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


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.


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.