To determine which services should be enabled on an MTN SIM, please run the query provided at the end of this message.
Once executed, the query will return the relevant service information.
The screenshot above clearly indicates which services should have been enabled on the SIM during the provisioning process.
SET @iccId = ' ICCID IN QUESTION ';
SELECT * FROM (
SELECT
providerTariff,
JSON_UNQUOTE(JSON_EXTRACT(template, '$.serviceOrderItem[0].@type'))
FROM mtnsa65510.service WHERE requestType = 'provide'
AND JSON_UNQUOTE(JSON_EXTRACT(template, '$.serviceOrderItem[0].itemAction')) = 'add'
AND JSON_UNQUOTE(JSON_EXTRACT(template, '$.serviceOrderItem[0].@type')) IS NOT NULL
AND serviceType = '/sim/roaming'
Order BY providerTariff) SEL1
JOIN (
SELECT iccId, ProviderCode FROM oncilla.icc2PortfolioPackage ipp
JOIN Package2IMSILabel PIL ON PIL.PackageID = ipp.packageId
JOIN ProviderTariffs PT ON ProviderTariffsID = PT.ID
WHERE iccId = @iccId
) SEL2
ON ProviderCode = providerTariff
FINDING CURRENT SERVICES:
TO FIND OUT WHICH SERVICES ARE CURRENTLY ENABLED ON THE SIM, PLEASE RUN THE FOLLOWING QUERY:
SELECT * FROM provisioning.provisioningActivity65510 where ICCID = '8927000010510134369'
order by id desc;
To review currently enabled services on the SIM, you can refer to the MNO request and response details. This will show which services are active and which are not.
If any expected services are missing, bouncing the SIM may resolve the issue and re-add those services.
If the services remain unavailable after the bounce, please speak with Vivek and Cameron to investigate the underlying cause.
Comments