Task #1251

RIB - Running Invalid Check Digit in RIB ASTRO

Added by Norhaidah Md Dasuki almost 13 years ago. Updated over 12 years ago.

Status:Work Completed-End life cycleStart date:October 28, 2011
Priority:NormalDue date:
Assignee:Firdaus Muhammad Riza Aulya% Done:

100%

Category:Bill PaymentsSpent time:-
Target version:-

Description

Related to SIT:Redmine - http://10.6.6.20:8080/redmine/issues/81

Issue: Test Case: 12-d-d

Bill Payment = ASTRO
Account No = 0800555673 23/10/2011 – Transaction successful.

This transaction should be unsuccessfull because of invalid Bill account (wrong check digit).

ASTRO_Check_Digit_Calculation.doc (22 KB) Firdaus Muhammad Riza Aulya, November 03, 2011 10:46

SATU_Check_Digit_Calculation.doc (29.5 KB) Firdaus Muhammad Riza Aulya, November 16, 2011 17:22

AKSB_Check_Digit_Calculation.doc (36 KB) Norhaidah Md Dasuki, December 14, 2011 12:28

LAP_Check_Digit_Calculation.doc (29 KB) Norhaidah Md Dasuki, December 14, 2011 12:28

SAJ_Check_Digit_Calculation.doc (25 KB) Norhaidah Md Dasuki, December 14, 2011 12:28

SAMB_Check_Digit.pdf (49.5 KB) Norhaidah Md Dasuki, December 14, 2011 12:28

PBAPP_Check_Digit_Calculation.doc (24.5 KB) Norhaidah Md Dasuki, December 15, 2011 11:07

SESB_Check_Digit_Calculation.doc (31.5 KB) Norhaidah Md Dasuki, December 28, 2011 12:07

History

#1 Updated by Tan Lee Yong almost 13 years ago

  • Assignee changed from Tan Lee Yong to Nazri Imran

After tested, please assign to Ayu for internal testing on check digit for all payees and insurance.

#2 Updated by Tan Lee Yong almost 13 years ago

  • Assignee changed from Nazri Imran to Firdaus Muhammad Riza Aulya

#3 Updated by Firdaus Muhammad Riza Aulya almost 13 years ago

Formula has been update,
0800555673 is valid account number for ASTRO, please refer to ASTRO check digit file.

#4 Updated by Firdaus Muhammad Riza Aulya almost 13 years ago

  • Status changed from New - Begin Life Cycle to Internal Testing
  • Assignee changed from Firdaus Muhammad Riza Aulya to Siti Norahayu Mohd Desa

Hi Ayu,

Kindly test.

#5 Updated by Siti Norahayu Mohd Desa almost 13 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Siti Norahayu Mohd Desa to Firdaus Muhammad Riza Aulya

Test on check digit validation.

TELCOS :
1) Celcom - Passed
2) TMNET - Passed
3) Telekom - Passed

UTILITIES :
Astro - Passed
SESCO - Passed
PUAS/SYABAS - Passed
JBA Pahang - Passed
SAINS - Passed but with error message "Transaction is declined. [1]"

*Sabah elektrik - cannot test check digit due to Invalid Bill Account Number.

LIST B (Payee w/o CD)
TNB - check digit not available
SESB - check digit not available
LAP - check digit not available
AIR KELANTAN SDN. BHD. - check digit not available
JBA KEDAH - check digit not available
PTPTN - cannot test check digit due to no account number provided.
Syarikat Air Johor - check digit not available
Syarikat Air Terengganu - check digit not available
Syarikat Air Melaka Berhad SAMB - check digit not available

LIST C (Payee w/o acc no.)
MP Johor Baru Tengah - cannot test check digit due to no account number provided.
MP Kuantan - cannot test check digit due to no account number provided.
MP Ampang Jaya - cannot test check digit due to no account number provided.
MP Shah Alam - cannot test check digit due to no account number provided.
MP Selayang - cannot test check digit due to no account number provided.

Hi Riza,
Please continue to do the check digit for the payee under List B.
We also found a double notes that mention false message.

#6 Updated by Firdaus Muhammad Riza Aulya almost 13 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Firdaus Muhammad Riza Aulya to Siti Norahayu Mohd Desa

Dear Ayu,

Please re-test all the payee, except those payee doesn't have check digit.

Following are the info you need to make bill payment for different payees:
===TELCO===
TMNET = 20110508111104
CELCOM = 118622406
Telekom = D918919870107

===UTILITIES===
ASTRO = 0800555673
TNB = 21400084624409
AKBS = 133989402233988
JPA PAHANG = 0121201859
LAP = 10542033SR0142036
PTPTN = 016907100753717
PUAS SYABAS = 0000229287018
SESCO = 100000543841
SAJ = 98862929J7134978
SAMB = 1241275841012745
SAINS = 05039475480100
SATU = 0501948779 & 050111430 (Air Terengganu)

NO CHECK DIGIT FORMULA GIVEN YET
Sabah Electricity Sdn Bhd
Syarikat Air Pulau Pinang
JBA Kedah
MP Johor Baru Tengah
MP Kuantan
MP Ampang Jaya
MP Shah Alam
MP Selayang

#7 Updated by Siti Norahayu Mohd Desa almost 13 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Siti Norahayu Mohd Desa to Firdaus Muhammad Riza Aulya

ASTRO = 0800555673 - passed
SESCO = 100000543841 - passed
PUAS SYABAS = 0000229287018 - passed
JPA PAHANG = 0121201859 - passed
TNB = 21400084624409 - passed
AKBS = 133989402233988 - passed
LAP = 10542033SR0142036 - passed
PTPTN = 016907100753717 - passed
SAJ = 98862929J7134978 - passed
SAMB = 1241275841012745 - Transaction is declined. [1]
SAINS = 05039475480100 - Transaction is declined. [1]

*SATU = 0501948779 & 050111430 (Air Terengganu)- Failed
Actual - Last digit of SATU Account number can proceed to payment
Expected - Validate the last/every digit of account number.

#8 Updated by Firdaus Muhammad Riza Aulya almost 13 years ago

  • File SATU_Check_Digit_Calculation.doc added
  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Firdaus Muhammad Riza Aulya to Siti Norahayu Mohd Desa

Kindly please re-test SATU and SAMB check digit in the bill payment.

Thank you.

Update:

SATU* checkdigit has been updated, now required 14 digits of account number and 9 digits bill numbers. According to the SATU check digit formula (attachment), the last 4 digits is registration year and not involve in the check digit calculation.
Allow dash for account number field --> preferable test using SAMB account number (refer to the sample bill given)

SATU = 05019487792005 & 050111430

#9 Updated by Siti Norahayu Mohd Desa almost 13 years ago

  • Status changed from Internal Testing to Work Completed-End life cycle
  • Assignee changed from Siti Norahayu Mohd Desa to Norhaidah Md Dasuki

SATU - Validate check digit for bill number only while check digit for account number, the last 4digit cant be validate.
Regarding to Riza, for account number it cant validate the last four digit. The last 4digit is check for year registration.

TQ.

#10 Updated by Norhaidah Md Dasuki almost 13 years ago

  • Status changed from Work Completed-End life cycle to Development / Work In Progress
  • Assignee changed from Norhaidah Md Dasuki to Tan Lee Yong
  • % Done changed from 100 to 70

This task need to open back due to request from SIT team that need us to complete the check digit for all Payee listed. Based on Muhaimin, he will check with PMO team on the account number and formula.

#11 Updated by Tan Lee Yong almost 13 years ago

  • Status changed from Development / Work In Progress to Pending Review
  • Assignee changed from Tan Lee Yong to Norhaidah Md Dasuki

Please open a new task under enhancement. This task is pending on Muhaimin to provide all the formula.

#12 Updated by Norhaidah Md Dasuki almost 13 years ago

Hi Lee Yong,

I have open new task under enhancement @ http://10.6.6.20:8080/redmine/issues/252

Check Digit Validation.

TELCOS:
1) Celcom - Successful
2) TMNET - Successful
3) Telekom - Unsuccessful (Format Attached)

UTILITIES
1) Astro - Successful
2) JBA Pahang - Successful
3) PUAS - Successful
4) SESCO - Successful
5) TNB Malaysia - Successful
6) SAINS - Successful

7) AKSB - Unsuccessful (Format Attached)
8) LAP - Unsuccessful (Format Attached)
9) Sabah Electricity - Unsuccessful (Format Attached)
10) SA Johor - Unsuccessful (Format Attached)
11) SAMB - Unsuccessful (Format Attached)
12) SA Terengganu - Unsuccessful (Format Attached)

13) JBA Kedah - Unsuccessful (Pending)
14) MP Ampang Jaya - Unsuccessful (Pending)
15) MP JB Tengah - Unsuccessful (Pending)
16) MP Kuantan - Unsuccessful (Pending)
17) MP Selayang - Unsuccessful (Pending)
18) MP Shah Alam - Unsuccessful (Pending)
19) SA P.Pinang - Unsuccessful (Pending)

Plz refer to the attachment on the check digit format for below payee;
1. Telekom
2. Air Kelantan SB
3. Lembaga Air Perak
4. Sabah Electricity
5. Syarikat Air Johor
6. Syarikat Air Melaka
7. Syarikat Air Terengganu

The others payee is pending from Muhaimin (Agrobank) to provide. TQ

#13 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian almost 13 years ago

  • Status changed from Development / Work In Progress to Work Completed-End life cycle

#14 Updated by Norhaidah Md Dasuki almost 13 years ago

  • File PBAPP_Check_Digit_Calculation.doc added
  • Status changed from Work Completed-End life cycle to Development / Work In Progress
  • Assignee changed from Tan Lee Yong to Firdaus Muhammad Riza Aulya

Update by Muhaimin,

Check digit for Air P. Pinang

Hi Riza,
Kindly assist to setup check digit for SA P.Pinang. TQ.

#15 Updated by Norhaidah Md Dasuki over 12 years ago

Attached is the SESB Check Digit Formula.

Please also take notes that I noticed that the update on BILL Payment page at IBAM/RIB is not synchronize between SIT, UAT, DR and PRO. Example: No sample image in DR/PRO RIB. For JAB Air Kedah, check digit setup at SIT/UAT but not in DR/PRO.

Ayu,
Kindly work on this issue with programmer and fix it. TQ

#16 Updated by Firdaus Muhammad Riza Aulya over 12 years ago

  • Status changed from Development / Work In Progress to Work Completed-End life cycle
  • % Done changed from 70 to 100

Also available in: Atom PDF