Sunday, 6 January 2013

Unlock siebel repository object using SQL




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

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

COMMIT;

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

commit;


PROJECT

UPDATE siebel.s_project  AS proj SET proj.locked_flg = 'N', proj.locked_date = NULL WHERE proj.name = 'your project_name';

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 = 'replace_your_object_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 = 'your Table NAME' and tab.row_id = 'replace_your_object_ID';

COMMIT;

APPLICATION

UPDATE SIEBEL.S_APPLICATION app
  SET
    app.OBJ_LOCKED_FLG = 'N',
    app.OBJ_LOCKED_DATE = NULL,
    app.OBJ_LOCKED_BY = NULL,
    app.OBJ_LOCKED_LANG = NULL
  WHERE
    app.ROW_ID ='replace_your_object_ID';

COMMIT;

Thursday, 3 January 2013

How to test inbound webservice with attachment in siebel


Before making IC make sure that the BC class should be "CSSBCFile"
Then In XML request please make sure that the values are

                         FileAutoUpdFlg = Y
                         FileDeferFlg = R
                         QuoteFileDockReqFlg = N
                        QuoteFileDockStatFlg = E

then specify your file name & encoded format.

to get 64bit decoded value of a file, please use this site.