My Oracle Support Banner

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.