Support #3916
SCP ID #: 1458 - Standard ID Format (Business Registration ID no.)
| Status: | Work Completed-End life cycle | Start date: | November 11, 2013 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Vincent Devethas | % Done: | 0% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Dear Vincent,
As spoken, MyClear has implemented the Standard ID Format today as we noticed that 1 of our IBG Transaction initiated from Consumer contained the invalid id format i.e. consist of hypen "-" for the business registration no.
Since we have yet to migrate the IBG Transaction into the production, seek your assistance to advice IT to make the necessary changes at database to reflect the valid ID Format.
History
#1
Updated by Ahmad Hazri almost 11 years ago
Updated By Vince
Here is the SQL query to update the ID: 1. Check the record before updating the data SELECT * FROM IBG.IBG_ENTRY A WHERE A.IBG_TRNX_ID = '20131111053804'; 2. Run the below query to update Business Registration No to remove [ - ]. UPDATE IBG.IBG_ENTRY A SET A.BUSINESS_REG_NO ='JM0663823K' WHERE A.IBG_TRNX_ID = '20131111053804'; 3. Check again the record after it updated SELECT * FROM IBG.IBG_ENTRY A WHERE A.IBG_TRNX_ID = '20131111053804';
#2
Updated by Ahmad Hazri almost 11 years ago
Updated script
1. Check the record before updating the data SELECT * FROM IBG.IBG_ENTRY A WHERE A.IBG_TRNX_ID = '20131111053804'; 2. Run the below query to update Business Registration No to remove [ - ]. UPDATE IBG.IBG_ENTRY A SET A.BUSINESS_REG_NO ='JM0663823K', A.BENEFICIARY_ID = 'JM0663823K' WHERE A.IBG_TRNX_ID = '20131111053804';
#3
Updated by Tan Lee Yong over 10 years ago
- Assignee set to Vincent Devethas
Vincent, please update the status?
#4
Updated by Ahmad Hazri over 10 years ago
- Subject changed from SCP ID : 1458 - Standard ID Format (Business Registration ID no.) to SCP ID #: 1458 - Standard ID Format (Business Registration ID no.)
#5
Updated by Nor Shuhaida Subri over 10 years ago
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
Consider resolved after implementing the Second ID Validation enhancement.