ORA-01436: CONNECT BY Loop in User Data Error on iRecruitment Summary Link
Last updated on DECEMBER 03, 2016
Applies to:Oracle iRecruitment - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.
On Applications 12.1.3
When attempting to navigate to the iRecruitment Summary Page, the following error occurs.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
## Detail 0 ##
java.sql.SQLException: ORA-01436: CONNECT BY loop in user data
-- What is working
iRecruitment Recruitment Summary
Mode Full Refresh parameter completes normally without error
The issue can be reproduced at will with the following steps.
1. iRecruitment Recruiter
2. iRecruitment Home
3. Click on link
4. iRecruitment Summary
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms