Support #12855

[SCP ID :##6190##] : Verify invalid data during EOD

Added by Zahir Abd Latif over 2 years ago. Updated over 2 years ago.

Status:Work Completed-End life cycleStart date:March 10, 2022
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:System EnhancementSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

Request to skip invalid data during EOD.

AUTOCR File Error.msg (95.5 KB) Zahir Abd Latif, March 10, 2022 16:41

BULK_PAYMENT_250322110249.data-update.txt Magnifier (610 Bytes) Nurul Athira Abdul Rahim, March 25, 2022 16:20

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.

Test step:
  1. Access BSNeBiz > Bulk Payment > Data entry / File upload
  2. Create payment with at least 3 data
  3. Try to enter account number as alphanumeric. IE 123456789ABC
  4. Expected result, BSNeBiz will show error message
  5. Fix the payment data with valid account number
  6. Approve the payment
  7. Request developer to change account number to alphanumeric in database
  8. Access IBAM and submit EOD
  9. Access batch server to get the AUTO_CR file
  10. 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

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:
  1. Access BSNeBiz > Bulk Payment > File upload
  2. Create payment with at least 3 data
  3. Try to enter account number as alphanumeric. IE 123456789ABC
  4. Expected result, BSNeBiz will allow account number as alphanumeric
  5. Expected result, BSNeBiz will show error message. Will add File upload error after testing alphanumeric in EOD
  6. Retry with valid account number
  7. Approve the payment
  8. Access IBAM and submit EOD
  9. Download the EOD report
  10. Expected result, the report remove the invalid account number from total transaction and amount
  11. Expected result, the report total record and amount same as the uploaded file.
  12. Access batch server to get the AUTO_CR file
  13. 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

  1. Access IBAM>BBE>Content>File Format
  2. Search the following and open details page-IBG, SGB_AUTO_CREDIT, SGB_SKDG, WDH_AUTO_CREDIT, WDH_SKDG
  3. Search the field CUSTOMER ACCOUNT and make sure the data type is numeric
  4. Access BSNeBiz>Bulk Payment>FIle Upload
  5. Upload file containing alphanumeric account number 
  6. Expected result, error message field is not numeric will show
  7. 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

Also available in: Atom PDF