Project - Mass Update Progress Gives Errors: ORA-06532, ORA-06512

(Doc ID 2247185.1)

Last updated on MARCH 23, 2017

Applies to:

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

Symptoms

When attempting to run Mass Update Progress for a specific project, the below error is displayed:

ERROR
-----------------------
Exception Details.  
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT PERCENT_COMPLETE_ID,
PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, LONG_NAME,
## Detail 0 ##
java.sql.SQLException: ORA-06532: Subscript outside of limit ORA-06512: at "APPS.PA_PROGRESS_UTILS", line 562

STEPS
---------
The issue can be reproduced at will with the following steps:
1. Go to Projects Super User Responsibility > select Projects: Delivery -> Search Projects -> Advanced Search

2. Search for your project > click on Projects Name > click Workplan tab > click Tasks sub-tab

3. From Actions list select 'Mass Update Progress' > click Go.

Changes

 

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