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 with Redwood for Oracle Cloud HCM   Begin Now
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.

Dep Tree>Ability to Set and Get the Effective Start Date of the Parent Dep>View PER_DEPT_TREE_NODE_V

Summary:

Department Tree > Ability to Set and Get the Effective Start Date of the Parent Department > View PER_DEPT_TREE_NODE_V

Content (please ensure you mask any confidential information):

Hello,

As per the doc. for the view PER_DEPT_TREE_NODE_V, it returns fields including ORGANIZATION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE and PARENT_ORGANIZATION_ID, PARENT_EFFECTIVE_START_DATE, PARENT_EFFECTIVE_END_DATE

For the field PARENT_PK2_VALUE (PARENT_EFFECTIVE_START_DATE) and PARENT_PK3_VALUE (PARENT_EFFECTIVE_END_DATE): Are these fields related to the effective start date and effective end date of the parent department? Or the field PARENT_EFFECTIVE_START_DATE represents the date when a department is added as parent in the department tree?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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