My Oracle Support Banner

Fusion Global HR: Extract Not Fetching Create Address In Future Date. (Doc ID 2337672.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Information in this document applies to any platform.


Customer has cloned Worker Extract and done some customization (changed filter criteria of Work Term and Assignment Block , Added few blocks like Payroll Details, Citizenship etc, In Refine Parameter- given effective date field -SYSDATE+60 ).

After doing customization, this Extract can also fetch New hire in future date together with past, present and future dated transactions.
However, it’s not fetching ”Create Address in Future Date”.
May be the above scenario is invalid. But in fusion, we have option to create this.
Person Address Detail Block is using “PER_EXT_HISTORY_ADDRESS_UE” User Entity. I checked by running the underlying query and found –“paf.effective_start_date between pauf.effective_start_date and pauf.effective_end_date” condition is not satisfied. If query also had pauf.effective_start_date > trunc(sysdate) with ‘OR’ condition, then extract may fetch the above scenario.
per_addresses_f ->paf

With Current UE, customer is unable to fetch address in update and correction mode in present,past and future,also address created in past and present but not getting address for scenario-Address created in Future Date in xml output.

Customer wants all the scenarios to be fetched in extract output together with create address in Future Date.

Can you provide any suggestion, how this scenario can be fetched in the extract.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.