In the first days of the month the test test_rhacm_get_account_remittance fails while check for total remittance in report.

2025/08/01 run: (Checks  remittance for 2025/07/31)

Remittance Report:
[{'orgId': '17496113', 'productId': 'rhacm', 'metricId': 'vCPUs', 'billingProvider': 'aws', 'billingAccountId': '746157280291', 'remittedValue': 192.0, 'accumulationPeriod': '2025-07', 'remittanceDate': '2025-07-31T23:00:26.787026Z', 'remittanceStatus': 'succeeded', 'remittanceErrorCode': 'null'}]
Total remittance: 192.0 

2025/08/02 run: (Checks  remittance for 2025/08/01)

Remittance Report:
[{'orgId': '17496113', 'productId': 'rhacm', 'metricId': 'vCPUs', 'billingProvider': 'aws', 'billingAccountId': '746157280291', 'remittedValue': 16.0, 'accumulationPeriod': '2025-07', 'remittanceDate': '2025-08-01T01:00:37.166378Z', 'remittanceStatus': 'succeeded', 'remittanceErrorCode': 'null'}, {'orgId': '17496113', 'productId': 'rhacm', 'metricId': 'vCPUs', 'billingProvider': 'aws', 'billingAccountId': '746157280291', 'remittedValue': 171.0, 'accumulationPeriod': '2025-08', 'remittanceDate': '2025-08-01T23:00:51.317426Z', 'remittanceStatus': 'succeeded', 'remittanceErrorCode': 'null'}]
Total remittance: 187.0 

2025/08/03 run: (Checks  remittance for 2025/08/02)

Remittance Report:
[{'orgId': '17496113', 'productId': 'rhacm', 'metricId': 'vCPUs', 'billingProvider': 'aws', 'billingAccountId': '746157280291', 'remittedValue': 192.0, 'accumulationPeriod': '2025-08', 'remittanceDate': '2025-08-02T23:00:13.839009Z', 'remittanceStatus': 'succeeded', 'remittanceErrorCode': 'null'}]
Total remittance: 192.0 

See http://ibutsu.insights.corp.redhat.com/project/3915c900-85fc-1222-833c-10d51af56f2e/results/3bff4e69-9728-4df3-b5c4-52a757ac148b#testHistory

The expected value is 197 but we got 187 (5 less of normal 192 value, 10 less than the expected value).

GABI Queries: 

gabi "SELECT * FROM events WHERE data->'product_tag' ? 'rhacm' AND org_id='17496113' AND record_date BETWEEN '2025-07-31T00:00:00.000000Z' AND '2025-08-01T23:59:59.999999Z'"

gabi "SELECT * FROM billable_usage_remittance WHERE org_id='17496113' AND product_id='rhacm' AND updated_at BETWEEN '2025-07-31T00:00:00.000000Z' AND '2025-08-01T23:59:59.999999Z'" 

• "account_number"    "org_id"    "product_id"    "metric_id"    "accumulation_period"    "sla"    "usage"    "billing_provider"    "billing_account_id"    "remitted_pending_value"    "remittance_pending_date"    "retry_after"    "tally_id"    "uuid"    "billed_on"    "error_code"    "status"    "updated_at"
  -----------------------------------------------------------------------------------------------------------------------
  6d-febe-48e4-b4d4-863b048f5171"    "fa93df57-f624-4c3f-bf1d-30dd33c01cf0"    "2025-07-31T22:00:02.994898Z"    ""    "succeeded"    "2025-07-31T22:00:03.009587Z"
  ""    "17496113"    "rhacm"    "vCPUs"    "2025-07"    "Premium"    "Production"    "aws"    "746157280291"    "8"    "2025-07-31T17:03:04.420241Z"    ""    "c024f5d9-38a8-4f65-838e-e2e5dffb8be5"    "20dc2c8d-5895-4e3b-bc11-7398773e0ab3"    "2025-07-31T19:00:13.219064Z"    ""    "succeeded"    "2025-07-31T19:00:13.234788Z"
  ""    "17496113"    "rhacm"    "vCPUs"    "2025-07"    "Premium"    "Production"    "aws"    "746157280291"    "8"    "2025-07-31T19:00:28.305393Z"    ""    "1a4fd8d4-63b9-483d-9955-0cf27c51ee5e"    "53eadec8-0c25-44c7-b7fe-ccf001e6513d"    "2025-07-31T21:00:02.919347Z"    ""    "succeeded"    "2025-07-31T21:00:02.931508Z"
  ""    "17496113"    "rhacm"    "vCPUs"    "2025-07"    "Premium"    "Production"    "aws"    "746157280291"    "8"    "2025-07-31T23:00:26.787026Z"    ""    "d960bcce-f60c-47ed-be6f-8de0249dc097"    "91c2c058-adf6-4db1-b038-2e05d46ccbcc"    "2025-08-01T01:00:13.3454Z"    ""    "succeeded"    "2025-08-01T01:00:13.406979Z"
  ""    "17496113"    "rhacm"    "vCPUs"    "2025-08"    "Premium"    "Production"    "aws"    "746157280291"    "3"    "2025-08-01T02:00:29.246358Z"    ""    "4e26755b-2f5f-494b-bf32-e3b506d56fff"    "c5a8a76c-fecd-4512-a89f-18e70af9b744"    "2025-08-01T03:20:53.183252Z"    ""    "succeeded"    "2025-08-01T03:20:53.19944Z"
  ""    "17496113"    "rhacm"    "vCPUs"    "2025-07"    "Premium"    "Production"    "aws"    "746157280291"    "8"    "2025-08-01T01:00:37.166378Z"    ""    "b162d1d9-7b48-4a9a-9c48-8d12ee3891d1"    "2903ebda-336b-44d7-af91-44a8f19a5660"    "2025-08-01T03:00:10.269222Z"    ""    "succeeded"    "2025-08-01T03:00:10.285491Z"
   

Same goes for ROSA (with different values)

See https://ibutsu.insights.corp.redhat.com/project/3915c900-85fc-1222-833c-10d51af56f2e/runs/91e7e8ca-72e4-43c0-9861-c7023d4c1987#classify-failures

Investigate the possible cause.