Approval Notification Clicking Next 10 for 'ApprovalHistoryTable' Returns Exception

(Doc ID 2285767.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Self-Service Human Resources - Version 12.1 HRMS RUP8 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to view Approval History (next 10 records) the following error occurs.

Error Page
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(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at _OA._jspService(

## Detail 0 ##
java.sql.SQLException: ORA-01002: fetch out of sequence

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(


Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. login to Amlak HR Self Service
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.


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