This content has been marked as final. Show 3 replies
You can use the following query to get the updates to the user process forms for a particular user:
Also make sure that your Audit Level is set to Process Task to audit the process form changes and etc.
SELECT UPA_UD_FORMFIELDS.FIELD_NAME,UPA_UD_FORMFIELDS.OLD_VALUE, UPA_UD_FORMFIELDS.NEW_VALUE, UPA_UD_FORMS.CHANGE_REASON, USR2.USR_LOGIN, UPA_UD_FORMFIELDS.UPDATE_DATE FROM UPA_UD_FORMFIELDS ,UPA_UD_FORMS,UPA_RESOURCE,OIU,USR USR, USR USR2 WHERE UPA_UD_FORMFIELDS.UPA_UD_FORMFIELDS_KEY=UPA_UD_FORMS.UPA_UD_FORMS_KEY AND UPA_RESOURCE.UPA_RESOURCE_KEY=UPA_UD_FORMS.UPA_RESOURCE_KEY AND UPA_RESOURCE.OIU_KEY=OIU.OIU_KEY AND OIU.USR_KEY=USR.USR_KEY AND USR2.USR_KEY=UPA_UD_FORMS.CHANGE_REASON_KEY AND USR.USR_LOGIN='XXXXX';
To get the direct provisioning audit information look under UPA_RESOURCE table.
SELECT UPA_RESOURCE.OBJ_NAME, UPA_RESOURCE.OST_STATUS, UPA_RESOURCE.PROVISIONED_BY, UPA_RESOURCE.PROVISIONED_BY_ID, UPA_RESOURCE.OIU_CREATE_DATE FROM UPA_RESOURCE UPA_RESOURCE WHERE UPA_RESOURCE.UPA_RESOURCE_KEY IN (SELECT UPA.UPA_KEY from UPA UPA, USR USR where UPA.USR_KEY=USR.USR_KEY AND USR.USR_LOGIN='XXXXX')
Edited by: bbagaria on Oct 24, 2011 5:56 AM
Thank you Guys, you put me in the right directions.
I would also add this link :
which provides detailed guide about this.