Support #11260: [SCP ID :##5555##] : EOD Auto Debit Wrong Hashtotal - BSN CDB Support - Penril Support System

Support #11260

[SCP ID :##5555##] : EOD Auto Debit Wrong Hashtotal

Added by Zahir Abd Latif almost 4 years ago. Updated almost 4 years ago.

Status:

Closed - End of life cycle

Start date:

September 22, 2020

Priority:

Normal

Due date:

Assignee:

Nurul Athira Abdul Rahim

% Done:

100%

Category:

Spent time:

Target version:

Description

Hi,
Kindly attend below request:-

EOD Auto Debit Wrong Hashtotal

AD - eod hash total.jpg (255 KB) Nurul Athira Abdul Rahim, September 24, 2020 17:34

History

#1 Updated by Nurul Athira Abdul Rahim almost 4 years ago

Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#2 Updated by Najmi Pasarudin almost 4 years ago

Status changed from New - Begin Life Cycle to Development / Work In Progress
% Done changed from 0 to 90

Issue:
EOD Auto Debit calculate wrong hash total.

Finding:
CDB EOD will calculate using last 4 digit of account number.
When writing EOD file, EOD cronjob will append zero after account number if less than 16 digit.
ICBS will calculate using the appended account number.
Thus causing hash total problem.

Solution:
Pending JTM feedback on how to handle account number with less than 16 digit since some account number ending with zero.

#3 Updated by Najmi Pasarudin almost 4 years ago

Status changed from Development / Work In Progress to Internal Testing
Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Issue:
EOD Auto Debit calculate wrong hash total.

Finding:
User can upload Auto Debit file with customer account less than 16 digits.
EOD calculate hash total BEFORE append zero to customer account to fill in 16 digits.
ICBS calculate hash total using customer account AFTER appended with zero.

Solution:

In IBAM>BBE>Content>File Format>AUTO_DB, change Customer account alignment from LEFT to RIGHT
Fix EODProcessing.jar to handle hash total for both alignment LEFT and RIGHT

Test scenario:

Via CDB or IBAM, upload Auto Debit file with customer account both 16 digits and less than 16 digits.
In IBAM, run EOD
In Batch server, pickup Auto Debit EOD file from batch/BSN/BatchFilesSIT
Using last 4 digit from all customer account, calculate the total
Expected result, the last 4 digit of sum should match last 4 digit of the footer

Note: Customer account in EOD file if before branch code.
Example branch code, M100, L100, K100