Time and Payroll Info for Reconciliation

To reconcile worked time with paid time, you can use the Time and Payroll Info for Reconciliation extract.

The generated file data compares time reported in Oracle Fusion Cloud Time and Labor with time paid in Oracle Fusion Cloud Global Payroll. A difference of 0 signifies that the hours reconcile, while a negative difference signifies that some hours didn't transfer to payroll. The extract includes time cards that cross the current payroll period. You can also include old time cards retroactively adjusted during the current period. And you can see people who need to submit time cards, who are missing time cards.

The extract includes these parameters:

  • Department
  • HCM Group
  • Include retroactive updates made after this pay period starts
  • Location
  • Payroll Name
  • Payroll Period

It also includes this two-level group hierarchy.

Group Hierarchy Levels

Level Object Name Description User Entity
1 Person and Assignment Details for Reconciliation Data Group Person and assignment details for the specified reconciliation data group ORA_HWM_PERSON_ASSIGNMENT_DETAILS_UE
2 Time and Calculation Card Details for Reconciliation Data Group Time card and payroll calculation card details for the specified reconciliation data group. ORA_HWM_TIME_CARD_CALCULATION_CARD_SUMMARY_INFO_UE