Project - Mass Update Progress Gives Errors: ORA-06532, ORA-06512
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.
When attempting to run Mass Update Progress for a specific project, the below error is displayed:
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms