Fusion Global Payroll: Not Able To Pull Terminated Employees in HCM Extract - Payroll Interface

(Doc ID 2249418.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version and later
Oracle Fusion Global Payroll - Version 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

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