How to test Siebel Inbound Webservices in Local

Follow the steps below to test Webservice from Local:

1. Add the parameters below in client CFG in Siebel section

EnableWebServices =TRUE

WebServicesPort=2330

2. To confirm that the siebel.exe process is listening



From the command prompt, type the following:

netstat -a -p TCP



Examine the output for the port number you set in the application configuration file, for example:

TCP mycomputer:2330 mycomputer.mycompany.com:0 LISTENING

3. To Test the webservice from SOAP UI use the URL below:

http://localhost.:2330?SWEExtSource=WebService&UserName=&Password=

For detailed information about Testing te webservice from Local follow the bookshelf link:
http://docs.oracle.com/cd/E14004_01/books/EAI2/EAI2_WebServices12.html

How to submit an Asynchoronous Request in eScript

The eScript below helps you to invoke the WF process asynchronously.  Like this we can call any WF process asynchronously from the Business Service / BC / Applet scripts.

var oBS = TheApplication().GetService("Asynchronous Server Requests");

var psInputs = TheApplication().NewPropertySet();

var psOutputs = TheApplication().NewPropertySet();

var psChild = TheApplication().NewPropertySet();

var sObjId = this.GetFieldValue("Id");

psInputs.SetProperty("Component", "WfProcMgr");

psChild.SetProperty("Object Id", sObjId);

psChild.SetProperty("ProcessName", "Sample WF Process Name");

psInputs.AddChild(psChild);

oBS.InvokeMethod("SubmitRequest", psInputs, psOutputs);

How to Drop and Regenerate Triggers

To drop trigger:

1. Navigate to Application - Server Management > Jobs

2. Create a new job with Component / Job as 'Generate Triggers' with the below Parameters

Privileged User - SADMIN

Privileged User Password - SADMIN User's Password

EXEC - TRUE

Remove - TRUE

To Regenerate Trigger:

1. Navigate to Application - Server Management > Jobs

2. Create a new job with Component / Job as 'Generate Triggers' with the below Parameters

Privileged User - SADMIN

Privileged User Password - SADMIN User's Password

EXEC - TRUE

Remove - TRUE

SBL-DBX-00083: Unable to start due to incorrect system preference setting

When I tried extracting the Local DB I was getting the error below:

SBL-DBX-00083: Unable to start due to incorrect system preference setting

Researching the same I found the below Administration - Application > System Preference "Docking:Transaction Logging" is set to false in "System Preference" value.  By resetting it back to "TRUE" I was able to continue to extract the local DB

How to find a string inside another string in BIP?

Use contains function inside the conditional region statement in BIP as below

How to change Local DB Password?

1. Browse to the below folder in Windows Explorer


SiebelInstallationFolder\Client\bin


2. Click on "dbisqlc.exe"

3. In "Login" tab Enter the "User ID" as "DBA" and "Password" as the Siebel server's Enterprise name


4. In "Database" tab select the local db in which you wish to change the password for the user and click OK


5. In "Interactive SQL" window, enter the following command and Execute 


grant connect to identified by

Using Variable in Conditional Region

Use the syntax below to use the variable in Conditional Regional (If Statement in BI Publisher Report)