Batch payment query: total success count differs from the actual number of payments for a scenario

[sandhiyakavi]

Description:

Tried Batch payment query for below

But If we GET/work-periods?startDate=2021-01-31&endDate=2021-02-06&userHandle=pshah_manager

In the below response, Only 6 records has payments and 2 records don't (the first and last Workperiods don't have payments), the last one is expected as BA is not added to it. But RB id: 616ad7c7-a694-495c-858b-cf9d85c9faf0 should have payment created as it has BA assigned as well as member rate.

[
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "616ad7c7-a694-495c-858b-cf9d85c9faf0",
        "daysWorked": null,
        "payments": [],
        "createdAt": "2021-04-23T10:08:11.700Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "e7ad4211-7297-46cb-9571-a3cfc331c721",
        "projectId": 16805,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "540442b3-fb33-4f59-9e8d-67f34e366f84",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.308Z",
                "amount": 13.23,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "26df11d1-c39e-4c47-aa10-9ece1ad2b1ae",
                "workPeriodId": "dd4f7bc4-e8b4-4f04-ae94-7b847900f78a",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.308Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.646Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "dd4f7bc4-e8b4-4f04-ae94-7b847900f78a",
        "projectId": 16857,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "f7fb37a9-cab4-4c71-a5ff-abe4985320c6",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.018Z",
                "amount": 99.62,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "50a7c99d-3276-474b-9498-dc9f174a9520",
                "workPeriodId": "ce66efdb-26c5-4cfd-9266-c398f4202acf",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.018Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.647Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "ce66efdb-26c5-4cfd-9266-c398f4202acf",
        "projectId": 16886,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "31cf931d-519e-476c-946b-70069e13695b",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.344Z",
                "amount": 1212,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "fa5293a5-21ed-4fce-b9bf-c2731108966e",
                "workPeriodId": "cc40b3cb-a88d-47c6-8e13-b970918f75f9",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.344Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:12.003Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "cc40b3cb-a88d-47c6-8e13-b970918f75f9",
        "projectId": 16879,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "88422344-c6e6-430a-af68-18e05368f662",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.150Z",
                "amount": 4,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "177f5681-c852-4e65-b7d4-5502ded23f3a",
                "workPeriodId": "81aa3330-60ea-450b-afa3-50529f0152e2",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.150Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.502Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "81aa3330-60ea-450b-afa3-50529f0152e2",
        "projectId": 16882,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "6b255242-a72a-4af3-8ee6-523cf2c7de3c",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.186Z",
                "amount": 9,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "6c610cff-4e39-419a-ba46-ee90cbfc807d",
                "workPeriodId": "75c44a3b-30e6-45de-ab8d-edfadaa3b33a",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.186Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.640Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "75c44a3b-30e6-45de-ab8d-edfadaa3b33a",
        "projectId": 16893,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "dc683ecd-8aa7-40de-8a26-b8b9ffb3fa81",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.103Z",
                "amount": 4444,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "ea05c896-9155-4b45-838d-6854499e3794",
                "workPeriodId": "441894f7-a973-46b7-8a24-0a9aa28b1b07",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.103Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:10.624Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "441894f7-a973-46b7-8a24-0a9aa28b1b07",
        "projectId": 16885,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "d8e102c1-c354-4b76-8a7d-37f312da4342",
        "daysWorked": null,
        "payments": [],
        "createdAt": "2021-04-23T10:08:11.645Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "150714cc-d7ac-4b7a-9823-0ee8703afae3",
        "projectId": 16879,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    }
]

@maxceem @nkumar-topcoder This is not the case for all Batch payment query but raised this issue as I can't find the root cause of failure.

[nkumar-topcoder]

@sandhiyakavi can you please re-try the exact test-case let me know.
this was fixed y'day evening.

[sandhiyakavi]

@nkumar-topcoder I tried the scenario again

I am getting same result but yesterday's data is displaying now (For today it's not created again)RB id: 616ad7c7-a694-495c-858b-cf9d85c9faf0

response:

[
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "616ad7c7-a694-495c-858b-cf9d85c9faf0",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.231Z",
                "challengeId": null,
                "amount": 0,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "c64ae149-cd79-4ebb-8a84-be6f8ba45a1b",
                "workPeriodId": "e7ad4211-7297-46cb-9571-a3cfc331c721",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.231Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.700Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "e7ad4211-7297-46cb-9571-a3cfc331c721",
        "projectId": 16805,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "540442b3-fb33-4f59-9e8d-67f34e366f84",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.308Z",
                "challengeId": null,
                "amount": 13.23,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "26df11d1-c39e-4c47-aa10-9ece1ad2b1ae",
                "workPeriodId": "dd4f7bc4-e8b4-4f04-ae94-7b847900f78a",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.308Z"
            },
            {
                "createdAt": "2021-06-08T07:44:36.043Z",
                "amount": 13.23,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "7a3826f4-f089-4a8d-afed-2e742b6f7f49",
                "workPeriodId": "dd4f7bc4-e8b4-4f04-ae94-7b847900f78a",
                "status": "scheduled",
                "updatedAt": "2021-06-08T07:44:36.043Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.646Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "dd4f7bc4-e8b4-4f04-ae94-7b847900f78a",
        "projectId": 16857,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "f7fb37a9-cab4-4c71-a5ff-abe4985320c6",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.018Z",
                "challengeId": null,
                "amount": 99.62,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "50a7c99d-3276-474b-9498-dc9f174a9520",
                "workPeriodId": "ce66efdb-26c5-4cfd-9266-c398f4202acf",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.018Z"
            },
            {
                "createdAt": "2021-06-08T07:44:34.066Z",
                "amount": 99.62,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "5a5863dd-fd49-41c0-b9f0-94fc5062d6c6",
                "workPeriodId": "ce66efdb-26c5-4cfd-9266-c398f4202acf",
                "status": "scheduled",
                "updatedAt": "2021-06-08T07:44:34.066Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.647Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "ce66efdb-26c5-4cfd-9266-c398f4202acf",
        "projectId": 16886,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "31cf931d-519e-476c-946b-70069e13695b",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.344Z",
                "challengeId": null,
                "amount": 1212,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "fa5293a5-21ed-4fce-b9bf-c2731108966e",
                "workPeriodId": "cc40b3cb-a88d-47c6-8e13-b970918f75f9",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.344Z"
            },
            {
                "createdAt": "2021-06-08T07:44:36.101Z",
                "amount": 1212,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "bf56ca53-7246-4af0-afe8-2c88e096c58c",
                "workPeriodId": "cc40b3cb-a88d-47c6-8e13-b970918f75f9",
                "status": "scheduled",
                "updatedAt": "2021-06-08T07:44:36.101Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:12.003Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "cc40b3cb-a88d-47c6-8e13-b970918f75f9",
        "projectId": 16879,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "88422344-c6e6-430a-af68-18e05368f662",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.150Z",
                "challengeId": null,
                "amount": 4,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "177f5681-c852-4e65-b7d4-5502ded23f3a",
                "workPeriodId": "81aa3330-60ea-450b-afa3-50529f0152e2",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.150Z"
            },
            {
                "createdAt": "2021-06-08T07:44:35.715Z",
                "amount": 4,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "989079fb-2f35-4540-8e2d-792439e442ee",
                "workPeriodId": "81aa3330-60ea-450b-afa3-50529f0152e2",
                "status": "scheduled",
                "updatedAt": "2021-06-08T07:44:35.715Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.502Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "81aa3330-60ea-450b-afa3-50529f0152e2",
        "projectId": 16882,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "6b255242-a72a-4af3-8ee6-523cf2c7de3c",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.186Z",
                "challengeId": null,
                "amount": 9,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "6c610cff-4e39-419a-ba46-ee90cbfc807d",
                "workPeriodId": "75c44a3b-30e6-45de-ab8d-edfadaa3b33a",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.186Z"
            },
            {
                "createdAt": "2021-06-08T07:44:35.773Z",
                "amount": 9,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "47440487-988c-49a0-8e64-b6f8e378ac84",
                "workPeriodId": "75c44a3b-30e6-45de-ab8d-edfadaa3b33a",
                "status": "scheduled",
                "updatedAt": "2021-06-08T07:44:35.773Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:11.640Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "75c44a3b-30e6-45de-ab8d-edfadaa3b33a",
        "projectId": 16893,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "dc683ecd-8aa7-40de-8a26-b8b9ffb3fa81",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-07T07:13:00.103Z",
                "challengeId": null,
                "amount": 4444,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "ea05c896-9155-4b45-838d-6854499e3794",
                "workPeriodId": "441894f7-a973-46b7-8a24-0a9aa28b1b07",
                "status": "scheduled",
                "updatedAt": "2021-06-07T07:13:00.103Z"
            },
            {
                "createdAt": "2021-06-08T07:44:35.550Z",
                "amount": 4444,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "fe3bcecb-7876-4ab2-9e74-d13628cd3305",
                "workPeriodId": "441894f7-a973-46b7-8a24-0a9aa28b1b07",
                "status": "scheduled",
                "updatedAt": "2021-06-08T07:44:35.550Z"
            }
        ],
        "createdAt": "2021-04-23T10:08:10.624Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "441894f7-a973-46b7-8a24-0a9aa28b1b07",
        "projectId": 16885,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2021-02-06",
        "resourceBookingId": "d8e102c1-c354-4b76-8a7d-37f312da4342",
        "daysWorked": null,
        "payments": [],
        "createdAt": "2021-04-23T10:08:11.645Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "150714cc-d7ac-4b7a-9823-0ee8703afae3",
        "projectId": 16879,
        "startDate": "2021-01-31",
        "paymentStatus": "pending",
        "updatedAt": null
    }
]

[sandhiyakavi]

@nkumar-topcoder Tried with a fresh test data and total success count is displaying correctly now.

The 3 failures are due to BA not added in RB.

Response:

[
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "4f5bcc98-95d9-4304-8fda-f94051b983e6",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-08T08:45:23.539Z",
                "amount": 1500,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "c833f3a9-001d-434c-a5de-9583c90c54f2",
                "workPeriodId": "faff40a6-3ff0-4478-805b-64d2f8add310",
                "status": "scheduled",
                "updatedAt": "2021-06-08T08:45:23.539Z"
            }
        ],
        "createdAt": "2021-06-08T08:36:53.735Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "faff40a6-3ff0-4478-805b-64d2f8add310",
        "projectId": 17770,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-06-08T08:36:53.735Z"
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "ad0180f9-d3d2-4121-827d-3dea1232155e",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-08T08:45:23.464Z",
                "amount": 500,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "707bbd69-8c1a-453a-99c0-66e025269487",
                "workPeriodId": "e5198b9b-1d75-4fca-ae45-ca9ae134fe2f",
                "status": "scheduled",
                "updatedAt": "2021-06-08T08:45:23.464Z"
            }
        ],
        "createdAt": "2021-06-08T08:35:47.307Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "e5198b9b-1d75-4fca-ae45-ca9ae134fe2f",
        "projectId": 17770,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-06-08T08:35:47.307Z"
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "bbb491b6-dede-4229-ba3d-0ac7f7a86747",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-08T08:45:23.417Z",
                "amount": 1750,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "08658cd2-b9b7-41b7-be28-7f25deb770fe",
                "workPeriodId": "c419fe26-1a08-4b07-ac92-9d05ec48eed2",
                "status": "scheduled",
                "updatedAt": "2021-06-08T08:45:23.417Z"
            }
        ],
        "createdAt": "2021-06-08T08:35:17.167Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "c419fe26-1a08-4b07-ac92-9d05ec48eed2",
        "projectId": 17770,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-06-08T08:35:17.167Z"
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "6ba2c8d2-3040-4d9e-aaf6-67db2752ae09",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-08T08:45:23.506Z",
                "amount": 1000,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "4ce777a1-6797-47a6-af53-b97ef4d86368",
                "workPeriodId": "ad547123-6b3f-46a5-9130-b4c20eb9d954",
                "status": "scheduled",
                "updatedAt": "2021-06-08T08:45:23.506Z"
            }
        ],
        "createdAt": "2021-06-08T08:36:23.776Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "ad547123-6b3f-46a5-9130-b4c20eb9d954",
        "projectId": 17770,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-06-08T08:36:23.776Z"
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "229feb2d-26f1-4d25-b1ec-2779503293ed",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-08T08:45:23.581Z",
                "amount": 1250,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "6f3a5f92-64f1-48df-8988-4b55b537aeb1",
                "workPeriodId": "544fd58d-d3ba-4ced-a74d-53511d5683dc",
                "status": "scheduled",
                "updatedAt": "2021-06-08T08:45:23.581Z"
            }
        ],
        "createdAt": "2021-06-08T08:37:22.525Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "544fd58d-d3ba-4ced-a74d-53511d5683dc",
        "projectId": 17770,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-06-08T08:37:22.525Z"
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "4cde8a7c-8f6a-4a25-af7a-9314e157a0af",
        "daysWorked": null,
        "payments": [],
        "createdAt": "2021-04-23T10:08:10.618Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "52a23e10-724f-42eb-bfcc-2db8864d82f8",
        "projectId": 17263,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": null
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "ab22f58e-16ad-435a-b51c-2cfa7e0b1f99",
        "daysWorked": null,
        "payments": [],
        "createdAt": "2021-05-20T09:27:34.607Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "29296190-b8a9-4f46-8169-3db966045254",
        "projectId": 17343,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-05-20T09:27:34.607Z"
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "0f87aa96-fd79-47e5-961f-5edb9a3fbc7c",
        "daysWorked": null,
        "createdAt": "2021-06-08T08:37:50.133Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "1dc7cf4d-09ad-4e79-a7ac-e6f4bd131e5d",
        "projectId": 17770,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-06-08T08:37:50.133Z"
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "edfdd2b6-e5f2-4ded-8e3b-42b04e37301f",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-08T08:45:23.293Z",
                "amount": 250,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "8faf8ee7-e9af-4d9a-9379-32e11e6e530e",
                "workPeriodId": "13a91f08-a2e3-48f9-8358-967229998f17",
                "status": "scheduled",
                "updatedAt": "2021-06-08T08:45:23.293Z"
            }
        ],
        "createdAt": "2021-06-08T08:34:19.028Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "13a91f08-a2e3-48f9-8358-967229998f17",
        "projectId": 17770,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-06-08T08:34:19.028Z"
    },
    {
        "userHandle": "pshah_manager",
        "updatedBy": null,
        "endDate": "2024-02-03",
        "resourceBookingId": "e026915e-08c3-4002-b25f-9ef20a9267b2",
        "daysWorked": null,
        "payments": [
            {
                "createdAt": "2021-06-08T08:45:23.368Z",
                "amount": 500,
                "challengeId": null,
                "updatedBy": null,
                "createdBy": "71c5e6a8-51d9-4fb5-91ce-d974642531af",
                "billingAccountId": 80000068,
                "id": "29f55c4f-7673-4b32-94d4-7c87d7f324fb",
                "workPeriodId": "0f25cf5c-d750-4899-b133-62b882b981e4",
                "status": "scheduled",
                "updatedAt": "2021-06-08T08:45:23.368Z"
            }
        ],
        "createdAt": "2021-06-08T08:34:46.505Z",
        "memberRate": null,
        "createdBy": "00000000-0000-0000-0000-000000000000",
        "customerRate": null,
        "id": "0f25cf5c-d750-4899-b133-62b882b981e4",
        "projectId": 17770,
        "startDate": "2024-01-28",
        "paymentStatus": "pending",
        "updatedAt": "2021-06-08T08:34:46.505Z"
    }
]

[nkumar-topcoder]

we changed the wp payment topic partition to 1 and Post re-index the issue has been resolved.

[sandhiyakavi]

Verified on Prod Env with @nkumar-topcoder . count is displaying correctly