OTP message received by incorrect mobile number.
Article ID: 41741
Updated On:
Products
Issue/Introduction
Issue:
OTP message received by incorrect mobile number.
Environment:
CA Transaction Manager
Cause:
The same mobile number is updated to multiple cards in error.
Resolution:
The mobile number for card holders are either uploaded to DB or updated directly on CA Transaction Manager Admin Console. If one needs to find out the list of all cards for which the same mobile number is updated, it is required that at least one such card number / Proxy PAN is known. Once this information is available, follow the below steps to list out other cards for which the same mobile number is updated:
1. Login to CA Transaction Manager Admin Console.
2. Click on “Cardholder Account Inquiry”.
3. Input the available card number or card proxy PAN and click on “Submit”. Let’s say it is “ProxyPAN1”.
4. Now click on “Update Cardholder Registration Data” and “Update Cardholder Contact Details”.
5. Here, one can verify if the mobile number in question is updated to the card number that they are viewing.
6. If the mobile number is updated as a card holder contact information (i.e., if the mobile number was seen in “Update Cardholder Contact Details”), execute the below query to list out other cards for which the same mobile number is updated as contact information:
select MOBILEPHONE from ARAcctHolderAuth where ProxyPAN= 'ProxyPAN1';
This query will give you the encrypted value of the mobile number in question. Let’s say it results with “MobileNum1”.
select ProxyPAN from ARAcctHolderAuth where MOBILEPHONE=' MobileNum1';
This will give you the list of all the ProxyPANs for which the same mobile number is updated.
7. If the mobile number is updated as a card holder issuer answers information (i.e., if the mobile number was seen in “Update Cardholder Registration Data”), execute the below query to list out other cards for which the same mobile number is updated as contact information:
select bankid, pan, questionid, ANSWER, datecreated from ARIssuerAnswers where pan in (select CardNumber from ARAcctHolderAuth where ProxyPAN= 'ProxyPAN1');
This query will give you the encrypted value of the mobile number in question. Let’s say it results with “MobileNum1”.
select pan from ARIssuerAnswers where answer=‘MobileNum1’;
This will list out the encrypted value of all card numbers for which the same mobile number is updated. Examples: Pan1, Pan 2,... To obtain the proxy PAN for each of these encrypted card number, execute the below query:
select ProxyPAN from ARAcctHolderAuth where CardNumber='Pan1';
8. This way one can obtain all the other proxy PANs for which same mobile is updated.
Additional Information:
Ideally it is required to store this information separately by the admin who is updating the contact information for each card holder to avoid going through the above process of sequential DB queries.
Environment
Component: TRNACS
Feedback
