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 JANUARY 23, 2020
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.
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.
FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-01403
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
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