Enhancement #5460

Virtual Account

Added by Tan Lee Yong about 9 years ago. Updated almost 8 years ago.

Status:Closed - End of life cycleStart date:September 09, 2015
Priority:NormalDue date:June 09, 2016
Assignee:Avatar?id=2607&size=14Rayvandy Gabbytian % Done:

100%

Category:-Spent time:49.00 hours
Target version:-

CR - RMBP M2u - Transfer to VA_20150819090906.pdf (2.06 MB) Rayvandy Gabbytian , September 01, 2015 19:39

PG ISO8583 Message Format v1.3.doc (506 KB) Rayvandy Gabbytian , September 07, 2015 18:55

VA Test Data.rtf (14.1 KB) Rayvandy Gabbytian , September 07, 2015 18:59

2015-10-07 - VA Test Result UAT.zip (763 KB) Rayvandy Gabbytian , October 07, 2015 22:51

History

#1 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 9 years ago

Dear Kah Yan,

Requirement as per attached. For technical document (mapping to backend) will be sent later. Please remind me on this.

Thank you.

#2 Updated by Yap Kah Yan about 9 years ago

Please advice on the scope of work. Thank you.

#3 Updated by Yap Kah Yan about 9 years ago

no SI for this service

#4 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 9 years ago

Dear Kah Yan,

Integration doc as attached. Use ESBPostpaid service (shall be similar to utility, or mobile postpaid payment):
- Details page,
- Confirm page (inquiry service call to get virtual account holder info),
- Result page (payment service call to make payment).

Thank you.

#5 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 9 years ago

Kahyan,

VA Test Data as attached.

Thank you.

#6 Updated by Yap Kah Yan about 9 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

Set up VPN Connection to bii
Complete hibernate mapping & table design

#7 Updated by Yap Kah Yan about 9 years ago

  • Start date changed from September 07, 2015 to September 09, 2015

#8 Updated by Yap Kah Yan about 9 years ago

finish transfer part of the module.
Pending on how to enquire on own Virtual Account (to appear in dropdown list)

#9 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 9 years ago

Dear Kah Yan,

Kindly push the changes to mercurial. Leave the integration for a while, because connection is still not yet open.

Thank you.

#10 Updated by Yap Kah Yan about 9 years ago

Dear Gabby,

Kindly provide the credentials to login to RIB,
for me to test the page flow before I push the codes.

Thank you.

#11 Updated by Yap Kah Yan about 9 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Yap Kah Yan to Rayvandy Gabbytian
  • % Done changed from 0 to 80

Dear Gabby,

The part on transfer limit is not developed. Kindly let me know if its part of the requirement.
Please note the codes pushed to mercurial are not tested.

1. Kindly assist to create the service info through IBAM

Service Code Service Name
VIRTUALOPEN Open Virtual Account Transfer
VIRTUALFAV Registered Virtual Account Transfer
VIRTUALMAINT Virtual Account Maintenance
VIRTUALMAINTADD Virtual Account - Add
VIRTUALMAINTEDIT Virtual Account - Edit
VIRTUALMAINTDEL Virtual Account - Delete

MVIRTUALOPEN Open Virtual Account Transfer
MVIRTUALFAV Registered Virtual Account Transfer
MVIRTUALMAINT Virtual Account Maintenance
MVIRTUALMAINTADD Virtual Account - Add
MVIRTUALMAINTEDIT Virtual Account - Edit
MVIRTUALMAINTDEL Virtual Account - Delete

2. Add in hibernate:
<mapping resource="net/penril/ibss/core/hibernate/IbVirtualAccounts.hbm.xml"/>
<mapping resource="net/penril/ibss/core/hibernate/IbVirtualTransfer.hbm.xml"/>

3. Query to create the tables
CREATE TABLE "DBO"."IB_VIRTUAL_TRANSFER"
(
TRNX_ID varchar(20) PRIMARY KEY NOT NULL,
TRNX_TYPE varchar(255) NOT NULL,
TRNX_DATE timestamp NOT NULL,
USER_ID decimal(19,0) NOT NULL,
FROM_ACCOUNT_NO varchar(64) NOT NULL,
TO_ACCOUNT_NO varchar(64) NOT NULL,
AMOUNT decimal(31,6) NOT NULL,
REFERENCE varchar(256),
STATUS varchar(64) NOT NULL,
EFFECTIVE_DATE timestamp,
REMOTE_IP varchar(64),
PHX_REFERENCE_NO decimal(19,0),
OTHER1 varchar(50),
OTHER2 varchar(50),
DESCRIPTION varchar(256),
SERVICE_CODE varchar(10),
REASON varchar(250),
FROM_CURRENCY varchar(5),
TO_CURRENCY varchar(5),
LOCAL_AMOUNT decimal(31,6),
FROM_ACC_CRT_DT timestamp,
TO_ACC_CRT_DT timestamp,
ACCOUNT_HOLDER_NAME varchar(50),
EMAIL varchar(50),
SI_INDICATOR varchar(2),
REMARKS varchar(100),
FROM_AMOUNT decimal(31,6),
TO_AMOUNT decimal(31,6),
OTHER3 varchar(225)
);
CREATE UNIQUE INDEX PK_IB_VIRTUAL_TRANSFER ON "DBO"."IB_VIRTUAL_TRANSFER"(TRNX_ID);

CREATE TABLE "DBO"."IB_VIRTUAL_ACCOUNTS"
(
USER_ID decimal(19,0) NOT NULL,
ACCOUNT_NO varchar(25) NOT NULL,
ACCOUNT_NICKNAME varchar(64),
ACCOUNT_HOLDER_NAME varchar(200),
EMAIL_ADDRESS varchar(64),
LAST_MOD_TIME timestamp,
MOBILE_NO varchar(20),
VIRTUAL_ACC_REF varchar(255),
VIRTUAL_ACC_STRCOL1 varchar(255),
VIRTUAL_ACC_STRCOL2 varchar(255),
ACCOUNT_TYPE varchar(2),
ACCOUNT_LIMIT decimal(15,2),
ACCOUNT_CURRENCY varchar(3)
);
CREATE UNIQUE INDEX PK_IB_VIRTUAL_ACCOUNTS ON "DBO"."IB_VIRTUAL_ACCOUNTS"
(
USER_ID,
ACCOUNT_NO
);

--Open VA
INSERT INTO DBO.IB_NAVIGATION VALUES ('220', '160', 'Virtual Account', 'Virtual Account', 'Transfer to Virtual Account', 'Transfer to Virtual Account', '1', '0', 'BII.FT06', '10', '/ib104/ibVirtualTransferDetails.do?transferType=open', '1', null, null, '1', 'offline', 'offline', '1', '0', '0', '1', '12', '12', null, null, '1', '0', '1', '1', null, null, null, null, '0');

INSERT INTO DBO.IB_NAVIGATION_GROUP VALUES (1, 220, 0, 0, 'BII.FT06');
INSERT INTO DBO.IB_NAVIGATION_GROUP VALUES (2, 220, 1, 0, 'BII.FT06');

--Maintenance VA
insert into "DBO"."IB_NAVIGATION" ("NODE_ID", "PARENT_ID", "NODE_NAME", "NODE_NAME_SL", "NODE_DESCRIPTION", "NODE_DESCRIPTION_SL", "NODE_TYPE", "NODE_STATUS", "NODE_CODE", "NODE_DISPLAY_ORDER", "PAGE_PATH", "OPERATION_HOUR", "OPERATION_START_TIME", "OPERATION_END_TIME", "WEEKEND", "OFFLINE_MESSAGE", "OFFLINE_MESSAGE_SL", "SMS_SERVICE_INDI", "NAVIGABLE", "QUICK_LINK", "QUICK_LINK_ORDER", "NODE_CREATED_BY", "NODE_UPDATED_BY", "NODE_CREATION_DATE", "NODE_UPDATED_DATE", "CATEGORY", "TOP_MENU", "DISPLAY_CHILD", "SHORTCUT", "SP_INSTRUCT", "NODE_ICON", "ACCESS_FUNCTION", "ACCESS_ROLE", "MK_PENDING") values(221, 176, 'Virtual Account', 'Favourite Virtual Account', 'Virtual Account Favorit', 'Favourite Virtual Account', 1, 0, 'BII.MFT05', 21, '/ib104/ibVirtualMaintSummary.do', 1, NULL, NULL, 1, 'offline', 'offline', '1', 0, 0, 1, 12, 12, NULL, '2015-10-06 18:26:50.868', 1, 0, 1, 1, NULL, NULL, NULL, NULL, 0)

INSERT INTO DBO.IB_NAVIGATION_GROUP VALUES (1, 221, 0, 0, 'BII.MFT05');
INSERT INTO DBO.IB_NAVIGATION_GROUP VALUES (2, 221, 1, 0, 'BII.MFT05');

--Favourite VA
INSERT INTO DBO.IB_NAVIGATION VALUES ('222', '160', 'Favourite Virtual Account', 'Virtual Account', 'Transfer to Virtual Account', 'Transfer to Virtual Account', '1', '0', 'BII.BFT06', '1', '/ib104/ibVirtualTransferDetails.do?transferType=registered', '1', null, null, '1', 'offline', 'offline', '1', '0', '0', '1', '12', '12', null, null, '1', '0', '1', '1', null, null, null, null, '0')

INSERT INTO DBO.IB_NAVIGATION_GROUP VALUES (1, 222, 0, 0, 'BII.BFT06')
INSERT INTO DBO.IB_NAVIGATION_GROUP VALUES (2, 222, 1, 0, 'BII.BFT06')

4. Translate the following to Indonesian in IBApplicationResources_in

ib104.virtual.account=Virtual Account
error.to.virtual.account.required=Virtual Account or To Account is required
error.virtual.account.invalid=Invalid virtual account number
sms.message.service.virtual.account=Virtual Account Transfer
general.bene.name=Bene Name
general.button.more.fav.virtual.list=More Favorite Virtual Account List

#12 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 9 years ago

  • Assignee changed from Rayvandy Gabbytian to Yap Kah Yan

Dear Kah Yan,

Service Info for VA have been added.

Thank you.

#13 Updated by Yap Kah Yan almost 9 years ago

  • Status changed from Internal Testing to Pending UAT Deployment
  • Assignee changed from Yap Kah Yan to Rayvandy Gabbytian

Dear Gabby,

Assigned to you as SIT is on your side.

Thank you.

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

Added virtual account favourite.

Test data: 7821081292955021

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

  • Status changed from Pending UAT Deployment to Development / Work In Progress
  • % Done changed from 80 to 100

Development completed. Pending user feedback:
- Limit setting.

Other pending task:
- RMBP development.

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

  • Status changed from Development / Work In Progress to User Acceptance Test
  • % Done changed from 100 to 0

Proceed with UAT.

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

UAT Result as per today, 7th October 2015. Screen capture as per attached.

Di History M2U tidak ada tombol reprint
Dan yang muncul hanya yang open, yang dari favorite tidak muncul
- Fixed, namun tidak bisa tes di UAT karena Credit Card sepertinya sedang batch. Saya simulasikan di local dengan bypass error -1 CC, hasil terlampir untuk open & fav.

Layar screen sukses VA di bawah ada tampilan seperti ini
Seharusnya itu kan tempat pendaftaran favorite
- Fixed. Root cause: link ter-insert huruf “T” di tengah.

Source Account VALAS masih bisa dipakai
Seharusnya tidak bisa
- Seingat saya, permintaan sebelumnya hanya jumlahnya saja yang di-lock ke IDR, untuk source account tidak. Namun sudah di filter sesuai dengan permintaan untuk source account.

Transaksi VA terkena biaya bukannya seharusnya tidak kena biaya
- Konfigurasi ada di sistem VA. Mohon bantuan tim untuk trace transaksi ke host.

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

  • Tracker changed from Task to Enhancement

#19 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 8 years ago

  • Status changed from User Acceptance Test to Work Completed-End life cycle

For VA is already deployed to production. However, for RMBP Maybank VA is pending to generate the .apk & .ipa using worklight 6.3.

#20 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 8 years ago

  • Status changed from Work Completed-End life cycle to Development / Work In Progress
  • Assignee changed from Rayvandy Gabbytian to Aditya Prathama

#21 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 8 years ago

  • Due date changed from September 18, 2015 to June 09, 2016

#22 Updated by Aditya Prathama over 8 years ago

  • % Done changed from 0 to 80

APK successfully Compiled. Issue already fixed, tested by user

IPA currently still fail, Update by Gabby

#23 Updated by Aditya Prathama almost 8 years ago

  • Status changed from Development / Work In Progress to Finished Development
  • Assignee changed from Aditya Prathama to Rayvandy Gabbytian

IPA success to compile

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

  • Status changed from Finished Development to Closed - End of life cycle
  • % Done changed from 80 to 100

Also available in: Atom PDF