Absence Page And Document Of Record Error JBO-27122: SQL Error During Statement Preparation (Doc ID 2027873.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

On : 12.2.3 version, Assignment,Term,Pay,ChgMgr,LOA

Absence Page and Document of Record

When attempting to open the absence page and DOR from Employee Self-Service, the following error occurs:

error in absence page :

You have encountered an unexpected error.  Please contact your system administrator for assistance.

Click <here> for exception details.


Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
...

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.OAPageBean.preparePage(OAPageBean.java:2223)

        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:558)

        at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:446)

        at _pages.__oa._jspService(__oa.java:233)

        at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)

        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
...

## Detail 0 ##

java.sql.SQLException: ORA-06552: PL/SQL: Statement ignored

ORA-06553: PLS-801: internal error [56404]

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

      at

 



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

1. Login in Employee Self-Service responsibility
2. Click on “ Absence Management”
3. Error details (Click here for exception details)



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