UNLOCK REPOSITORY OBJECTS
VIEW
UPDATE SIEBEL.S_VIEW BC SET BC.OBJ_LOCKED_FLG = 'N', BC.OBJ_LOCKED_DATE = NULL, BC.OBJ_LOCKED_BY = NULL, BC.OBJ_LOCKED_LANG = NULL
WHERE BC.ROW_ID = ‘1-CDGI-1MIPC’;
COMMIT;
TABLE
UPDATE SIEBEL.S_TABLE TAB SET TAB.OBJ_LOCKED_FLG = 'N', TAB.OBJ_LOCKED_DATE = NULL, TAB.OBJ_LOCKED_BY = NULL, TAB.OBJ_LOCKED_LANG = NULL
WHERE TAB.NAME = ‘S_APPLICATION’
AND TAB.ROW_ID = '1-CDGI-E5E5';
COMMIT;
BUSCOMP
UPDATE SIEBEL.S_BUSCOMP BC SET BC.OBJ_LOCKED_FLG = 'N', BC.OBJ_LOCKED_DATE = NULL, BC.OBJ_LOCKED_BY = NULL, BC.OBJ_LOCKED_LANG = NULL
WHERE BC.ROW_ID = ‘1-CDGI-CD6C’;
COMMIT;
BUSSERVICE
UPDATE SIEBEL.S_SERVICE SERV SET SERV.OBJ_LOCKED_FLG = 'N', SERV.OBJ_LOCKED_DATE = NULL, SERV.OBJ_LOCKED_BY = NULL, SERV.OBJ_LOCKED_LANG = NULL
WHERE SERV.ROW_ID = '1-CDGI-1I9E2';
COMMIT;
APPLET
UPDATE SIEBEL.S_APPLET APPL SET APPL.OBJ_LOCKED_FLG = 'N', APPL.OBJ_LOCKED_DATE = NULL, APPL.OBJ_LOCKED_BY = NULL, APPL.OBJ_LOCKED_LANG = NULL
WHERE APPL.ROW_ID = '1-CDGI-D8I';
COMMIT;
PROJECT
UPDATE SIEBEL.S_PROJECT AS PROJ SET PROJ.LOCKED_FLG = 'N', PROJ.LOCKED_DATE = NULL
WHERE PROJ.NAME = 'Account Hierarchy';
COMMIT;
Note:-
How to find out the row id of any object?
Go to Siebel tools
Select object(Applet/BC/View) -> Help -> About Record -> Details
Row# will give the Row Id details.
Thanks for your Useful Post Aswad.
ReplyDeleteMahesh
Thanks for your Useful Post Aswad
ReplyDeleteMahesh
@Anonymous
ReplyDeleteWelcome!
Thanks Aswad for the post..i have made use of this for couple of times and it was working fine..but now when i try to unlock an object, the columns gets updated at the db level,but not reflecting to siebel tools..
ReplyDeletehi Aswad, thanks for this info..I have made use of this couple of times, but now, the columns are getting updated at the db level and its not reflecting in siebel tools.
ReplyDelete@Anonymous
ReplyDeleteCan you please explain me your problem in details?
Have you tried re-querying the object in siebel tools?
thanks for the post..it helped me alot
ReplyDeleteWelcome!
Delete