Showing posts with label siebel. Show all posts
Showing posts with label siebel. Show all posts
Friday, 12 April 2013
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.
Wednesday, 19 December 2012
How to Run and Test a workflow using siebel application?
We can test a workflow using Siebel tool & Application. Most of you are familiar with testing Workflow with tool's simulation. But we can test workflow using siebel application. To do that goto Administration - Business Service -> Simulator.
Give Service Name as "Workflow Process Manager" and Method name "RunProcess". Give required Input argument and click "Run" and find output in output argument section.
Give Service Name as "Workflow Process Manager" and Method name "RunProcess". Give required Input argument and click "Run" and find output in output argument section.
Sunday, 16 December 2012
Wednesday, 5 December 2012
How to get a field value when we click on MVG?
I have a requirement that when i click on an MVG, Its associate applet should have some filer value, that depends on the value of base applet. So i need that value from base applet. I solved this problem by creating profile attributes. When i click on the MVG the profile attribute will set by using the following code.
function Applet_PreInvokeMethod (name, inputPropSet)
{
if(name == "EditPopup"){
var myname= this.BusComp().GetFieldValue("field Name");
TheApplication().SetProfileAttr("attr_name",myname);
//alert(myname);
}
return ("ContinueOperation");
}
In the search specification if the Assoc applet, I get this profile attribute
[filed_name] = GetProfileAttr("attr_name")
Now It is solved
function Applet_PreInvokeMethod (name, inputPropSet)
{
if(name == "EditPopup"){
var myname= this.BusComp().GetFieldValue("field Name");
TheApplication().SetProfileAttr("attr_name",myname);
//alert(myname);
}
return ("ContinueOperation");
}
In the search specification if the Assoc applet, I get this profile attribute
[filed_name] = GetProfileAttr("attr_name")
Now It is solved
Subscribe to:
Posts (Atom)






