This DNAapp inactivates card authorization holds and runs through “File Loader”. It inactivates the hold by updating the AcctCardTxnHold.InactiveDateTime with the current oracle date/time.
This application matches the holds in the following sequence:
The Auth Code which is in filewarehouse record ‘702’, record type (ADD1), position 30 – 6 and the CardTxnNbr
Filewarehouse Trace Number and the CardTxn Trace Audit Number
Filewarehouse Amount and the AcctCardTxnHold Hold Amount
Transaction Amount with a 20% Variance
It inactivates the hold by updating the AcctCardTxnHold.InactiveDateTime with the current oracle date/time.
The output report will include the following detail information:
Account Number, Transaction Amount, Trace Number
Auth Code/Card Txn Nbr, Hold Amount, Hold Effective Date/Time
Count of Records In
Holds Not Found
Holds Updated, By Auth Code, By Trace and By Amount (and Variance)
Write Your Own Review
Only registered users can write reviews. Please, log in
This DNAapp is compatible with DNA 3.0 or higher. You will need to download and install the Configuration Toolkit which will configure DNA to load and manage DNAapps. This toolkit is included in the DNA release CD since DNA 3.3 and will be updated here whenever a more recent release is available.