Get Error When Trying to Update Resource Actual Data, "ORA-01403: no data found" and "FRM-40735: WHEN-VALIDATE-RECORD trigger raised unhandled exception ORA-12899"

(Doc ID 2077643.1)

Last updated on OCTOBER 17, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.3 and later
Information in this document applies to any platform.


On :12.2.3 version, Process Batch Open Interface

When attempting to manually enter or change actual total usage or process qty
the following error occurs.


FRM-40735: WHEN-VALIDATE-RECORD Trigger raised unhandled exception ORA-12899.

The issue can be reproduced at will with the following steps:

Navigation: Production supervisor > Batch detail > Step > Activities > Resources > Tab actual

- Manually change actual total usage or process qty
- Save
- Got error: FRM-40735
- Cannot save


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