Overview of End of Service Details for UAE

The End of Service Details card stores all information required to accurately compute and process the gratuity payment, such as override amount and payment date.

The card is used to specify if the employee wants to claim the end of service remuneration or pension from the social insurance office.

Considerations and Prerequisites

When the product license is set to Payroll or Payroll Interface, End of Service Details cards are automatically created upon employee termination and the gratuity amount calculated. The Gratuity Details card component is also auto-generated along with the card association. You only populate the component details if you need to supply override values.

There may be cases where this information needs to be loaded in bulk:

During Data Migration:

End of Service Details information must exist in Oracle Fusion Payroll, to ensure that the gratuity is calculated correctly. If HCM Data Loader is used to migrate employee termination records, a default End of Service Details card is automatically created. For historical reasons you may wish to upload gratuity calculation cards to record the ‘Latest Gratuity Payment Date’, the last date a gratuity payment was made in a previous employment.

Ongoing Bulk Updates:

  • If you perform mass upload of termination information, a default End of Service Details card may be generated automatically (if the termination records are created using HDL). In this case, you need to update the default card with the correct Gratuity information and create a component detail to capture the gratuity override amount, if required.

It is recommended to have a good understanding of the End of Service Details card and the information it contains prior to attempting mass upload as it has a direct impact on statutory deductions and reporting. For further information, see Oracle Fusion HRMS for United Arab Emirates: Payroll Implementation and Functional Considerations (Doc ID 1565449.1).

End of Service Details Calculation Card Record Types

The End of Service Details card is uploaded with HCM Data Loader using the Global Payroll Calculation Card business object. This generic object hierarchy provides record types to support the various country-specific requirements.

The End of Service Details card utilizes the following record types:

Component Functional Description File Discriminator
Calculation Card Defines the calculation card type and the employee assignment that it captures information for. CalculationCard
Card Component Used to group and segregate data required by the calculation card. The following sections describe the card components applicable to this calculation card and the child records that are required for each card component. CardComponent
Component Detail Provide a component detail record for each flexfield context required by each card component. ComponentDetail
Card Association Associates the calculation card with the Tax Reporting Unit the employee reports to. CardAssociation
Card Association Detail Associates card components with the employee’s assignments. CardAssociationDetails

End of Service Details Calculation Card Hierarchy

The hierarchy of calculation card components applicable to End of Service Details are described in this diagram:

uae end of service