You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Recursive hierarchy error for Workforce Compensation Plan

edited Dec 24, 2024 9:12AM in Compensation 1 comment

Summary:

We are using an AOR-based hierarchy to run a workforce compensation plan. However, upon executing the plan, we are encountering the following error: ORA-20925: Recursive hierarchy found. We suspect that there may be an issue with the hierarchy structure, possibly due to a circular reference in the Hierarchy FF attatched.

Content (please ensure you mask any confidential information):

CMP_CWB_RECURSIVE_EMP_HEIRAR

Recursive hierarchy found.

Recursive Hierarchy Assignment IDs: ~300001246606500~300001246606500~300001246999570~300001246999570~

Details: Correct the managers in HR assignment record and then backout the plan and run the process again.

Populate_hierarchy-Second Errored with error message as :User-Defined Exception

Run_rollup errored with error message as :ORA-20925:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!