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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Filter extract to Primary Address = Y

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!