Unlock Repository objects

Following are the SQL commands that we can use in unlocking siebel objects.

VIEW

UPDATE siebel.s_view view SET view.obj_locked_flg = 'N', view.obj_locked_date = NULL, view.obj_locked_by = null, view.obj_locked_lang = null

WHERE view.row_id = 'Row_Id';

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 = 'CX_TEST_TABLE'

and tab.row_id = 'Row_Id';

commit;

BUSINESS COMPONENT

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 = 'Row_Id';

commit;

BUSINESS SERVICE

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 = 'Row_Id';
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 = 'Row_Id';

commit;

PROJECT

UPDATE siebel.s_project  AS proj SET proj.locked_flg = 'N', proj.locked_date = null

WHERE proj.name = 'Test Project';

commit;