My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

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


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

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(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(

-- 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


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.