R12 Multiple ORA-01403 Errors When Assigning New Project Manager

(Doc ID 1929093.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Setup

When attempting to add a key member to a project the following errors occur. The error only occurs for this one project.

ERROR
-----------------------
Row 1 Error - ORA-01403: No data found in Package PA_SCHEDULE_PVT Procedure apply_assignment_change
Row 1 Error - ORA-01403: No data found in Package PA_SCHEDULE_PUB Procedure_asgn_schedule
Row 1 Error - ORA-01403: No data found in Package PA_SCHEDULE_PUB Procedure change_duration
Row 1 Error - ORA-01403: No data found in Package PA_SCHEDULE_PUB Procedure single_update_schedule
Row 1 Error - ORA-01403: No data found in Package PA_SCHEDULE_PUB Procedure execute_update_schedule
Row 1 Error - ORA-01403: No data found in Package PA_PROJECT_PARTIES_PUB Procedure PA_SCHEDULE_PUB.single_update_schedule
Row 1 Error - ORA-01403: No data found in Package PA_PROJECT_PARTIES_PUB Procedure PA_SCHEDULE_PUB sing_update_schedule
Row 1 Error - ORA-01403: No data found in Package PA_PROJECT_CHECK_PUB Procedure check_for_one-manager_pvt.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open the project in the self-service web application
2. Add any employee as a key member
3. Error is encountered.


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