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

(Doc ID 1588048.1)

Last updated on MAY 01, 2018

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