FILE DUPLICATION ON HAWK_ETRANZACT
ITEM
FEEDBACK
Description
Upon conclusion of periodic reconciliation, eTranzact prompted us of a double debit to their account for their monthly tax remittance.
Upon further review, we discovered that the file was approved by eTranzact on the 17th of August and processed successfully. Incidentally, the same file was pushed to ABC Banks again on the 18th of August 2020.
Date
17th & 18th August, 2020
Status
Recovery has been done from eTranzact’s August tax remittance and the client advised accordingly.
Root Cause
A Unique Key constraint meant to forestall any duplication on the Hawk (FTP) DB table for captured files was not in place, as such the duplication occurred when said files were processed multiple times on different days by the application.
Actions to Forestall Recurrence
The Unique Key Constraint has been instated by the DB team and should forestall any future occurrence of such.
Impact
Distortion of tax remittance credit entries in the TSA account IFO eTranzact.
Recommendation
The Unique Key Constraint has been instated by the DB team and should forestall any future occurrence of such.