We have verified above mentioned issue on Production on below mentioned companies such as Wacker Neuson for Hspl
and Metso for Hspl.

Verified if continuous enrollment in year 2016, then in offer segment event date reflected as 01/01/2017.
Verified Record count which remained same after deleting run rate maintenance i.e waive record entry got pulled out in next ecport.
PFA screen shot of verified screen.

We have verified above mentioned issue on Stage [ACA Automation] Company.
Its working fine.
PFA screen shots for verified scenarios.

Smita Pawar,

I shown to you in person customization issue to you on receiving your mail for "Getting error while exporting template manually on ACA Automation Company" was for Sachin BSG customization.

Same issue was found with above mentioned template - Sachin BSG including waive template.

Please find the 3cs 3Cs.doc

FYI Sachin Hingole Nandkumar Prabhakar Karlekar

We have verified above mentioned issue on LB (ACA Automation company).
Its working fine,

Fix is ready for stage.

Revansiddha Gaur,

Its very clear that 2nd scenarios is for waive record means its template for which has waive sub template is there. On LB ACA automation which is used by Dev n QA team.

Template name: Sachin BSG including waive template.

Please and export that template and check

Note: Same has been communicated to you earlier via mail with subject line: Re: Getting error while exporting template manually on ACA Automation company

FYI Sachin Hingole

Hi Smita Pawar,

Please let me know the template name, steps which you followed for causing the above issue.

Thanks,
Revan

We have verified above mentioned issue on LB [ACA Automation Company].
I

Tested scenario for 1st issue as follows
1.Added test employee with continuous enrollment from 01/01/2016 & exported file for 01/01/2017 to 01/31/2017
and checked whether employee is coming on file.

But getting object reference error while testing 2nd issue.
Error log is as follows

Exception : Object reference not set to an instance of an object.
App Error Log : -
Employee ID : 0
Action Name : ManualImportExport
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
Web Error Log : at WORKTERRA.Shared.Areas.Customization.Models.ManualImportExportModel.OnExportClick() in d:\WT\branches\LB\Web\Web Projects\WORKTERRA\Areas\Customization\Models\EDI\ManualImportExportModel.cs:line 1136
at WORKTERRA.Shared.Areas.Customization.Controllers.CustomizationController.ManualImportExport(ManualImportExportModel objManualImportExportModel) in d:\WT\branches\LB\Web\Web Projects\WORKTERRA\Areas\Customization\Controllers\EDI\ImportExportBaseController.cs:line 1498
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c_DisplayClass15.<InvokeActionMethodWithFilters>b_12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

Hi Smita Pawar,

Reported error is not relevant to this bug. Please open new JIRA for this with details - Template Name,Company Name.

Thanks,
Revan

Nandkumar Prabhakar Karlekar Sachin Hingole

Hi Revansiddha Gaur,

Getting server error after exporting feed.
PFA screen shot for additional information.

Error log is as follows,
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ACAExportProcessRowwise.ExportData->ACAExportProcessRowwise.FillDataIntoDataTable
ErrorMessage: The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.PlanDesignID" could not be bound.
The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.PlanDesignID" could not be bound.

Let us know if you need any additional information.

Thanks

Point-1

CONCERN :
If continuous enrollment of last year without any user interaction which came on the Jan Full file in this case event date should be as 01/01/2017 in OFFR element.

CAUSE :
Explicitly user didn't raise any event in this case which populated the events data under OFFR element with old year (2016) event date which should be considered as of New Year (2017).

CORRECTION :
Updated event date with New Year

Point-2

CONCERN :
On deletion rundatemaintenance,waived employees are not pulling on the file.

CAUSE :
Once the file is exported the records will not be pulled out on subsequent exporting files.There is functionality that if exported files rundatemaintenace deleted , previous sent coverage details is reset the flag to sent again on the file but this functionality is not implemented for newly introduced waive entries table for ACA.

CORRECTION :
Functionality is implemented to reset for the coverage presents in the ACA_WaivedEmployeeData table, so that employee records can be pulled out whenever export the files.

AFFECTED FILES :

• \LB\Database Objects\MasterCompanyDB\01_DDL\533_WT-9231_WTB_ACA_NewIndex_ACA_EligibilityForExport.sql
• \LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_ExportProcessedEventData.StoredProcedure.sql
• \LB\Database Objects\MasterCompanyDB\01_DDL\532_WT-9231_WTB_ACA_NewIndex_ACA_ExportProcessedEventData.sql
• \LB\Database Objects\MasterCompanyDB\05_Triggers\trgDelImportExportRunDateMaintenance.Trigger.sql
• \LB\Database Objects\MasterCompanyDB\01_DDL\531_WT-9231_WTB_ACA_NewIndex_ACA_ExportWaivedEmployeeData.sql