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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

How to delete specific row from Assignment Supervisor

Summary:

Hi there

In my organization we are using the Remove Person Information functionality to remove employee records that are beyond the retention period for our countries. In the removal we are including a Work Relationship Cancellation on each record but in order to complete this without errors, we must first ensure that if the person was a manager, they no longer have direct reports.

We attempted to remove the specific Assignment Supervisor row by using Delete in HDL but this removes all of the records which share the same Assignment Supervisor ID and therefore it removes current manager from active employees etc.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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