Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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?
Tagged:
0