Friday, 8 January 2016

Query to update response code in Process task

In OIM,once a task is assigned to any user,its not possible to change the response in process task.

The folloing query can be used to update the response code via DB

select * from SCH;

select * from RSC where mil_key='19766';

select * from MIL where MIL_NAME='Create User' and tos_key='1673';

select * from TOS where PKG_KEY=(select PKG_KEY from PKG where PKG_NAME='Tesdsfdfgdgds');

select * from mil where mil_key='19766';

select * from tos;

select * from STA;

Query:
update RSC set sta_key='2' where RSC_DATA='OBJECT_ALREADY_EXISTS' and mil_key='19766';

No comments:

Post a Comment