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 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.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.