Creating Performance Management Plan, Error: Java.Sql.Sql Exception: Exhausted Resultset Error
(Doc ID 1165503.1)
Last updated on DECEMBER 03, 2024
Applies to:
Oracle Performance Management - Version 12.1.2 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
When attempting to create a Performance Management Plan, upon selecting 'Next' from the Create Plan Population page the following error occurs.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: Exhausted Resultset
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
...
## Detail 0 ##
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:954)
at oracle.apps.per.selfservice.arch.server.PerAppModHelper.getLegislationCode(PerAppModHelper.java:381)
at oracle.apps.per.selfservice.picklist.server.SecGrpLookup.setCacheValue(SecGrpLookup.java:67)
at oracle.apps.per.selfservice.picklist.server.SecGrpLookup.getLegislationCode(SecGrpLookup.java:105)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
...
## Detail 0 ##
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:954)
at oracle.apps.per.selfservice.arch.server.PerAppModHelper.getLegislationCode(PerAppModHelper.java:381)
at oracle.apps.per.selfservice.picklist.server.SecGrpLookup.setCacheValue(SecGrpLookup.java:67)
at oracle.apps.per.selfservice.picklist.server.SecGrpLookup.getLegislationCode(SecGrpLookup.java:105)
Steps to Reproduce
The issue can be reproduced at will with the following steps:
- Responsibility: HR Professional V4.0 - Performance Management - Performance Management Plans
- Fill out the general information about the performance management plan
- Click the Next button
- Fill out the Population information for the performance management plan
- Click the Next button
- Upon clicking the Next button the framework error occurs
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |