LCFS - Fix Missing Transaction for City of Victoria in TFRS-to-LCFS Migration

[AlexZorkin]

Description:
In the TFRS test migration to LCFS test, the City of Victoria is missing a transaction. This omission caused a missed reduction entry and led to an inflated “in reserve” balance in LCFS. This ticket focuses on identifying the source of the missing transaction and implementing a fix in the NiFi Groovy file to ensure data integrity.

Screenshots:

Purpose and benefit to user:
Accurate transaction records and proper balance calculations in LCFS ensure consistent financial and operational data for the City of Victoria and other entities within the system.

Acceptance Criteria:

• Given the user is an ETL operator, when the pipeline runs, then the missing transaction appears in LCFS without a balance discrepancy.
• Given the user is an ETL operator, when the fix is in place, then all reductions and “in reserve” amounts align with TFRS records in LCFS.

Development Checklist:

• Investigate the NiFi Groovy script to pinpoint the reason for the missing transaction.
• Update the Groovy file to include the City of Victoria’s missed reduction entry.
• Validate that the corrected ETL process accurately reflects the transaction and adjusts the “in reserve” balance.
• Confirm that no other transactions or balances experience similar discrepancies.

Notes:
Run test migrations to confirm the City of Victoria’s transaction appears correctly and that balance amounts match TFRS data.