Delete Next Change Operation on Assignment Causing Duplicate Element Entries if MULTIPLE_ENTRIES_ALLOWED_FLAG='Y' (Doc ID 2039281.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Oracle Payroll - Version 12.0.0 and later
Oracle Human Resources - Version 12.0 and later
Information in this document applies to any platform.

Goal

When assignment criteria(e.g. Payroll Group) is changed and if an existing recurring element with multiple_entries_allowed_flag='Y' is eligible to a new element link criteria, the existing element entry(E1) is end-dated and new element entry(E2) is created for eligible element link criteria.

When deleting assignment criteria changed made previously with delete next change option, the original entry(E1) end_date is removed and extended to 31-Dec-4712, and element entry(E2) is not removed, which creates duplicate records.

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Create a recurring element with "Multiple Entries Allowed" checked.
     (N) Total Compensation > Basic > Element Description
     e.g.
     Element Name: XXElement
     Type: Recurring
     Multiple Entries Allowed: check

  2.  Create 2 element links with different conditions.
     (N) Total Compensation > Basic > Link
     e.g. Link1 with XXPayroll1
           Link2 with XXPayroll2

  3. Update assignment information that matches the element link criteria in step 2.
    (N) People > Enter and Maintain > (B) Assignment
    e.g. Payroll=XXPayroll1

  4. Create element entry.
    (N) People > Enter and Maintain > (B) Assignment > (B) Entries
    e.g.
    ELEMENT_TYPE_ID ELEMENT_LINK_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
    ------------------- -------------------- --------------------------- -----------------------
            67516           15320 01-Jan-2010 31-Dec-4712
  5. Update assignment information that matches another element link criteria in step 2 using the "Update" mode.
    e.g. Payroll=XXPayroll2  on effective date = 01-JAN-2015
  6. New element entry created for second element link.
    e.g.
    ELEMENT_TYPE_ID ELEMENT_LINK_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
    ------------------- -------------------- --------------------------- -----------------------
            67516           15320 01-Jan-2010 31-Dec-2015              <--Link condition = XXPayroll1
            67516           15321 01-Jan-2015 31-Dec-4712              <--Link condition = XXPayroll2
  7. Undo the assignment change made in step 5.
    e.g.
    Set the effective date to 01-Jan-2010, delete the record with "Next" and save.
  8. Element entry that matches the 2nd link criteria is not removed and duplicate element entries created.
    e.g.
    ELEMENT_TYPE_ID ELEMENT_LINK_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
    ------------------- -------------------- --------------------------- -----------------------
            67516           15320 01-Jan-2010 31-Dec-4712              <--Link condition = XXPayroll1
            67516           15321 01-Jan-2015 31-Dec-4712              <--Link condition = XXPayroll2

Solution

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 hundreds of Community platforms