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

Last updated on JANUARY 07, 2023

Applies to:

Symptoms

Problem Statement:

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

Cause

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