Support #5289

[SCP ID :##2650##] : BVMC Report Inaccurate

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

Status:Closed - End of life cycleStart date:April 28, 2015
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:MY BVMCSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:

Please be informed that since the implementation of GST for IB on 17.04.2015,
 we encountered difficulty in our daily report recon as there were additional transactions
 were not reflected in the BVMC Internet Transaction Report and the total (volume & value) 
reflected were also incorrect in the BVMC Consolidated Transaction Report.

Sample given was based on report dated 27.04.2015:
- In IBFT Transaction Report: Found additional 15 transactions (successful & unsuccessful) were not
 reflected in the Internet Transaction Report
- In Interbank Funds Transfer Report: Found additional 12 transactions (successful & unsuccessful) were
 not reflected in the Internet Transaction Report
- In Consolidated Trx Report: Incorrect total (volume & value) for Intrabank & IBG transactions.

Please find attached the issue log and the BVMC reports for your further investigation.

HD00016010.rar (786 KB) Zahir Abd Latif, April 28, 2015 10:42

findings_2650.pdf (248 KB) Yap Kah Yan, April 29, 2015 12:24

IBSystem_bv_framework0.log@2015-04-27 (260 KB) Yap Kah Yan, April 29, 2015 12:24

IBSystem_bv_framework1.log@2015-04-27 (238 KB) Yap Kah Yan, April 29, 2015 12:24

IBSystem_bv_framework2.log@2015-04-27 (293 KB) Yap Kah Yan, April 29, 2015 12:24

IBSystem_bv_framework3.log@2015-04-27 (303 KB) Yap Kah Yan, April 29, 2015 12:24

report_Mon.log (996 KB) Yap Kah Yan, April 29, 2015 12:24


Related issues

Related to KFH Support - Support #5301: [SCP ID :##2660##] : CIB SI Consumer on 29/04/2015 Closed - End of life cycle April 30, 2015

History

#1 Updated by Yap Kah Yan over 9 years ago

BENE_NAME column too small.

Provide query to change 25 to 64 characters
ALTER TABLE IB_TRANSACTION_HISTORY MODIFY BENE_NAME VARCHAR2;

#2 Updated by Tan Lee Yong over 9 years ago

Hi Kah Yan,
There is no issue for so many years on the bene name for the length of 25. Now, look like front end allowed more than 25 characters but DB table didn't update the same to accept more than 25. Below are the 2 problems I can imagine with your solution:-
1) what is maximum allowable length on the Bene name in the JSP or any other interface or input data?
2) is there any maximum limit on the bene name on IBG and IBFT? If yes, what is the impact to allow more than 25 characters?

#3 Updated by Tan Lee Yong over 9 years ago

  • Assignee changed from Zahir Abd Latif to Yap Kah Yan

#4 Updated by Yap Kah Yan over 9 years ago

IB_INTER_TRANSFER BENEFICIARY_NAME accepts 64 characters
IB_INTRA_TRANSFER BENE_NAME accepts 40 characters
IB_TRANSACTION_HISTORY accepts 25 characters
IB_IBFT_TRANSFER accepts 64 characters

BENE_NAME for IB_TRANSACTION_HISTORY is a new column introduced during GST development.
My suggestion is to accept the maximum length of 64 characters

#5 Updated by Tan Lee Yong over 9 years ago

what is the IBG requirement on the benename length?
How about the max length on the JSP page?

#6 Updated by Yap Kah Yan over 9 years ago

Max length for IBG is 50 in jsp
Max length for FTT is 40 in jsp

Not sure on the IBG requirement of beneName length.

In Payment Reference Enhancement, bene name max length is 20 to send to host. No requirement for store in DB max length.

#7 Updated by Yap Kah Yan over 9 years ago

  • Assignee changed from Yap Kah Yan to Zahir Abd Latif

#8 Updated by Zahir Abd Latif over 9 years ago

  • Status changed from Pending Customer Feedback to Closed - End of life cycle
  • % Done changed from 0 to 100

Issue closed in SCP.
Refer email:- Re: [Request ID :##2650##] : BVMC Report Inaccurate

Also available in: Atom PDF