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.

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.