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

Export > BCC Enhancement - No Records found is showing for STD on Providerwise Export

    Details

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

      Description

      Even if the Invoice is finalized for the month of November 2016 for STD.
      Provider wise export template showing no records found on manual export

      Template Name : Alan STD
      Finalized Invoice Name : Alankar
      Company Name (on LB) : ASML

      Note: Verified for Health plans (for finalized Invoices) and it is getting exported

        Attachments

          Issue Links

            Activity

            aniruddha.dev Aniruddha Dev (Inactive) created issue -
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-5308 [ WT-5308 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Description Even if the Invoice is finalized for the month of November 2016 for STD.
            Provider wise export template showing no records found on manual export

            Template Name : Alan STD
            Finalized Invoice Name : Alankar

            Note: Verified for Health plans (for finalized Invoices) and it is getting exported
            Even if the Invoice is finalized for the month of November 2016 for STD.
            Provider wise export template showing no records found on manual export

            Template Name : Alan STD
            Finalized Invoice Name : Alankar
            Company Name (on LB) : ASML

            Note: Verified for Health plans (for finalized Invoices) and it is getting exported
            Hide
            rakesh.shahane Rakesh Shahane (Inactive) added a comment -

            Below are 3C's

            Concern : BCC Enhancement - No Records found is showing for STD on Providerwise Export

            Cause :This happens because JOIN for EmployeeHealthTierPolicyNumber_Log table, ImportExportEnrollmentDeductiondata, HealthTier were Not Proper.

            Correction We have Handle this as of now in SP.

            Show
            rakesh.shahane Rakesh Shahane (Inactive) added a comment - Below are 3C's Concern : BCC Enhancement - No Records found is showing for STD on Providerwise Export Cause :This happens because JOIN for EmployeeHealthTierPolicyNumber_Log table, ImportExportEnrollmentDeductiondata, HealthTier were Not Proper. Correction We have Handle this as of now in SP.
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Assignee Rakesh Shahane [ rakesh.shahane ] Aniruddha Dev [ aniruddha.dev ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Attachment Error while generating Inovice.JPG [ 32606 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited

            Hi Prasanna Karlekar,

            Blocked to test this due to error in generating invoice related to WT-5987 . Please find screenshot below

            Can you please look into this at update accordingly

            CC: Alankar Chavan

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited Hi Prasanna Karlekar , Blocked to test this due to error in generating invoice related to WT-5987 . Please find screenshot below Can you please look into this at update accordingly CC: Alankar Chavan
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Link This issue relates to WT-5987 [ WT-5987 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this fix on LB on Rowise and Column wise templates . Records getting exported properly on Providerwise Billing Data export file. Working as expected

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this fix on LB on Rowise and Column wise templates . Records getting exported properly on Providerwise Billing Data export file. Working as expected
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 24/Nov/16 12:00 PM
            • Time Spent:
              20m
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Remaining Estimate 1h 50m [ 6600 ]
            Original Estimate 1h 50m [ 6600 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Remaining Estimate 1h 50m [ 6600 ] 1.5h [ 5400 ]
            Time Spent 20m [ 1200 ]
            Worklog Id 10415 [ 10415 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Fix is deployed along with its parent JIRA WT-5308

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Fix is deployed along with its parent JIRA WT-5308
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 09/Dec/16 01:16 PM
            • Time Spent:
              0.75h
               
              <No comment>
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this on Stage on City of Bellevue for HSPL company . on Group as well as Company level template . Working as expected

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this on Stage on City of Bellevue for HSPL company . on Group as well as Company level template . Working as expected
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0.75h [ 2700 ]
            Time Spent 20m [ 1200 ] 1h 5m [ 3900 ]
            Worklog Id 12365 [ 12365 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 12/Dec/16 12:19 PM
            • Time Spent:
              0.5h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Remaining Estimate 0.75h [ 2700 ] 0.25h [ 900 ]
            Time Spent 1h 5m [ 3900 ] 1h 35m [ 5700 ]
            Worklog Id 12490 [ 12490 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this fix on Production. Providerwise Billing Data export on Rowise , Columnwise Templates are working as expected.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this fix on Production. Providerwise Billing Data export on Rowise , Columnwise Templates are working as expected.
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Rakesh Shahane (Inactive) made transition -
            Open In Development
            59m 8s 1
            Rakesh Shahane (Inactive) made transition -
            In Development In LB Testing
            4s 1
            Aniruddha Dev (Inactive) made transition -
            In LB Testing Stage Testing
            23d 21h 46m 1
            Rakesh Roy (Inactive) made transition -
            Stage Testing In Production Testing
            2d 20h 58m 1
            Aniruddha Dev (Inactive) made transition -
            In Production Testing Production Complete
            3h 15m 1
            Aniruddha Dev (Inactive) made transition -
            Production Complete Closed
            5s 1

              People

              Assignee:
              aniruddha.dev Aniruddha Dev (Inactive)
              Reporter:
              aniruddha.dev Aniruddha Dev (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h 50m
                  1h 50m
                  Remaining:
                  Time Spent - 1h 35m Remaining Estimate - 0.25h
                  0.25h
                  Logged:
                  Time Spent - 1h 35m Remaining Estimate - 0.25h
                  1h 35m