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.

Symptoms

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(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 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.



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