Fluid Job Data: If Employee Has in Compensation COMP_EFFSEQ = 1 and Doesn't Have a COMP_EFFSEQ = 0 when Adding a New Job Row, 2 rows for COMP_EFFSEQ Are Added (Doc ID 2999057.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

When using Fluid Job Data, if a new row is inserted on an employee who has a previous COMPENSATION row with a COMP_EFFSEQ = 1 and no COMP_EFFSEQ = 0 the system will automatically insert both a COMP_EFFSEQ = 0 and COMP_EFFSEQ = 1 which in turn doubles the employees pay.

Steps to reproduce de issue:
1. Navigate to Workforce Administrator Homepage > Manage Human Resources tile > Manage Job Tile.
2. Search for an employee who has a previous COMPENSATION row with a COMP_EFFSEQ = 1 and no COMP_EFFSEQ = 0.
3. Insert a new Job row for this employee.
Notice that the system will automatically insert both a COMP_EFFSEQ = 0 and COMP_EFFSEQ = 1

Changes

Cause

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