My Oracle Support Banner

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

Last updated on AUGUST 02, 2019

Applies to:

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


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.


        at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(

        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 _pages.__oa._jspService(

        at weblogic.servlet.jsp.JspBase.service(

        at weblogic.servlet.internal.StubSecurityHelper$

## Detail 0 ##

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

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

        at oracle.jdbc.driver.T4CTTIoer.processError(

        at oracle.jdbc.driver.T4CTTIoer.processError(

        at oracle.jdbc.driver.T4C8Oall.processError(

        at oracle.jdbc.driver.T4CTTIfun.receive(

        at oracle.jdbc.driver.T4CTTIfun.doRPC(

        at oracle.jdbc.driver.T4C8Oall.doOALL(

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(



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

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


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

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