FRM-40735: WHEN-CREATE-RECORD Trigger Raised Unhandled Exception ORA-01403 For New Reservation

(Doc ID 2124141.1)

Last updated on JANUARY 28, 2017

Applies to:

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

Symptoms

FRM-40735: WHEN-CREATE-RECORD Trigger Raised Unhandled Exception ORA-01403 for new reservation

When creating a new reservation foar a specific default demand source « Acceptation / Approval ».

ERROR
-----------------------
FRM-40735: WHEN-CREATE-RECORD Trigger Raised Unhandled Exception ORA-01403

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Inventory > On-hand, Availability > Reservations
2. Click New
3. For Default Demand Source, select ACCEPTION / APPROVAL
4. Error occurs

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