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

Functional | Any company |ACA |Measurement stability period | An error is occurring during report process

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Company:
      JE Dunn
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Q2
    • Browser:
      Google Chrome, Mozilla Firefox

      Description

      Environment : Azure
      Company name: JE Dunn For HSPL

      • Login as partner
      • Select company
      • Select Measurement stability period under ACA
      • Click on cost of coverage icon of listed measurement stability period
      • Observe the result

      Actual result : An error is occurring during report process.
      Expected result : Report should process without fetching any error.

      Please find attached screenshot .

      NOTE : Same issue Exist for Stage environment , For cost & coverage Hence we are moving this point to WT .

      CC- Rakesh Roy Sachin Hingole Smita Pawar

        Attachments

          Issue Links

            Activity

            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern: Measurement stability period | An error is occurring during report process of Cost of coverage
            Cause: This issue occurred due to changes done for WT-11470-Superheat - Billing Summary Report - Premium is not calculating correctly.
            In SP "dbo.OES_SP_GetBillingDetails.StoredProcedure", datatypes of the table columns were changed.This same SP is used in Cost of Coverage for ACA.
            Correction: Changed the datatypes of the columns of the table used in SP OES_SP_Get_CostOfCoverageForACA.StoredProcedure.sql to match with column datatypes set in OES_SP_GetBillingDetails.StoredProcedure.sql

            Affected files : dbo.OES_SP_Get_CostOfCoverageForACA.StoredProcedure.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : Measurement stability period | An error is occurring during report process of Cost of coverage Cause : This issue occurred due to changes done for WT-11470 -Superheat - Billing Summary Report - Premium is not calculating correctly. In SP "dbo.OES_SP_GetBillingDetails.StoredProcedure", datatypes of the table columns were changed.This same SP is used in Cost of Coverage for ACA. Correction : Changed the datatypes of the columns of the table used in SP OES_SP_Get_CostOfCoverageForACA.StoredProcedure.sql to match with column datatypes set in OES_SP_GetBillingDetails.StoredProcedure.sql Affected files : dbo.OES_SP_Get_CostOfCoverageForACA.StoredProcedure.sql
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB [For QA CAISO For HSPL].
            Its working fine.Its ready for stage.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB [For QA CAISO For HSPL] . Its working fine.Its ready for stage.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on stage [Caiso for Hspl & JE Dunn for Hspl].
            Its working fine.
            Ready for production.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on stage [Caiso for Hspl & JE Dunn for Hspl] . Its working fine. Ready for production.
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have verified this issue on Production and observed that it does not exist.Hence closing the same.

            Thanks,
            Mahendra

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have verified this issue on Production and observed that it does not exist.Hence closing the same. Thanks, Mahendra

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              rutuja.chilwar Rutuja Chilwar (Inactive)
              Developer:
              Ramya Tantry (Inactive)
              QA:
              Rutuja Chilwar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h Time Not Required
                  3h