Support #5301
[SCP ID :##2660##] : CIB SI Consumer on 29/04/2015
Status: | Closed - End of life cycle | Start date: | April 30, 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY BVMC | Spent time: | 5.00 hours | |
Target version: | - |
Description
There were total 5 SI transactions which were successful on 29/04/2015.
However, BVMC Report and Corus only reflected 4 SI transactions. The similar case also reported for today's SI
The issue log is placed at \\10.20.8.35\Share\IB Production Problem - 30042015\Issue log 20150430 - Extra SI on 29.4.15.docx for your next action. Kindly assist.
Related issues
History
#1 Updated by Ngoh Chee Ping over 9 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#2 Updated by Ngoh Chee Ping over 9 years ago
- % Done changed from 0 to 50
After checked the data in production. I found the record in transaction history is missing that cause all this problem. In order to fix this, i provided a query for Shikin to add back the missing record. But we need to do further investigate why there is missing record happen.
insert into ib_transaction_history("CREATION_DATE", "TRNX_ID", "TRNX_TYPE", "FROM_ACCOUNT_NO", "TO_ACCOUNT_NO", "AMOUNT", "DETAILS", "STATUS", "BILL_ACCTID", "BILL_REF_ID", "EFFECTIVE_DATE", "REMOTE_IP", "APPROVAL_CODE", "USER_ID", "RECEIPT_INDI", "PHX_REFERENCE_NO", "OTHER1", "OTHER2", "EPY_REFERENCE_NO", "IB_SESSION_ID", "PHXREV_REF_NO", "PHXCHAR_REF_NO", "PHXCHARREV_REF_NO", "FROM_CURRENCY", "TO_CURRENCY", "FROM_ACC_CRT_DT", "TO_ACC_CRT_DT", "TRNX_REASON", "PAYMENT_MODE", "PAYMENT_FREQUENCY", "TERMINATION_DATE", "CHARGES_AMOUNT", "GST_CHARGES", "GST_ABSORB", "GST_ABSORB_AMOUNT", "GST_GL", "BENE_NAME", "BENE_BANK", "CUST_ID", "STAFF_STATUS", "CHARGES_REF_NO") values (TO_DATE('2015/04/27 09:23:19', 'yyyy/mm/dd hh24:mi:ss'), '201504270001914839', 'SI Registered Interbank Transfer (FP)', '001105014768', '5439310021778173', '2000', 'Interbank transfer to HLB Credit Card Mexdelina (HONG LEONG BANK / HONG LEONG ISLAMIC BANK: 5439310021778173)', 'Accepted', '', '', '20150429', '219.93.33.173', '', '7229', '0', '', '', '', '', '20150427113713496490', '', '', '', 'MYR', 'MYR', '', '', '', '2', '', '', '', '0.00', 'N', '0.00', '', '', '', '', '-', '');
#3 Updated by Ngoh Chee Ping over 9 years ago
- Assignee changed from Ngoh Chee Ping to Yap Kah Yan
Assign to Kah Yan to do further investigate why the record in IB_TRANSACTION_HISTORY is missing.
#4 Updated by Yap Kah Yan over 9 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
- % Done changed from 50 to 0
This issue is related to the bene_name exceeding 25 characters.
The bene name for transaction id 201504270001914839 is 26 characters including space
Refer to result from query:
select * from IB_INTER_TRANSFER where TRNX_ID='201504270001914839';
BENE_NAME: HLB Credit Card Mexdelina
#5 Updated by Yap Kah Yan over 9 years ago
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
#6 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 :##2660##] : CIB SI Consumer on 29/04/2015