SQL Query to get failed provisioning tasks for an application in OIM

SQL Query to get failed provisioning tasks for an application in OIM

SELECT
    USR.USR_LOGIN,
    OSI.SCH_KEY,
    SCH.SCH_STATUS,
    STA.STA_BUCKET,
    MIL.MIL_NAME,
    OST.OST_STATUS
FROM
    OSI
JOIN SCH ON OSI.SCH_KEY = SCH.SCH_KEY
JOIN STA ON STA.STA_STATUS = SCH.SCH_STATUS
JOIN MIL ON OSI.MIL_KEY = MIL.MIL_KEY
JOIN TOS ON MIL.TOS_KEY = TOS.TOS_KEY
JOIN PKG ON TOS.PKG_KEY = PKG.PKG_KEY
JOIN OIU ON OSI.ORC_KEY = OIU.ORC_KEY
JOIN USR ON OIU.USR_KEY = USR.USR_KEY
JOIN OST ON OIU.OST_KEY = OST.OST_KEY
JOIN OBJ ON OST.OBJ_KEY = OBJ.OBJ_KEY
WHERE
    OBJ.OBJ_NAME = 'AD User'
    AND OST.OST_STATUS = 'Provisioning'
    AND STA.STA_BUCKET in ('Pending','Rejected')
    AND PKG.PKG_NAME = 'AD User';
    AND MIL.MIL_NAME = 'System Validation';
    

Update Process Form Version using sql query

As soon as we have any changes on Process Form the one has to upgrade the form version for all the existing provisioned user accounts in OIM System, to do so one can run the scheduled job: Form Upgrade Job ( This job takes longer time to run)

 

or run the following sql query, below is the example for AD.

 

update UD_ADUSER set UD_ADUSER_VERSION=(select sdk_active_version from sdk where sdk_name='UD_ADUSER');