Error While Updating Resource Duration In The Resource Tab

(Doc ID 2353865.1)

Last updated on FEBRUARY 15, 2018

Applies to:

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


When attempting to try to update the resource duration through the function "Update Duration",
the following error occurs.

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.PA_SCHEDULE_PUB", line 401
ORA-06512: at line 1"

The issue can be reproduced at will with the following steps:
1. Navigate to Project Responsibility
2. Project Search --> Resource Tab
3. Select Record --> Update Duration


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