Online Payslip Error's: oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122 Ora-01008: Not All Variables Bound (Doc ID 341173.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Payroll - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Oracle HRMS (US) - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

When clicking on the 'Payslip' link from Employee Self Service, the following error occurs:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during
statement preparation. Statement: select distinct info_type, name, value_type, value
from pay_emp_others_action_info_v
where action_context_id = :1
and info_type in (:2 , :3)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
at
oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1064)
...
## Detail 0 ##
java.sql.SQLException: ORA-01008: not all variables bound
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

 

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