R12: PAXPREPR: Delete Task, Get Error: "FRM-40735: POST-DELETE trigger raised unhandled exception ORA-01403. " (Doc ID 2242267.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On 12.1.3 version with R12.PJ_PF.B.DELTA.7, Project Access

After upgrading to 12.1.3, unable to delete tasks on existing projects in the Projects form (PAXPREPR.fmb version 120.99.12010000.197).  When trying to do so, the following error occurs:

ERROR
-----------------------
"FRM-40735: POST-DELETE trigger raised unhandled exception ORA-01403"



-This error appears to occur on all projects. Error still exists after recompiled the form.
-Able to create new projects without any issue.
-No invalid objects were found.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
• In the Projects form (PAXPREPR.fmb) -- Search for an existing project
• Click Open
• Navigate to Task Options
• Highlight a task
• Press the Delete button on the top toolbar
• Get the error: "FRM-40735: POST-DELETE trigger raised unhandled exception ORA-01403"


Changes

 Upgraded 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