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.

Need suggestions / opinions for sending termed records for xx days in reports and extracts.

edited Aug 16, 2023 10:00AM in Reporting and Analytics for HCM 4 comments

Summary:

Hi Experts,

we have a requirement to send all active records and termed records that were termed in the last 10 days. please note this is problem encountered primarily in HCM extracts where we are driving the data through the effective date parameter.

For sending the termed records we were using the condition - ppos.actual_termination_date > SYSDATE - 11 where ppos is referring to the per periods of service table. This was working fine but for cases where business users are doing termination with retro dates that are older than 10 days , these terms were not getting sent. so it was decided to increase the date from 10 to 90 days. However on of the users were not happy with this solution and asked if there was another way to go about this . asking your opinions/suggestions for this.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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