ACA (Affordable Care Act) Data Merge Process Is Not Updating Employee Data (Boxes 14 and 16) After Merging Data for Employee Amounts (Box 15) (Doc ID 3005480.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Symptoms

The ACA Data Merge process was successfully run for Employee Amounts (Box 15); when the process is run again for Employee Data (Boxes 14 and 16), the process ran successfully but the ACA Employee Transmittal Data was not updated.

Steps to reproduce the issue:

     1. Run the ACA Data Merge to update Employee Amounts (Box 15) on the ACA Employee Transmittal Data (Navigation: Benefits > ACA Annual Processing > Create ACA Form Data > Merge Other Sources).
     2. Review ACA Employee Transmittal Data to see that there is a new row with a Process Status of Merged with Data Load and see that the Employee Amounts fields have been updated (Navigation: Benefits >
         ACA Annual Processing > Create ACA Form Data > Merge Other Sources).
     3. Run the ACA Data Merge to update Employee Data (Boxes 14 and 16) on the ACA Employee Transmittal Data (Navigation: Benefits > ACA Annual Processing > Create ACA Form Data > Merge Other Sources).
     4. Review the ACA Employee Transmittal Data to see that no additional rows with a Process Status of Merged with Data Load has been added (Navigation: Benefits > ACA Annual Processing > Create ACA
         Form Data > Merge Other Sources).
     5. Check Review Merged Transmittal Data to see that the only updated data is Employee Amounts (Box 15) (Navigation: Benefits > ACA Annual Processing > Create ACA Form Data > Review Merged Transmittal Data).

Cause

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