Support #5289
[SCP ID :##2650##] : BVMC Report Inaccurate
Status: | Closed - End of life cycle | Start date: | April 28, 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY BVMC | Spent 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.
Related issues
History
#1 Updated by Yap Kah Yan over 9 years ago
- File findings_2650.pdf added
- File IBSystem_bv_framework0.log@2015-04-27 added
- File IBSystem_bv_framework1.log@2015-04-27 added
- File IBSystem_bv_framework2.log@2015-04-27 added
- File IBSystem_bv_framework3.log@2015-04-27 added
- File report_Mon.log added
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
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