Mass Salary Update Web ADI is not Creating Life Events (Doc ID 1335923.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Advanced Benefits - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On 11.5.10.2 version in Oracle Advanced Benefits,

WebADI is being used to upload mass salary increases, based on the seeded salary API.

The standard API hr_upload_proposal_api.upload_salary_proposal is called, which in turns call PER_PYP_INS.post_insert. In the post_insert procedure there is call made to ben_pro_ler.ler_chk to create the life event based on the column name and it's old and new value.

Per the debug log, we have found that the old values for parameter p_old in ben_pro_ler.ler_chk are not re-initialized for the next call and hence, it compares the second row value with the previous row value.

 


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

  1. Enter 2 rows in the WedADI with the salary amount the same Salary is successfully uploaded.
  2.  Navigate to HRMS Manager > People > Enter and Maintain > Assignment > Salary.
    1. A new salary record is created for both records.
  3. Navigate to HRMS Manager > People > Benefit Service Center > Potential Life Even
    1. There is a new salary life event for the first person, but nothing for the second person.
  4. Enter 2 rows in the WebADI with the salary amounts different.
    1. Salary is successfully uploaded.
  5. Navigate to HRMS Manager > People > Enter and Maintain > Assignment > Salary
    1. .A new salary record is created for both records
  6. Navigate to HRMS Manager > People > Benefit Service Center > Potential Life Events.
    1. There is a new salary life event for the first person, and for the second person.

Cause

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