My Oracle Support Banner

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

Last updated on JULY 16, 2018

Applies to:

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

Symptoms

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';

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.