Showing posts with label siebel. Show all posts
Showing posts with label siebel. Show all posts

Friday, 12 April 2013

Setting tab order in Siebel

You can decide the tab order of each control in a form applet.
 To do so query the applet -> controls and you can find a property called "HTML Sequence". Give the sequence as you required.


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.


Sunday, 16 December 2012

How to setup Profile attribute in Workflow?









There is a Business service Called  "SIS OM PMT Service" & Its Method named as
"Set Profile Attribute"
Input Arguments are
Profile Attribute Name
Profile Attribute Value

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