My Oracle Support Banner

ACA - EIN Correction Not Reflected After Running the Correction Archive Process (Doc ID 2407045.1)

Last updated on FEBRUARY 17, 2019

Applies to:

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


On : 12.2.5 version, ACA Correction Archive Process

Actual Behavior:
The EIN for 4 sub-GREs (under the transmitter GRE) were submitted incorrectly the first time, and therefore rejected by the IRS.

When running the 'Benefits ACA Correction Archive Process'
  - The EIN is not pulled into the 'GREINFO' Archive data.
  - Instead it is still picking the EIN Value from the original archive.

Expected Behavior:
The EIN, when corrected,
   - Should pull into the correction data via the 'Benefits ACA Correction Archive Process'
   - And should show as corrected on the file produced by the 'Benefits ACA Transmission XML Generation Process'

Steps to Reproduce:

1. EIN for several GREs were input incorrectly before original archive run
2. Overall Transmission Status was 'Partially Accepted' by the IRS
       - Primary Transmitter submission was 'Accepted with Errors'
       - GRE Submissions with incorrect EIN were 'Rejected'
3. IRS Error File is uploaded to Transmission Details Page, with Status and Receipt ID
4. Ran 'Benefits ACA Process Error Data XML' to sync IRS Error File with Advanced Benefits
5. Admin Team corrected the EIN on the System
6. Ran the 'Benefits ACA Correction Archive Process' to pull corrected data into next generation archive

Observation made at this point:
  - Archive data for newest REP_ACTION_ID still shows incorrect EIN for the Rejected GRE submissions

To Check GRE Data for a particular file generation
   Please run the following queries:

   A. select * from ben_rep_actions where year = &reporting_year order by rep_action_id;

         - Choose the latest rep_action_id for 'ARCHIVE' action_type for the GRE in question
            and carry that rep_action_id into the next query:

   B. select * from ben_rep_archive where rep_action_id = &rep_action_id and ben_attribute_category = 'GREINFO';



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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