My Oracle Support Banner

SOE going into Java exception error when attempting to view all messages (Doc ID 2526739.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Payroll - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Core Payroll - General, SOE Report,

When attempting to view messages (in excess of 30) in SOE report, the following error occurs. However, all messages are visible View > Results > Quickpay Run Messages

ERROR
-----------------------
 oracle.apps.fnd.framework.OAException: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=Result set already closed
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1213)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1478)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3401)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2061)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:586)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:474)
at _pages.__oa._jspService(__oa.java:233)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run payroll/ quickpay
2. Check Messages section in SOE
3. Scroll down to see the full messages
4. Encounter ther 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.