JBO-27122 error when assigning "HR: Security Profile" with Functional Administrator

(Doc ID 1946182.1)

Last updated on NOVEMBER 18, 2014

Applies to:

Oracle Human Resources - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to search for responsibility for the security profile "HR: Security Profile", the following error occurs.

ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM (SELECT S.SECURITY_PROFILE_NAME , S.SECURITY_PROFILE_ID , 'PER_BUSINESS_GROUP_ID' ,
S.BUSINESS_GROUP_ID , O.NAME FROM PER_SECURITY_PROFILES S , PER_BUSINESS_GROUPS O
WHERE O.BUSINESS_GROUP_ID (+) = S.BUSINESS_GROUP_ID ORDER BY S.SECURITY_PROFILE_NAME) QRSLT
WHERE (( UPPER(S.SECURITY_PROFILE_ID) like UPPER(:1) AND (S.SECURITY_PROFILE_ID like :2
OR S.SECURITY_PROFILE_ID like :3 OR S.SECURITY_PROFILE_ID like :4 OR S.SECURITY_PROFILE_ID like :5)))
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
....


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Responsibility: Functional Administrator
(N) Core Services tab
-> Profiles subtab
-> Search for HR: Security Profile
-> Click on the Security Profile update icon(pensil icon)
-> Responsibility tab
-> Click "Add another row" button
-> Click on the "Search for responsibility" icon
-> Error occurs



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