Lockbox Payment Reversal Process Is Not Supported As Per NACHA Stated Regulation For File Structure (Doc ID 3064503.1)

Last updated on DECEMBER 21, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Lockbox payment reversal process is not supported as per NACHA stated regulation for File structure

Issue - As per NACHA mandates for Payment reversals, NACHA file is prepared with Detail record (6) as well as Addenda Record (7). Record 8 as per NACHA mandates that field "Entry/Addenda Count - start position 5" should be total of Detail and Addenda record however when batch job "LBXPRC_BJ_100_01" and "TXNNSF_BJ_100_01" is executed, the File is displaying "Processed Error" and throwing error "Payment batch created, Mismatched Totals" and "Group Totals not matching"

This issue is causing major hindrance to customer as they are not able to proceed with Payment reversals.

EXPECTED BEHAVIOR
-----------------------
NACHA standard for payment reversal should be accommodated by OFSLL process. Record 8: Field "Entry/Addenda Count" should be total of detail and addenda record (reversal) and process should not fail with Error "Total not matching".

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Step 1. Place the ACH file as per NACHA standard requirement.
Step 2. Execute SET-LBT batch job to run.
Step 3. SET-LBT: TXNNSF_BJ_100_01 batch job should run, and batch job is should not Failed with error Payment batch created, Mismatched Totals" and "Group Totals not matching".

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have NACHA standard for payment reversal accommodated by OFSLL process. Record 8: Field "Entry/Addenda Count" should be total of detail and addenda record (reversal).

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.