Fetching value of Oracle Sequence from External DB

Fetching value of external Oracle Sequence in Siebel is one of the typical business requirement in integration of Siebel applications. In case of windows environment solution is quite straight forward, we just need to create ADODB object in script and execute sql on external database.

But in case of Unix environment this is not possible as ADODB is not supported in Unix.

Sending email from eScript

Sending email updates from Siebel is quite easy, we just have to call Outbound Communication Manager, an OOB Business Service to trigger emails.

Get Attribute Value - Product Configurator

There is no method out of the box available in Siebel Product Configurator that can be used to get attribute value. For this one of my team member have written this code which traverses the product structure and return the attribute value as string.

Automatic login to Siebel thin client

While in development, I used to get bugged up by entering credentials every time application needs to be accessed. Out of frustration I have found way to bookmark the credentials in IE favorites so that it directly takes the user to application home screen.

Excellent Siebel EAI / Web services training Material

Really Excellent Siebel EAI training material is available for download on 4 shared and esnips.

1. http://www.4shared.com/file/dQL7Ak3K/Siebel_EAI_PPT.htm

Contents: Oracle Siebel Trainging Material of may 2004 and Hands on Labs

2. http://www.4shared.com/file/_vf9wkvH/web_service_ppt.html

Content: Web services PPTs and Hands on Labs + SOAP fundamentals

2. http://www.esnips.com/doc/a904d5b4-46db-4d95-b698-3d5c217085c2/Integrating_Siebel_Web_Services_Aug2006

Content: 146 Slides explaing Integrating Siebel 7.8 x CRM using Web Services

with WAS 6 and RAD 6 

Source: IBM

3. http://www.4shared.com/file/e11fSFF3/Siebel_EAI_on_1025122.htm

Siebel EAI PPT and labs + Siebel EAI Web Services Lab Guide + Concepts of WSDL, UDDI and SOAP

Source Cognizant

Happy learning J

Generate Random Number (Cont..)

In continuation of my earlier post , I am sharing another way of generating random number in siebel using  vanilla SIS OM PC Service.

SIS OM PC Service is a vanilla service which provides a method to get new system generated row id as output.
The output can be utilised to generate random number by calling RowIdToRowIdNum() in expression.

Workflow:

Step 1 : Service :SIS OM PC Service Method: Get Next RowId
Output: Next Row Id

Step 2: Service: Workflow Utilities
Output : Random Num [Type Expression] : RowIdToRowIdNum([&Next Row Id])


Thanks to Sebestian for sharing this.

Debugging Siebel eScript - Write Property Set to file

This is one of the tricks that i use to debug Siebel scripts. It is really useful if you are working on the product configurator. As most of the events in configurator have property set as argument to it, and there is no debug window to see runtime property values for the events.