payslip error (You have encountered an unexpected error) JBO-27122 after application of CPU Patch (14590199). (Doc ID 1588048.1)

Last updated on JANUARY 10, 2017

Applies to:

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

Symptoms


Unable to View Payslip for All Employees

ERROR
-----------------------
You have encountered an unexpected error. Please contact the System Administrator for assistance.

 

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, UOM, org_information_cntxt, reporting_name
from pay_emp_others_action_info_v
where action_context_id = :1
and info_type in (:2 , :3)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Unable to View Payslip for All Employees


Changes

 Customer applied Patch 16772121:12.1.0 : CPU PATCH FOR JUL 2013

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