FRM-40735: WHEN-CREATE-RECORD Trigger Raised Unhandled Exception ORA-01403 on Select Available Inventory Form In Batches (Doc ID 1957983.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Batches

When attempting to use Select Available Inventory screen will open up and allow the user the select a new lot but does NOT allow the new lot to be ADDED only to REPLACE an existing lot the following error occurs.

ERROR
-----------------------
FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-01403

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Production Supervisor > batches
1. In the batch select an item
2. Click on Reservation button
3. And then click on Tolls – Select Available Inventory
4. Enter quantities and click Terminé
5. Error message


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