My Oracle Support Banner

PAXPREPR FRM-40735: WHEN-NEW-BLOCK-INSTANCE Trigger Raised Unhandled Exception ORA-01403 In Transaction Control (Doc ID 2026061.1)

Last updated on MARCH 09, 2020

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Opening the transaction controls form in projects errors:
1. FRM-40350: Query caused no records to be retrieved.
2. FRM-40735: WHEN-NEW-BLOCK-InSTANCE trigger raised unhandled exception ORA-01403

In addition, when users are in the Projects form (Transaction Controls), the Limit to Transaction Controls is NOT checked.
However, in PA_PROJECTS_ALL, the limit_to_txn_controls_flag = Y

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.