Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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.

V3 Seniority dates BIP query issue

Hi Experts,

I am working with a BIP query using V3 Seniority dates table (PER_SENIORITY_DATES_F), I need to map the seniority date with assignment table or work relationship table(PER_PERIODS_OF_SERVICE) where i can see the following issue.

" if a person is rehired or global transfered or both i can see the three different seniority date for the same assignments or same period of service ID and the seniority date is repeating for the other assignments/ work relationship as well."

How to map it correctly in order to get correct seniority date for the respective assignment number/ period of service table instead of showing all 3 seniority dates for one assignment/work relationship.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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