Siebel is generating offensive ROW_ID's in production

This is an original Siebel service request posted in Oracle support. It has been a laughing stock for many many years and now it has been archived on the Oracle support.

Customer found a row_id created in their production environment which got offensive words in the row_id such as, "1-190F**K". So, they would like to know whether Siebel have any internal validation to avoid offensive words in ROW_ID generation.

How to create cookies from server side?

Yes, you read it correctly, you can create cookies in the browser from the server side, and get your browser script to access them. This is enabled via Web Engine HTTP TXN business service.

Siebel Cookies

var oBS = TheApplication().GetService("Web Engine HTTP TXN");

var Inputs = TheApplication().NewPropertySet();
var Outputs = TheApplication().NewPropertySet();

var psCookie = TheApplication().NewPropertySet();
psCookie.SetType("Cookie");
psCookie.SetValue("Value of Cookie");
psCookie.SetProperty "Path", "/";
Inputs.AddChild(psCookie);

oBS.InvokeMethod("SetResponseCookies", Inputs, Outputs);

Keep in mind that this method can be called from any other event in Siebel except application start(Application_Start) event due to product limitation .

Not just that one can use this service to get IP address of the client which is used to access Siebel. I will highly recommend to go through all the methods of Web Engine HTTP TXN business service in your free time.

How caching work in Siebel?

In any online transaction processing system like CRM most of the processing time is taken in finding the right record in database. No matter what database optimization technique you implement, your db processing time would be the highest among the time spent in web server and application server.

Siebel Database

How to update bulk records in Siebel using eScript?

The best suggestion anyone can give to update records in bulk in Siebel is to use Siebel EIM. However sometimes developers don't have time to create EIM job, test it in lower environments and get it working in some days, and business can't wait for that long, And pesky admin team won't give developers the SQL access to production.

Then this is the last solution. Write a dirty little script and run it in business service simulator.

How to disable anonymous browsing in Siebel REST API?

This is one of the most funny bug registered by Oracle. (Just after the obscene ROW IDs) .
Although this is applicable only for IP15, but do keep this in mind in case you are doing POCs on any customer.

Oracle left partially built config in the Java container sub system thus all the traffic coming through the system is passthrough. Kudos to the product team to get the feature out of the door :)

To disable this all you need to do is to delete the JavaContainerPropSub in named subsystems. This will cause authentication error in the component thus it won't turn on and you can in turn switch off the anonymous browsing.

Siebel REST API Interview Questions

Question 1 : What are REST APIs? 

Answer: REST stands for Representational state transfer. It is a protocol for data transfer using HTTP methods.

Usually REST API uses JSON format to communicate as it is simpler and lightweight than XML.

How to calculate age from date of birth using calculated fields?

Hi Readers,

This is a new series, where I will show you how things are done in Siebel and how the same thing can be done in Salesforce. Will leave the decision upto you to tell me which one is easier and which one is better.

Step 1: Create first calculated field to output date in YYYYMMDD Field Type: DTYPE_NUMBER

ToChar(Today(),’YYYY’) + ToChar(Today(),’MM’) + ToChar(Today(), ‘DD’)

Step 2: Create second calculated field to convert birth date field in YYYYMMDD  : Field Type: DTYPE_NUMBER

ToChar([Date Of Birth], ‘YYYY’) + ToChar([Date Of Birth], ‘MM’) + ToChar([Date Of Birth], ‘DD’) 

Step 3 : Create another field to use the fields created above as : Field Type: DTYPE_TEXT

The Under Age flag : IIf(([Step1] – [Step2]) < “180000”, “Y”, “N”)

We are doing these three steps mainly because :

1. Siebel does not have good list of functions supported in calculated fields. 
2. Siebel does not have data type conversion in calculated fields. 

Lets don't refer to invoke service method due to its own complication and performance issues it can cause.

In Salesforce if you have to do this activity, you just need one formula field with following calculation.

IF( NOT( ISBLANK( Birthdate ) ) ,
  IF( DATE( 2000 , MONTH( Birthdate ) , DAY( Birthdate ) ) <= DATE( 2000 , MONTH( TODAY() ) , DAY( TODAY() ) ),
     YEAR (Today()) - YEAR ( Birthdate ),
     YEAR (Today()) - YEAR ( Birthdate ) -1 ),
  null)

Learn more about list of functions available in Siebel here: https://docs.oracle.com/cd/B40099_02/books/ToolsDevRef/ToolsDevRef_Operators8.html

and Full list of salesforce functions are here: https://help.salesforce.com/articleView?id=customize_functions.htm&type=5

State of Siebel in 2020?

Hello Readers,

It has been a while since I have posted on this blog. I have moved on from Siebel the second time. Still see some of my friends working in Siebel and keep getting furious.

Just wondering what are my readers are doing in 2020? Please take some time out and let us know the actual state of Siebel this year.


Live results





Many things have happened since I last posted.
Siebel unleashed vanished :(

via GIPHY

No more posts on Impossible Siebel :(

via GIPHY

No more posts on Siebel Mantra :(

via GIPHY

And such a once a wonderful blogging community just vanished.

I have stopped reading siebelhub.com,  hope it is doing great. I hope you all are doing great. Would love to read your comments and connect.

 -Jim

Gift yourself salesforce skills this holiday season!

Either you are seasoned Siebel developer or just starting struggling with Siebel, I am sure learning salesforce would have crossed your mind. No doubt Siebel is the best full fledged CRM product out there, but there is no harm is learning new stuff.

I have set a challenge for myself to learn salesforce this holiday season and seriously try for salesforce consulting job roles in the new year. I want to invite all How To Siebel readers to join me in journey and learn salesforce together.

Salesforce Unleashed

I am going to learn salesforce by myself by going through trail head and online tutorials, and going to share my progress on my new blog
http://salesforce-unleashed.blogspot.com 

To make it easy please follow my latest posts :
How to get started with salesforce
Screen cast of earning first trail head badge.
Question and Answers

At last I will leave you with a quote from Dr Seuss

And recommend you to come and follow me on my new Salesforce Unleashed blog and keep up with my salesforce learning plan.

Override windows idle timeout!

As a Siebel Consultant you must have come across windows machines with extremely short idle timeout. I guess I am not the only one who hates to type in password again and again, situation becomes worst when machine logs off or gets powered off due to idle session timeout!!

Out of frustration, I started to hunt for a solution. Keep in mind I don't have privileges to change setting on the OS.