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.

Data Extract - Most Recent

in HCM Integrations 2 comments

Summary:

Is it possible to create a data extract an only get the latest relavant information for a given person whether the person is PWK, EX_PWK, CWK, EX_CWK, EMP or EX_EMP. I don't want the extract to return multiple data rows. If the person is an actual employee than i want to know all about that person. If the person is an actual ex-contingent I want to know all about that person. If they were both I only want the latest. Possible?

Most downstream applications when integrating data from HCM to another duplicate data rows in the extraction file were not a problem. I now have my first application that will NOT accept the file if the person has more than one data row and i do not know how to achieve that except to move away from data extracts and write a SQL query. What I will lose in the process is Changes Only that extracts can perform.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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