Payslip Erroring with Java.Sql.Sqlexception: JBO-27122 (Doc ID 736100.1)

Last updated on MAY 18, 2017

Applies to:

Oracle HRMS (United Arab Emirates) - Version 12.0.2 and later
Information in this document applies to any platform.
Oracle HRMS United Arab Emirates - Version: 12.0.2


Symptoms


On 12.0.4 in Production:
When attempting to run the UAE Payslip from the SSHR the following error occurs:

ERROR
Exception Details.
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:896)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
Run Payroll
Run Prepayment
Run Payroll Archiver
Run Payslip from SSHR

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