Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-20718

Duplicate banking records on the deposits page

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2022R2
    • Fix Version/s: CFA 2022R4
    • Component/s: None
    • Labels:
      None
    • Root cause - Reason:
      Code defect
    • Root Cause:
      code defect..

      Description

      Description

      Duplicate deposits
      Environment : PROD
      Store : Example 01383 and 04120
       Steps
      1. Navigate to URL https://m.inform.cfahome.com/?bypass_sso=true 
      2. Navigate to Store 04120
      3. Workflow > Deposits

      Results ;  Duplicate banking deposits ** 

       

      SELECT a.BankingID, b.BankingID
      FROM tbBanking a WITH (NOLOCK)
      INNER JOIN tbBanking b WITH (NOLOCK) ON a.EntityID = b.EntityID AND a.CreateDate = b.CreateDate AND a.BankingTypeID = b.BankingTypeID
      WHERE a.BankingID != b.BankingID
      and a.createdate>'2021-12-30 00:00:00.000'

       

      Can we determine why duplicate banking records are still happening?  The fix was put into 2022.R2

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                Robert.Johnson Robert Johnson (Inactive)
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.