Support #12855
[SCP ID :##6190##] : Verify invalid data during EOD
Status: | Work Completed-End life cycle | Start date: | March 10, 2022 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | System Enhancement | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
Request to skip invalid data during EOD.
History
#1 Updated by Nurul Athira Abdul Rahim over 2 years ago
- Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
#2 Updated by Najmi Pasarudin over 2 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#3 Updated by Najmi Pasarudin over 2 years ago
- % Done changed from 0 to 90
Issue:
An org code in EOD bulk payment file missing footer
Finding:
The org code has invalid account number, it contains alphabet. Should be all numeric.
Solution:
Add validation for each line to skip invalid data.
- Access BSNeBiz > Bulk Payment > Data entry / File upload
- Create payment with at least 3 data
- Try to enter account number as alphanumeric. IE 123456789ABC
- Expected result, BSNeBiz will show error message
- Fix the payment data with valid account number
- Approve the payment
- Request developer to change account number to alphanumeric in database
- Access IBAM and submit EOD
- Access batch server to get the AUTO_CR file
- Expected result, AUTO_CR contains header, footer and valid account numbers.
#4 Updated by Najmi Pasarudin over 2 years ago
- Status changed from Development / Work In Progress to Pending SIT Deployment
#5 Updated by Najmi Pasarudin over 2 years ago
- Status changed from Pending SIT Deployment to Finished Development
#6 Updated by Najmi Pasarudin over 2 years ago
- Status changed from Finished Development to Development / Work In Progress
#7 Updated by Najmi Pasarudin over 2 years ago
- Status changed from Development / Work In Progress to Internal Testing
- Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
Refer to test steps in the comment on 16/03/2022
#8 Updated by Nurul Athira Abdul Rahim over 2 years ago
- File BULK_PAYMENT_250322110249.data-update.txt added
Tested and failed.
IBAM processed transaction with invalid account no (with alphabet).
#9 Updated by Nurul Athira Abdul Rahim over 2 years ago
- Status changed from Internal Testing to Development / Work In Progress
- Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
#10 Updated by Najmi Pasarudin over 2 years ago
- Status changed from Development / Work In Progress to Internal Testing
- Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
Test step:
- Access BSNeBiz > Bulk Payment > File upload
- Create payment with at least 3 data
- Try to enter account number as alphanumeric. IE 123456789ABC
- Expected result, BSNeBiz will allow account number as alphanumeric
Expected result, BSNeBiz will show error message. Will add File upload error after testing alphanumeric in EOD- Retry with valid account number
- Approve the payment
- Access IBAM and submit EOD
- Download the EOD report
Expected result, the report remove the invalid account number from total transaction and amount- Expected result, the report total record and amount same as the uploaded file.
- Access batch server to get the AUTO_CR file
- Expected result, AUTO_CR contains header, footer and valid account number
11/04/2022
Add BSNeBiz File upload validation, reject if the account number is not numeric
- Access IBAM>BBE>Content>File Format
- Search the following and open details page-IBG, SGB_AUTO_CREDIT, SGB_SKDG, WDH_AUTO_CREDIT, WDH_SKDG
- Search the field CUSTOMER ACCOUNT and make sure the data type is numeric
- Access BSNeBiz>Bulk Payment>FIle Upload
- Upload file containing alphanumeric account number
- Expected result, error message field is not numeric will show
- Repeat testing to BSNeBiz>Bulk Payment>Data Entry and Data Edit
#11 Updated by Nurul Athira Abdul Rahim over 2 years ago
- Category set to System Enhancement
#12 Updated by Nurul Syahirah Md Nawi over 2 years ago
- Status changed from Internal Testing to Pending Review
- Assignee changed from Nurul Athira Abdul Rahim to Nurul Syahirah Md Nawi
Production deployed on 13/5/22
#13 Updated by Nurul Syahirah Md Nawi over 2 years ago
- Status changed from Pending Review to Work Completed-End life cycle
- Assignee changed from Nurul Syahirah Md Nawi to Zahir Abd Latif
#14 Updated by Nurul Syahirah Md Nawi over 2 years ago
- % Done changed from 90 to 100