My Oracle Support Banner

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

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