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 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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.
Could not retrieve the user: xxx
JBO-27122: SQL error during statement preparation
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
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