3C's :

Concern : Here the basic issue is, if we export file records gets duplicated on file.

Cause : While exporting ACA template, If employee has multiple enrollments during the exporting tenure i.e. From and To Date and ACA Minimum cost field is mapped in template then records gets populated multiple times or duplicated.
We have not putted check for enrollment effective date there.

Correction : When we exposed minimum cost field we have checked UserID, RundateMaintainance. We had not checked the enrollment effective date.
Now we have added below check while exporting data for minimum cost field and issue gets resolved.
EMPENROll.EffectiveDate BETWEEN OES_VIEW_ACA_MinimumCostPlan.MonthStartDate AND OES_VIEW_ACA_MinimumCostPlan.MonthEndDate

We have verified above mentioned issue on LB.
Its working fine.

Hi All,

This ticket has been approved for stage deployment on 12/21/17.

Regards
Gaurav

We have verified above mentioned issue on Stage company [MRTX for Hspl].
Its working fine.
Please find attached screen shot for additional information.

We have started working on Jira. We have exported Employee and coverage existing files and verified files are getting exported without server error.

Hi All,

Attaching the production deployment approval email for reference

Regards
Gaurav

We have verified above mentioned jira on production company.
Its working fine.
PFA screen shot for additional information.