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

Identifying if a row already exists in the system through GUID and HRC_INTEGRATION_KEY_MAP table

Hello!
Just wondering if there's someone who already tried to identify if a row already exists in the system through GUID and HRC_INTEGRATION_KEY_MAP table?
Our team is trying to do data cleanup for Person Benefit Balance via HDL. But for some cases, we are encountering the issues listed in the screenshot below. We already know that there's a workaround, by passing ReplaceFirstEffectiveStartDate or ReplaceLastEffectiveEndDate, we are trying to figure out a way to handle this beforehand. Perhaps, a SQL we can incorporate our existing logic with that checks if the same combination was already passed?

Appreciate your response!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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