Why are my change to the RDM not showing up in the MDM Hub as expected?

Question

In Dropdown for a lookup field, we are getting incorrect description whereas in RDM we have the correct description code present.

For LOOKUP_IMS_STATUS we have the Reltio code ACTV and INAC only in the RDM tenant. 

Answer

• If you run the following API 

GET https://<environment>.reltio.com/reltio/api/<tenant>/lookups?source=MDM

 
You will see that you have the old lookup value still defined in the MDM.
 

 "rdm/lookupTypes/LKUP_IMS_STATUS": {
      "RTRD": {
          "displayName": "Retired",
          "parents": [
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/AU",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TH",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/00",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MM",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TW",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MY",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/PH"
          ]
      },
      "UNK": {
          "displayName": "Unknown",
          "parents": [
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/00"
          ]
      },
      "MOVD": {
          "displayName": "Moved",
          "parents": [
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/00"
          ]
      },
      "INAC": {
          "displayName": "Inactive",
          "parents": [
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/IN",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/KR",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/00",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MM",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TW",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/HK",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/BD",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/PH",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/VN",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/ID",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/AU",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TH",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/SG",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MY",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/NZ"
          ]
      },
      "SBBTCL": {
          "displayName": "Sabbatical",
          "parents": [
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/AU",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TH",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/00",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MM",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TW",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MY",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/PH"
          ]
      },
      "ACTV": {
          "displayName": "Active",
          "parents": [
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/IN",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/KR",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/00",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MM",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TW",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/HK",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/BD",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/PH",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/VN",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/ID",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/AU",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TH",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/SG",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MY",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/NZ"
          ]
      },
      "PRNTLLV": {
          "displayName": "Parental Leave",
          "parents": [
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/AU",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TH",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/00",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MM",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TW",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MY",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/PH"
          ]
      },
      "DCSD": {
          "displayName": "Deceased",
          "parents": [
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/AU",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TH",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/00",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MM",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/TW",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/MY",
              "rdm/lookupTypes/LKUP_IMS_COUNTRY_CODE/PH"
          ]
      }
  },

•  You can also see the information by using the following API call. 

GET 'https://<environment>.reltio.com/reltio/api/<tenant>/lookups

 If you want it only for one type then look for this:

curl --location --request POST 'https://<envirnoment>.reltio.com/reltio/api/<tenantId>/lookups/list' \
--header 'Authorization: Bearer 259efdXXXXe5715de1' \
--header 'Content-Type: application/json' \
--data-raw '{
    "type": "rdm/lookupTypes/LKUP_IMS_STATUS"
}'

•  We recommend that you review the output from these API calls and revise the lookup as appropriate.  You can use the below API to perform the update of the lookup values.

POST https://<envirnoment>.reltio.com/reltio/api/<tenant>/lookups

{Revised body where they can remove the other unwanted lookup type}

POST https://<enviroment>.reltio.com/reltio/api/<tenant>/reindexUnresolvedRdmLookups?forceIgnoreInStreaming=true

Reference

• RDM Troubleshooting.
• Reltio Troubleshooting guide.