Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-7027

WT -> BCC Invoice Enhancement -> Invoice is not showing all the employee records completely

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      TIBCO for HSPL
      Production

      • created a template for all employees - FSA Admin plan - this is a health plan
      • fetched out invoice for Jan 2017
      • on the other hand- fetch out standard enrollment report for FSA Admin plan - all employees from 01/01/2016 to 12/31/2017 [no dead enrollments]

      Enrollment report showed me 514 employee records whereas Invoice showed me only 77 employee records ! Remaining records are missing from Invoice 2017 Jan

      CC - Rakesh Roy shyam sharma Hrishikesh Deshpande Venkatesh Pujari

        Attachments

          Issue Links

            Activity

            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            This needs to be verified.

            cc: Venkatesh Pujari, Jyoti Agrawal

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - This needs to be verified. cc: Venkatesh Pujari , Jyoti Agrawal
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Venkatesh Pujari,

            We have tried fixing code for most issues.
            There are few scenarios for which discrepancy can still be seen :-
            1. Discrepancy due to Show Enrolled flag in enrollment report. When flag is set to Enrolled , this will give only active enrollments in report. While Invoice will show all records that are active as well as records that have been Terminated in that span.
            Flag Enrolled and Terminated in enrollment report will give all record which are active as well terminated in provided span.

            2. When there is enrollment change in mid of month (due to Tier change, Plan change etc), enrollment report picks both enrollments. Where as Invoice picks either single record or both depending on the Billing Policy set.

            There can be more such scenarios which can create discrepancy. After analysis and testing we have found two. We request you check these from your end and let us know if you find any discrepancy. We will verify those records.

            We will be giving code fix in LB on Monday (2/27/17).

            Thanks,
            Jyoti Agrawal

            CC : Prasanna Karlekar

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Venkatesh Pujari , We have tried fixing code for most issues. There are few scenarios for which discrepancy can still be seen :- 1. Discrepancy due to Show Enrolled flag in enrollment report. When flag is set to Enrolled , this will give only active enrollments in report. While Invoice will show all records that are active as well as records that have been Terminated in that span. Flag Enrolled and Terminated in enrollment report will give all record which are active as well terminated in provided span. 2. When there is enrollment change in mid of month (due to Tier change, Plan change etc), enrollment report picks both enrollments. Where as Invoice picks either single record or both depending on the Billing Policy set. There can be more such scenarios which can create discrepancy. After analysis and testing we have found two. We request you check these from your end and let us know if you find any discrepancy. We will verify those records. We will be giving code fix in LB on Monday (2/27/17). Thanks, Jyoti Agrawal CC : Prasanna Karlekar
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Verified the above points on LB on ASML company and observed the records are being displayed correctly.

            Prasanna Karlekar

            This is ready for Stage.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Verified the above points on LB on ASML company and observed the records are being displayed correctly. Prasanna Karlekar This is ready for Stage. Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Verified the above points on Stage on AFI For Hspl company and observed the records are being displayed correctly.

            Prasanna Karlekar

            This is ready for Production.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Verified the above points on Stage on AFI For Hspl company and observed the records are being displayed correctly. Prasanna Karlekar This is ready for Production. Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Verified the above points on Production on City Of Redding For Hspl company and observed the records are being displayed correctly.

            Prasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Verified the above points on Production on City Of Redding For Hspl company and observed the records are being displayed correctly. Prasanna Karlekar Thanks, Venkatesh

              People

              Assignee:
              alankar.chavan Alankar Chavan (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 32h
                  32h