Last updated on MARCH 29, 2017
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Global Payroll - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Not able pull terminated employees in a ADP HCM extract of type Payroll interface with GLOBAL_PAYROLL_INTERFACE_MAIN_UE as the root block with threading group: Payroll relationship id and threading action: relationship_action.
The reason for this as follows:
The sql query for the Global_Payroll_Interface_Main_UE has the following sql line:
" and trunc(&B1) between papd.start_date and nvl(papd.LSED,to_date('4712-12-31','yyyy-mm-dd')) "
in the above sql query, papd is the alias for pay_assigned_payrolls_dn and B1 is the effective_date context.
Since for the terminated person, this condition is not satisfied because his last standard earning date = termination date according to the set up, he is not pulled in the extract.
Is there a work around to fix this issue? Have tried other UE's but nothing seem to give desired results.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms