OPM WIP Issue For Lot That Does Not Exist Gives Error, "FRM-40735: WHEN-VALIDATE-ITEM Trigger Raised Unhandled Exception ORA-01403" (Doc ID 2297238.1)

Last updated on JANUARY 27, 2023

Applies to:

Symptoms

When attempting to create a WIP Issue transaction, the Material Transaction screen allows you to enter a lot number that does not exist in the Lot field and tab out, but if you then try to tab through the Transaction Date field or click the Transact button, the following error occurs.

ERROR
-----------------------
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Material Transactions from Batch Details, enter a lot number that does not exist in the Lot field
2. Tab through the fields over to Transaction Date and tab through Transaction Date, or click the Transact button

ERROR
-----------------------
"FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403"

Changes

Cause

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