How to take backup of Siebel Tables?

This article explains how to take backup of Siebel Tables or any other table in Oracle database. It is a good practice to take backup of data before making any changes to schema or before updating bulk records. However Siebel does not provide any archiving or data backup solution out of the box.

There are couple of solutions available if you are using oracle database, some of them are:
1. First option is to copy the table with all the data into a new table in same or any other database.As compared with the any other option turnaround time is very less, as this command executes on the server and there is no payload transferred between client and server.

This can be done with the help of create table command with select statement.

CREATE TABLE new_table  AS (SELECT * FROM old_table);

SBL-DAT-00309 :You do not have the privileges required to view detailed information for this record.

We detected an Error which may have occurred for one or more of the following reasons:

You do not have the privileges required to view detailed information for this record. Please contact your systems administrator if you would like access to this record (SBL-DAT-00309)

How to download Siebel bookshelf?

This article will explain  you how to search and download Siebel Bookshelf from oracle software delivery cloud. Software delivery cloud is the download site for Oracle's all the software products and training materials. You will need to create a Oracle Web Account to proceed with any download.

It is recommended for new Siebel Developers to download a local copy of bookshelf to make it easier to read through and understand the product in detail. Bookshelf contains product's technical and sometime end user guides. It can prove as a useful weapon in your arsenal to debug issues and reference.

Step 1: Login to Oracle eDelivery cloud & Search for Siebel CRM Product suite

Step 2: Select the version you are after, din't woryy it wont start the download yet.

How to create Pick list field in Siebel?

This is one of the most common problem that is faced by new siebel developers. Answer of this question can tell a lot about actual hands on experience of the developer and how much experience he holds in debugging.

There are only few reasons why picklist doesn't work, which can be summarized as below:

1. Pick map of the new field is not populating the foreign key field of the field.
2. Join created to pull the value of the field is not created properly.
3. If no values are shown in drop down then pick list is might not compiled yet, or the LOV type and values are not created in administration views.
4. If value is not displayed after selecting value from pick applet then wrong field is selected in pick map of the field.
5. Update only if null is not configured properly. 

Related Questions:

Question :What are the reasons for field based on picklist not showing drop down or pick applet icon?

Answer: Pick applet might not be selected on the list item or control of the applet or runtime property of the control is set to false.

Please feel free to leave a comment if you have faced any other issue with the pick lists. 

Popular Interview Questions:

• What is the performace impacts of using applet toggles?

• What are different forms of applet toggles?

• What is the difference between Constraint pick map and Copy pick map in Siebel?

• What is the difference between Picklist and MVG?

• How to create a new static picklist in Siebel?

SBL-SRB-00047: Could Not Route Message to WfProcMgr With Registered Key (Null)

Problem: This error can be found in Siebel server logs when workflow monitor agent is not able to contact  workflow process manager and requests get queued up in S_ESCL_REQ.
This simply means that workflow monitor agent is not able to execute workflow because another component is down or looks like unavailable to SR Broker.
Impact: As a result interface calls to the external interfaces or any other asynchronous process configured using policy will get delayed.

Workarounds: