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

Filter extract to Primary Address = Y

Received Response
32
Views
3
Comments

Summary:

I apologize for using unclear/incorrect terminology, I am quite new to Oracle. Please ask additional questions if needed.

We have an extract definition based on the Data Group "Person Address Details" and we would like to filter the extract to only show Primary Addresses.

The current filter looks as follow:

((pauf.address_type='HOME')
AND (pauf.effective_end_date>=pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE')))

but we aren't able to find what element/field corresponds to the Primary Address Flag.

Now I expect this to be standardized across Oracle, so maybe someone can help out?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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