Hi Prasanna Karlekar,

I have verified the 3 records which are mentioned in the ticket and observed that though there are proper entries in the billingdetails_ratelog table rebilling of new amount is not done for October month only credits of this month are displayed.

Rohan J Khandave

Thanks,
Venkatesh

Converted to Bug as code fix is required.

Hi Kira Hamilton,

Following are the 3Cs:
Concern:
Retro add adjustments not appearing

Cause:
On 14-Oct-2017, code fix for WT-11244 was deployed in Production environment. One of the code change made in the fix,impacted Non Health retro add adjustment. Please note that this had issue only for Non Health plans and invoices generated after 14-Oct-2017, i.e. after deployment of code fix for WT-11244. We have scanned all BCC companies for this issue. Found 4 companies whose November 2017 invoice is impacted.
Following is the summary for impacted companies:

Please refer WT-11691_AffectedElections.xlsx for more details.
November 2017 invoice for all 4 companies is finalized. To get proper adjustments for November 2017, invoices needs to be regenerated for these 4 companies.
Please let us know, if regeneration of invoice is possible or not? If not, then we will have to manipulate data so that these elections debit adjustments appear in December 2017 invoice.

Correction:
We have fixed the code. Script is executed on all BCC companies. Proper patch for all Production companies will be deployed as per process.

Please update us on invoice regeneration for impacted 4 companies.

Thank you!

cc: Debbie Kulling, Gaurav Sodani, Jyoti Agrawal, Venkatesh Pujari

The invoices were regenerated and now are correct. Thank you!

Have extended the Dev Due date from 15 Nov 2017 to 21 Nov 2017 as we could not work much on this JIRA on 6,7,8,9 Nov 2017.

Thank you!

Attaching development approval email to work on this ticket: FW Development approval for 9-Nov-2017.msg

Regards,
Satya Prakash

Cc: Prasanna Karlekar Gaurav Sodani Samir Bharti Satpute Jennifer Reed

Completed:
Documentation of:

• Classes
• Eligibility Rules
• Plans
• Rates
• Subrates
• Rate - Plan Design Mapping
• First Invoice Scenarios listing and review
• Second invoice - High level scenarios listing
• Second Invoice - Scenario 1 Listing (Cost change for Terminated Elections)

Test Data creation on Stage - Invoice Test Company for -

• Classes
• Eligibility Rules
• Rates and Subrates

In Progress:
Documentation of:

• Second Invoice - Scenario 2 Listing (Cost change for On going elections)

Test Data creation:

• Plans

Pending:

• Test data creation for First and Second Invoice
• Scenario Listing and test data creation for second Invoice

Please refer attached scenario document Invoice_Scenarios_TestData.xlsx for completed/In Progress tasks.

Please note that we have extended the dead line to 29 Nov 2017.
Initially we had not imagined so many scenarios but now while listing we are exploring new scenarios that we are documenting and accordingly test data needs to be created.

Thank you!

cc: Jyoti Agrawal

Extending Dev Due Date to 5-Dec-2017.
In past few days we could not focus on this ticket as we were mainly working on OE-325, WT-12091, WT-12216, WT-12180 and NF issues.

Following is the status update till now:
Test Data creation:
Completed:
165 employees initial load via import
165 elections imported for First invoice Billed Rate scenarios

In Progress:
Billed Rate scenarios verification against actual and expected output
Election file creation for 165 Self Insured Component scenarios + 165 Non Health Scenarios

Pending:

• Import file creation (165 Employee load + 495 Election load) for second invoice scenario - 1
• Import file creation for second invoice Tier changes scenarios (Scenario 3 and Scenario 4)
• Output verification

Documentation:
Completed:
Second Invoice: Cost changes for terminated elections. Scenarios documented 495.

In Progress:
Second Invoice: Mid Month Tier Changes in same and different plan.

Pending:
Scenario listing for Mid Month Tier Changes in same benefit type but different plan.
Cost changes within components

Till 5-Dec-2017, we target to complete following on Test company with verification:
First Invoice all 495 scenarios
Second invoice - Scenario 1
Second Invoice - Scenario 3
Second Invoice - Scenario 4

Please refer Invoice_Scenarios_TestData_29NOV2017.xlsx for detailed scenarios documented.

Thank you!

cc: Jyoti Agrawal

As this ticket needs to be deployed in further environments, we will continue scenario creation and verification for Test company in WT-7614.

Thank you!

3Cs mentioned above.

Affected files:
OES_SP_GetRetroBillingDetails_InvoiceBenefitWise

Impacted Areas:
Invoice Adjustment section for Non Health plans

Thank you!

Hi All,

Attaching the development approval email for your reference

Regards
Gaurav

Tested the scenarios mentioned in excel sheet. System is working fine as per expectation. Now correct adjustments are being displayed on the Invoice.

This is ready for Stage.

Hi All,

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

Regards
Gaurav

Hi Prasanna Karlekar,

Tested the scenarios mentioned in excel sheet. System is working fine as per expectation. Now correct adjustments are being displayed on the Invoice.

This is ready for Production.

Sachin Hingole,Hrishikesh Deshpande

Thanks,
Venkatesh

Hi Prasanna Karlekar,

Tested the scenarios mentioned in excel sheet on Production. System is working fine as per expectation. Now correct adjustments are being displayed on the Invoice.

Sachin Hingole,Hrishikesh Deshpande

Thanks,
Venkatesh

Hi Kira Hamilton,

The issue has been resolved and also tested on Production. Could you please verify and close this ticket.

Thanks,
Venkatesh

Hi All,

Attaching the production deployment approval email for reference

Regards
Gaurav