My Oracle Support Banner

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

Last updated on MAY 20, 2022

Applies to:

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


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

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