Incorrect Address is Selected When Generating Form 1095-C for Affordable Care Act (ACA) Reporting
Last updated on AUGUST 11, 2016
Applies to:Oracle Advanced Benefits - Version 12.1 HRMS RUP8 and later
Information in this document applies to any platform.
On : 12.1 HRMS RUP8 version, Affordable Care Act (ACA)
Customer has employees with more than one address.
In cases where a person_id is associated with more than one address (of various types), the cursor c_address in ben_aca_person.process_active_employees that fetches the address just uses the first fetched record, and that might be the incorrect address.
The cursor needs to use an additional where clause such as "and padd.primary_flag = 'Y'"
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Go to responsibility US Super HRMS Manager.
2. Navigate to Process and Reports > Submit Processes and Reports > Single Request.
3. Submit request name "Benefits ACA 1095C Print Report".
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