Approval Notification Clicking Next 10 for 'ApprovalHistoryTable' Returns Exception
(Doc ID 2285767.1)
Last updated on FEBRUARY 23, 2019
Applies to:
Oracle Self-Service Human Resources - Version 12.1 HRMS RUP8 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
When attempting to view Approval History (next 10 records) the following error occurs.
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.RowNotFoundException: JBO-25060: Unexpected error encountered while trying to retrieve the next row from JDBC ResultSet for collection ApprovalHistoryVO
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3062)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1892)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
at _OA._jspService(_OA.java:213)
## Detail 0 ##
java.sql.SQLException: ORA-01002: fetch out of sequence
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. login and navigate to Employee Self-Service responsibility.
2. Transaction Monitor -> Function name - Amlak Final Departure -> Transaction Status - Complete -> Go
3. Transaction are displayed -> click on Transaction details
4. Approval History is displayed for selected transaction -> When click on Next 10 following error is displayed - You have encountered an unexpected error.
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 |