My Oracle Support Banner

HRMS IE SEPA XML File - EndToEndId Tag Value Is Not Unique (Doc ID 2081130.1)

Last updated on AUGUST 31, 2018

Applies to:

Oracle HRMS (Ireland) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


Find that there is a problem with the XML file for Danske bank

Running IE SEPA XML File and Report to produce payments XML file for Danske Bank

The tag is on each payment record for each employee.
This tag must always contain a Unique value, even across all payroll files from multiple payrolls and multiple payroll runs.

Uploading sample XML file produced. Each employee payment has this tag setup on it

Ex Gratia Payroll-5450252

The Value is made from the Payroll Name concatenated with the Payroll Action ID.

The Assignment Action ID is not Unique enough, as an employee can have a payment to more than one back account in a payroll run.

There is a Pre_Payments_id in the Pay_Pre_Payments table. This looks to be always Unique.
Perhaps a Payroll Action ID concatenated with this PrePayments ID could work as always been Unique
 



Steps
The issue can be reproduced at will with the following steps.

  1. Ran payroll processing
  2. Ran the output file for danske bank
  3. It was returned with the following comments :



Changes

 

Cause

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.