My Oracle Support Banner

Fusion Global HCM: Error JBO-27122: SQL Error During Statement Preparation (Doc ID 2511971.1)

Last updated on JANUARY 21, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, HCM Security (Security Profiles, Users, Roles)

No one with the IT Security Manager role can access the Security Console and we receive the attached error.
Also, no one with the HR Analyst role can search for anyone in Person Management - can search, but no results found. Example, they search for Smith, and 20-30 results should normally return, they find no one.
All HR Analyst users cannot run jobs in Oracle - everyone is receiving the error message ORA-28113: policy predicate has error.

Multiple users had navigated successfully this morning or yesterday to these same areas, but no longer retrieve data or the report throws this new error message.



ERROR
-----------------------

Error
Could not retrieve the user: xxx
JBO-27122: SQL error during statement preparation



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in as IT Security Manager
2. Select a person to review
3. Error occurs


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.