My Oracle Support Banner

Fusoin Global Payroll: How to Extract Calculation Card and Element Entries via HCM Extract (Doc ID 2253446.1)

Last updated on SEPTEMBER 21, 2020

Applies to:

Oracle Fusion Global Payroll - Version 11.12.1.0.0 and later
Oracle Fusion Global Payroll Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.

Goal

Have a requirement to extract details on a calculation card. Could you please advise on the correct UE (User Entity) that we need to get this information from?

Have created an extract using PER_EXT_PAY_EMPLOYEES_UE as the Root Data Group and then using ELEMENT ENTRIES as the second data group.
Have added filter criteria on the PER_EXT_PAY_EMPLOYEES_UE data group to only return employees that have the calculation card and this has worked and returns all element details for each employee.

When I try and restrict the element entries, the Element Start Date and Element End Date are Null for the element associated to the calculation card. Looking into the UE query I can see the effective start date comes from PAY_ELEMENT_ENTRY_VALUES_F, and the element from the calculation card does not have a record in this table.

Is there a way to return the start date of the calculation card or the generated associated element?
 

Solution

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
Goal
Solution
References


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