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.
Symptoms
On : 12.1.3 version, Appraisals
When attempting to search for new main appraiser/When trying to update main appraiser receive the following error
ERROR
-----------------------
Exception Details.
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
STEPS
-----------------------
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'
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 |
Cause |
Solution |
References |