PAXPREPR:ORA-1403,FRM-40735:WHEN-CREATE-RECORD Trigger Raised Unhanded Exception (Doc ID 2060794.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

After upgraded from 11.5.10 to 12.1.3:

In Projects form: when trying to query an existing project, get error:

  ORA-01403: no data found

If clicked the 'OK' button, it closes the project form.
If clicked the 'Details..' button, get detailed error:

ORA-01403: no data found
---------------------------------------------
FRM-40735: WHEN-CREATE-RECORD trigger raised unhanded exception ORA-01422


Steps to reproduce:
==============
1. Open Projects form:
Enter:
Project Number = xxxxx

Click Find and get error:

"ORA-01403: no data found"

If clicked the 'Details..' button, get detailed error:

ORA-01403: no data found
---------------------------------------------
FRM-40735: WHEN-CREATE-RECORD trigger raised unhanded exception ORA-01422


Changes

Upgraded from 11i to 12.1.3

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