Extract Not Fetching Create Address In Future Date.

(Doc ID 2337672.1)

Last updated on DECEMBER 10, 2017

Applies to:

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

Goal

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.
Note:
PER_PERSON_ADDR_USAGES_F ->pauf
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.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms