My Oracle Support Banner

Plant Resources Cannot Be Created Without Quality Parameters Being Set Up, Get Error "FRM-40735: When-Validate-Item trigger raised unhandled exception ORA-01403" (Doc ID 2987428.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Oracle Process Manufacturing Process Planning - Version 12.2.12 and later
Oracle Process Manufacturing Product Development - Version 12.2.12 and later
Information in this document applies to any platform.

Symptoms

In 12.1.3, creation of Plant Resource records did not require that Quality Parameters be set up, only that Product Development parameters be set up.

In 12.2.12, if you do not have a Quality Parameter record for a specific org,
when attempting to save Plant Resources in that organization,
the following error occurs.

ERROR
-----------------------
FRM-40735: When-Validate-Item trigger raised unhandled exception ORA-01403


The issue can be reproduced at will with the following steps:
1. Responsibility - Process Engineer > Setup > Plant Resources
2. Enter data and try to save


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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