Error"JBO-27122: SQL error during statement preparation. ORA-01436: CONNECT BY loop in user data" On Mass Change Main Appraiser
(Doc ID 2734642.1)
Last updated on OCTOBER 29, 2022
Applies to:Oracle Performance Management - Version 12.1.3 to 12.2 HRMS RUP14 [Release 12.1 to 12.2]
Information in this document applies to any platform.
On : 12.1.3 version, Appraisals
When attempting to search for new main appraiser/When trying to update main appraiser receive the following error
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
## Detail 0 ##
java.sql.SQLException: ORA-01436: CONNECT BY loop in user data
The issue can be reproduced at will with the following steps:
1. Go to Performance Management
2. Click on Mass Change Main Appraiser > Enter Criteria
3. Getting above mentioned after click on 'Go'
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