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 OCTOBER 24, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.6 and later
Information in this document applies to any platform.

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"

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