My Oracle Support Banner

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


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

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

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