All About Siebel

How to deploy files in a remote server?

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:38:00 +0530

It's easy you say, just share your drives when you connect through rdp --> http://technet2.microsoft.com/windowsserver/en/library/f47ce263-f72e-469d-bf14-6605b7f4cce51033.mspx?mfr=true. Ok, let's talk about worse case scenario, you can't share drives and you can even share a drive from your remote server.
So you can use a very usefull tool named WordPad --> http://en.wikipedia.org/wiki/WordPad. Surprised ?
It's even easier than sharing you drives, watch it :

Zip all your files into a single file;
Open a wordpad in your local machine;
Copy zip file into wordpad (WordPad would serialize your file);
Copy object that appears inside Wordpad;
Open wordpad in your remote machine and paste your object into it;
Finally copy your recent pasted object into remote server.

Enjoy.

Oracle : Reduce your parsing times

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:37:00 +0530

All the queries that you execute in an Oracle database are parsed and then executed. However, is a nonsense(and a time wastefulness) to parse over and over the same query, even if executed by different users.

So, to avoid this, Oracle uses a 'Shared pool' area where all the cursors are cached after being parsed.

How it works? It's easy:

Your query is hashed;
Oracle searchs shared pool for the matching hash value;
Is it there? If so, execute the cursor;
Otherwise parse your query, hash it and put it in shared pool for future executions;

To take advantage of this feature of Oracle engine, we have to take care for:

Hashing is executed over all your query, so Case is important.

Select * from emp is different from Select * from EMP and therefore you will not take advantage of shared pool in your second execution; So, it's important that your developers team agree in Naming and Case conventions to take greater advantage of Oracle Shared Pool.

Where clauses are hashed too;

Select * from emp where emp_no = 1 is different from Select * from emp where emp_no = 2, use global variables and procedures whenever you can.

If you follow this rules, you will not solve all the performance problems from your application but will give a little step toward the perfection.

Oracle : SQLCODE and SQLERRM in Inserts

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:37:00 +0530

Today I came across an unexpected problem when executing an exception block inside a procedure :

My code was something like this :

insert into dc_errors (error_message,error_date) values (SQLERRM, SYSDATE);

and I allways obtain an annoying PL/SQL: ORA-00984: column not allowed here.

To solve this problem I've changed my code into :

v_exception := substr(SQLERRM, 1, 256);
insert into dc_errors (error_message,error_date) values (v_exception, SYSDATE);

with v_exception as varchar2(256) .

SQL * Plus Tip - 1

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:36:00 +0530

To change the previous query, just type EDIT, this command will redirect you into an editor so you can edit previous SQL command, short name : ED.

Then type / and the new SQL command will be executed

Oracle : Reducing join execution time

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:34:00 +0530

After executing a join over two tables, whith 4 million rows each and indexes in join columns, I realized that 4 minutes it's too much time waiting for results. So I decided to watch for the execution plan :

select columns from tableA join TableB on tableA.id = tableB.id

Execution Plan----------------------------------------------------------
0 SELECT STATEMENT Optimizer=RULE
1 0 FILTER
2 1 SORT (GROUP BY)
3 2 TABLE ACCESS (BY INDEX ROWID) OF 'TABLEA'
4 3 NESTED LOOPS
5 4 TABLE ACCESS (FULL) OF 'TABLEB'
6 4 INDEX (RANGE SCAN) OF 'TABLEA_U1' (UNIQUE)

All seems to be correct, after all I'm using Rule Base Optimizer. In order to reduce execution time I force the execution of an hash join instead of a Nested Loops.
Execution time droped to about 2 minutes and execution plan looks like this :

Execution Plan----------------------------------------------------------
0 SELECT STATEMENT Optimizer=RULE (Cost=624 Card=40000 Bytes=2 800000)
1 0 FILTER
2 1 SORT (GROUP BY) (Cost=624 Card=40000 Bytes=2800000)
3 2 HASH JOIN (Cost=172 Card=40000 Bytes=2800000)
4 3 TABLE ACCESS (FULL) OF 'TABLEA' (Cost=35 Card=2000 Bytes=62000)
5 3 TABLE ACCESS (FULL) OF 'TABLEB' (Cost=136 Card=2000 Bytes=78000)

And all I've to do is change my query to :

select /*+ USE_HASH (tableA tableB ) */ columns from tableA join TableB on tableA.id = tableB.id

Why is this happening? why RBO this choose this plan? The answer is simple, RBO doesn't consider hash joins has a valid execution path, so you have to force it.
This specific join is used when a large amount of data needs to be joined or when a large fraction of the the table needs to be joined, however this is a very memory expensive operation and need to be carefully analised.

PL/SQL Tip - 1

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:33:00 +0530

Query v$parameter view for BD parameters checking.
In this example I'm looking for the selected optimizer mode.

select value from v$parameter where name = 'optimizer_mode';

Enjoy.

PL/SQL : Show locked objects

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:33:00 +0530

Today, after trying unsuccessfully to drop my temporary tables, and subsequent fails due to object locks, I tried to find who's locking my table.
Not an easy task, so I dig a little and found this amazing script that solved my problem. If you have the same problem, read here --> http://www.orafaq.com/scripts/performance/lockall.txt how to list all locked objects.

PL/SQL : How to update using select

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:32:00 +0530

This "problem" came across me when I needed to update an entire temporary table column. One option is to loop all table rows, boring and time consumer task. After some background searchs I've adopted this method:

UPDATE TABLEA SET
(TABLEA.COLUMNA, TABLEA.COLUMNB) =
(SELECT TABLEB.COLUMNA, TABLEB.COLUMNB FROM TABLEB WHERE TABLEB.ID = TABLEA.ID)

I've basically do one inner select and join the two tables in the inner select's WHERE clause.

EIM : Shell execution order

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:32:00 +0530

When running an EIM process with a shell type process section, it will be executed from top to bottom. In this example, first process to run will be Assess followed by Contact.

[Siebel Interface Manager]
PROCESS = P1
USER NAME = "XXXX"
PASSWORD = "XXXX"

[Lancar]
TYPE=SHELL
INCLUDE = "ASSESS"
INCLUDE = "CONTACT"

[CONTACT]
TYPE = DELETEBATCH = 3999
TABLE = EIM_CONTACT
ONLY BASE TABLES = S_PARTY,S_CONTACT
DELETE MATCHES = S_CONTACT, (COLUMN= 'DELETED')

[ASSESS]
TYPE = DELETE
BATCH = 3998
TABLE = EIM_ASSESS
ONLY BASE TABLES = S_ASSESS,S_ASSESS_VAL
DELETE MATCHES = S_ASSESS, (COLUMN = 'DELETED')

PL/SQL : Scripting for table drop

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:31:00 +0530

I came from MS SQLServer and I miss a lot of nice functionalities, like for instance, If exists.
Why am I talking about this? Simple, I want to run a script that "only" drops a few tables that I'don't no if they already exists.

Easy to say, hard to find. So here's a script for doing that, without returning any errors.

set echo off;
set heading off;
spool run.sql;
select 'drop table 'table_name';' from dba_tables where UPPER(table_name) in ('TABLEA', 'TABLEB', 'TABLEC');
spool off;
@run.sql;

Enjoy.

EIM : DUP_RECORD_EXISTS after Update

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:31:00 +0530

This status happens after running an EIM update process with lines that match exactly the lines being updated in base table.

Localcooling . com

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:30:00 +0530

Download the 100% Free LocalCooling Application and it automatically optimizes your PC's power consumption by using a more effective power save mode. You will be able to see your savings in real-time translated to more environmental terms such as how many trees and gallons of oil you have saved.

Local Cooling will:

Cut your energy bills.
Reduce the amount of Greenhouse Gas CO2 emissions as a result of your reduced PC power consumption.
Give you full control over your power mode settings.
Improve your overall computing experience and efficiency.
Show you in detail how much you have saved since installing the software.

Learn more -> http://www.localcooling.com/about the LocalCooling Application and how it will help you save energy!

How to relate a contact whit their accounts

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:29:00 +0530

Contact accounts can be found in S_PARTY_PER intersection table. This table relates person_id column (par_row_id from s_contact) with party_id column (par_row_id from s_org_ext). Both person_id and party_id are foreign keys from s_party.

PL/SQL : Check script for object owners

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:29:00 +0530

In real life development environments, you develope a script logged as UserX, and someone in Support Team will install it in production environment logged as UserZ.
So far, nothing unusual happens. But, if we are talking about oracle scripts, there's something that you have to deal with, Schemas, If you didn't reference all you objects with full name, SchemaX.TableA for instance, when UserZ tries to install it, he will not find TableA in is schema.

In simple scripts, with few lines, it's easy to manually check for errors, but try to do it in a scripy with thousand of lines...

So I've developed this procedure to "parse" my code looking for this kind of errors

FUNCTION CHECK_OWNER_IN_SQL(
p_list varchar2,
p_del varchar2
) return boolean
is
l_idx pls_integer;
l_list varchar2(32767) := p_list;
l_value varchar2(32767);
keyword varchar2(10000);
existsObject integer;
result boolean;
begin
result := false;
loop
l_idx := instr(l_list,p_del);
if l_idx > 0 then
keyword := substr(l_list,1,l_idx-1);
select count(*) into existsObject from user_objects where lower(object_name) = lower(keyword);

if existsObject > 0 then
DBMS_OUTPUT.Put_Line( 'Possible error in ' keyword);
result := true;
end if;

l_list := substr(l_list,l_idx+length(p_del));
else
keyword := l_list;
select count(*) into existsObject from user_objects where lower(object_name) = lower(keyword);

if existsObject > 0 then
DBMS_OUTPUT.Put_Line( 'Possible error in ' keyword );
result := true;
end if;
exit;
end if;
end loop;
return result;
end;

--Possible values for p_type are :
-- DATABASE LINK,FUNCTION,INDEX,PACKAGE,PACKAGE BODY,PROCEDURE,SEQUENCE,SYNONYM,TABLE,TRIGGER,TYPE,VIEW

PROCEDURE CHECK_OWNER(
p_owner IN varchar2,
p_type IN varchar2,
p_name IN varchar2,
p_sql IN varchar2 := NULL
)
IS
cursor lines
is
Select text from all_source where lower(owner) = lower(p_owner) and lower(type) = lower(p_type) and lower(name) = lower(p_name) order by line;
sqltext varchar2(32000);
result boolean;
linha integer;
begin
if p_sql is not null then
result := siebel.check_owner_in_sql(p_sql , ' ');
else
linha := 1;
for line in lines loop
sqltext := TRIM(line.text);
IF substr(sqltext,1,2) <> '--' then
if siebel.check_owner_in_sql(sqltext , ' ') then
DBMS_OUTPUT.Put_Line( 'Linha ' linha ': ' sqltext);
end if;
end if;
linha := linha + 1;
end loop;
if linha = 1 then
DBMS_OUTPUT.Put_Line( 'Não foi encontrado o objecto a validar');
end if;
end if;
end;

After create this two procedures, you have only to execute the last one, and watch for possible warnings in your output window.

SQL Navigator : Code Templates

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:28:00 +0530

After trying for a while to use SQL Navigator from Quest --> http://www.quest.com/sql-navigator/ to develope my pl/sql procedures and queries, I've found a new (for me) feature : Code templates. Tired of write allways the same kind of code structures ? Use code templates. How? It's easy. Just take a look at this help page from navigator help. (As a good developer that I am, I never read help files).

You can program Key combinations from "Ctrl+Shift+A" to "Ctrl+Shift+Z" with text up to 255 characters in length.
To program shortcut keys
From the View menu, choose Preferences.
Under the Code Editors preference heading, expand General, and then scroll down to the Templates category.
Where you see the words , click and then view or change shortcut key assignments as required.

Try it, and watch your development times drop a little bit !!!

S_POSTN_CON : Description

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:27:00 +0530

This table associates a contact with positions that can acess it. This relation is suported by column con_id (par_row_id from s_contact) and postn_id (row_id from s_postn).
This is a many-to-many relationship : A contact can have more than one position associated, and a position can be related with multiple contacts.
Keep in mind that con_id is foreign key from s_party.

Joins : Please talk ANSI SQL with me.

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:26:00 +0530

People, who had to port a Microsoft SQL Server or Access database over to Oracle, know what I'm talking about. This article --> http://certcities.com/editorial/columns/story.asp?EditorialsID=106 show us a good example of ANSI SQL joins and also show us a few good reasons why we should use ANSI join syntax instead of classic and specific join syntax :

You don't need to specify the join condition in a natural join;
You can do more with ANSI SQL join syntax than with classic Oracle syntax;
There is no performance penalty;
In the long run you will see more of it, and less of the older syntax;
It's portable;
It's easier to understand what is happening .

Bottom line is :

So join me in creating portable SQL joins that are easy to read, do more than you can with Oracle syntax, and don't slow you down.

WHy MINUS does NOT EXISTs in our queries?

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:26:00 +0530

Read this great (and old) article --> http://www.oraclemagician.com/mag/magic8.pdf about MINUS vs NOT EXISTS operators.

There really isn’t just one right way to design queries. In some cases, you really are better off using Not Exists. In many cases, however, you should use the set operator MINUS. Once you understand the principles, you can easily choose the best method for your particular case.

Get last file version

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:25:00 +0530

Imagine this situation:

You have two package P1 and P2 in the same stage, and both P1 (who is to be installed first) and P2 have an attached file F1;
In P1 the F1 file is in version 1, but in P2 is in version 3;

When I try to execute P1 and I try to get F1 file, Harvest return me F1 in version 3, when it has supposed to return version 1 of the file.

So take care when promoting 2 or more packages, to the same stage, with different version of the same file. Harvest only get the last version of it, regardless what version you included in your package.

Debugging in http://localhost:8082

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:24:00 +0530

Today I've made my first siebel project compilation, all my environment is brand new and well configured.
I've enabled 'Auto-start web client' feature and hit the road. IExplorer browses http://localhost:8082/ and inherent error. Why in God's name is this happening?

The answer is simple, (If my friend Alexandre didn't help me, it wouldn't be so simple), my Firewall is enabled.

After I disabled that, my debug can go on!!

Error 452: Match column X not found in Y

sirish.sites@gmail.com (Sirish WebWorld) — Wed, 7 Jan 2009 10:23:00 +0530

Today I had to create a new column in EIM_CONTACT table, to build a new attribute mapping for deletion purposes. All went fine until I test my EIM task.

Error 452: Match column X_COLUMN not found in S_CONTACT.

I run trough all my steps to find what's wrong in it. All seems to be in perfect shape. My next step was to loose some time reading bookshelf and Siebel support SR's. Nothing came across that helped me to solve my problem.

Last step in problem resolution algorithm, ask for help. Allways work!!

My colleague João had the solution, Siebel caches EIM mappings in \siebsrvr\BIN\diccache.dat, all we have to do is delete this file and Siebel will build a new one for you (with your new mappings).

Finally, I successfully ran my EIM process.

A distant past - Part 1 Siebel

sirish.sites@gmail.com (Sirish WebWorld) — Fri, 12 Sep 2008 14:24:00 +0530

When did the whole thing start?

Well, one of the answers is found in the vast archive of the Wayback Machine ---> http://www.archive.org. If you search for www.siebel.com you are taken back to the mid-90ies and a somewhat unpretentious website from 1996. Just in case the archive gets lost some day, I have preserved a screenshot of the 1996 siebel.com website myself.

A distant past - Part 2 or "It's still there"

sirish.sites@gmail.com (Sirish WebWorld) — Fri, 12 Sep 2008 14:23:00 +0530

Tom on TV

the Siebel Sample Database comes together with a sample file system, which reveals most of its parts when you navigate to the Administration - Document screen and the Literature view. The content there is intended to support the sample data such as products and their images but there are also some kind of random pebbles to be found by the more leisurous among you. Just some samples (SIA or SBA refers to the Siebel Industry Applications or Siebel Business Applications - formerly known as HORizontal - variety of Siebel CRM):

.mov files from a documentary about diabetes (SIA)
a graphic file showing 10 deutsche mark (SIA and SBA)
an 84 page prospectus for a fictitious company named Sycamore Networks (SIA)

and of course - because this is what this post is all about:

a TV ad featuring Tom Siebel (maybe 1998), to be found in the SBA sample database

So it is up to you to find the most interesting file and maybe post it here as a comment.

In case you do not have an installation of Siebel CRM 8.0 with the sample database at hand

Automating the Application Deployment Manager (ADM) packaging process

sirish.sites@gmail.com (Sirish WebWorld) — Fri, 12 Sep 2008 14:22:00 +0530

"Open the box, open the box!"

Introduced in version 7.7 of Siebel CRM, ADM (Application Deployment Manager) has been significantly enhanced in version 8.0. The purpose of ADM is to assist developers and administrators to deploy changes made to the Siebel Repository, the physical UI files, Actuate report files and – last but not least – the administrative data of a Siebel CRM application from one enterprise (e.g. development) to another (e.g. test).

Version 8.0 of Siebel CRM also introduces the Siebel Management Server and Siebel Management Agent. These java based modules are used for the packaging and deployment of the a/m changes.

This post covers the techniques to automate the ADM packaging process. It mainly focuses on command line utilites which can be invoked as part of a shell script.

1. Initialize the package / create folder structure using admpkgr

The command line utility for ADM packaging is admpkgr. It resides in the /mgmtsrvr directory of the Siebel Management Server installation.

For automation purposes, shell scripts can be used similar to the following:

call admpkgr init d:\ousea\mgmtsrvr\adm\packages\xyz_package_01

2. Export database types (administrative data) using srvrmgr

Bookshelf Reference: Application Deployment Manager Guide version 8.0: Creating ADM Deployment Units from Database Types Directly from Command-Line --> http://download.oracle.com/docs/cd/B40099_02/books/AppDeployMgr/AppDeployMgr_CreatePkg7.html#wp1009283

To automate the export of administrative data objects such as LOVs, Data Maps, Responsibilites and many more (ADM natively supports more than 60 data types in version 8.0), the ADM Batch Processor server component (new in version 8.0) can be used.

Using the ‘start task’ command from a srvrmgr prompt works as expected for the ADM Batch Processor, however some issues have been reported with passing the parameters. Here are two versions to do it. The first one is passing the parameters using the ‘with’ clause. The second is setting the parameters and then restarts the component.

We are using an input file here, so the basic command would be as follows (note the /i switch):

\bin\srvrmgr /g /e /u /p /s /i ""

Sample input file for version 1:

start task for comp admbatchproc with admpath=\mgmtsrvr\adm\packages\xyz_package_01\database,admdatatype='EAI Data Map',admfilter='[Name] LIKE "XYZ*"',admeaimethod=synchronize,admprefix=XYZ_EAIDMAP

Sample input file for version 2 (which is safe especially for the admfilter parameter):

shutdown comp admbatchproc
sleep 60
change param admpath=d:\ousea\mgmtsrvr\adm\packages\xyz_package_01\database for comp admbatchproc
change param admdatatype='EAI Data Map' for comp admbatchproc
change param admfilter='[Name] LIKE "XYZ*"' for comp admbatchproc
change param admeaimethod=synchronize for comp admbatchproc
change param admprefix=XYZ_EAIDMAP for comp admbatchproc
startup comp admbatchproc
sleep 20

Here is an explanation of the parameters for admbatchproc:

admpath = Location for resultant export files
admdatatype = Name of Data Type (as in Application Deployment Manager screen)
admfilter = Filter to be applied on the data type. For example, '[List Of Values Parent(UDA).Value]="NM"'
admeaimethod = One of three methods: upsert, synchronize, or custom
admprefix = Prefix for the name of exported XML file

3. Export repository changes using consoleapp.exe

Bookshelf Reference: Application Deployment Manager Guide Version 8.0: “Using Consoleapp.exe to Create Repository Deployment Units” --> http://download.oracle.com/docs/cd/B40099_02/books/AppDeployMgr/AppDeployMgr_CreatePkg22.html#wp1012566

The command line utility consoleapp.exe (in the Siebel Tools bin directory) can be generically used to invoke business service methods within a Siebel application from the command line (headless, i.e. without rendering a GUI). The ADM framework provides a bunch of business services which are used mainly for reloading the various caches or – in this case – for exporting repository changes.

In a shell script example, one would use consoleapp.exe to call the “Siebel Tools Export Support for ADM” business service as follows to export the “XYZ New Order for Account” Workflow:

\bin\consoleapp "\bin\enu\tools.cfg" ENU SADMIN "Siebel Tools Export Support for ADM" "Export:Repository=Siebel Repository,Object_1=XYZ New Order for Account,Type_1=Workflow Process,ExportFile=\mgmtsrvr\adm\packages\xyz_package_01\repository\XYZ_WF_1.sif,DescriptorFile=\mgmtsrvr\adm\packages\xyz_package_01\repository\XYZ_WF_1_des.xml,ExportCount=1,LogFile=d:\temp\adm.log"

If this is your first exposure to consoleapp.exe, it might feel a little weird. Here is the syntax:

consoleapp.exe "" “:"

An alternative way to use consoleapp.exe according to bookshelf is to use an xml input file. I have not yet had the privilege to test this in real life, however. The syntax is as follows:

consoleapp.exe /f inputfile.xml

Caveat ---> http://en.wikipedia.org/wiki/Caveat: Make sure that the descriptor file name is exactly spelled like the export file name, having .xml (instead of .sif) as the file type and des as the suffix. Example: ExportFile=XYZ_WF_1.sif, DescriptorFile=XYZ_WF_1_des.xml.

4. Export file types using OS utilities

Files, such as web template files (.swt), must also be copied into the respective package directories. Since there is no dedicated utility provided by Oracle, the shell script would refer to classic file copy utilities. The following is an example for Windows xcopy:

#copy all web template files changed since June, 1st 2007 to the webtempl directory
xcopy \WEBTEMPL\*.swt \mgmtsrvr\adm\packages\xyz_package_01\file\AppServer\webtempl /D:06-01-2007

5. Delete empty subdirectories using OS utilities

It is best practice to delete empty subdirectories to increase processing time and decrease the amount of warnings during packaging and deployment. This would be accomplished using classic OS utilities. The following is a windows example:

rd \mgmtsrvr\adm\packages\xyz_package_01\File\AppServer\reports\enu

6. Generate the package descriptor file using admpkgr

Now it’s time for admpkgr again. As in step 1, it can be used in a shell script with the ‘generate’ option as follows:

call admpkgr generate \mgmtsrvr\adm\packages\xyz_package_01

7. Validate the package using admpkgr

Here is a windows example how to call admpkgr from a shell script and direct the output to a log file:

call admpkgr validate \mgmtsrvr\adm\packages\xyz_package_01 >> "d:\temp\admpkgr_out.txt"

Summary

The ADM packaging process is multifold, and various command line tools come into play when you want to automate it, namely admpkgr, srvrmgr, consoleapp.exe and OS file system manipulation tools.

Business Process Solution Library Siebel

sirish.sites@gmail.com (Sirish WebWorld) — Fri, 12 Sep 2008 14:20:00 +0530

Here I go again

If you have been involved in Siebel CRM projects over the past years, you might have come across some business analyst who mentioned the Siebel Business Process Solution Library (BPSL), which has been released as part of the strong business process strategy together with Siebel CRM version 7.5 in 2002.

Teaching the approach to analyze your business processes and align them with the out of the box functionality BEFORE you start customizing the hell out of your CRM app during the Business Analyst courses ---> http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=213&path=SCRM&columnNumber=3*, Siebel instructors all over the world were challenged to position the library NOT as a complete encyclopedia of all business processes that you can do in Siebel applications. To be honest, this would be a ridiculously small library given the vast functionality of Siebel CRM.

In contrary, the BPSL describes - that is at least mho - common best practice approaches to business processes which are (of course) supported in Siebel out of the box.

However, the BPSL has had a rich (including integration with Corel iGrafx and IBM Rational Requisite) but also difficult past and finally has emerged again on metalink3, Oracle's support portal for Siebel CRM customers. So if you have access to metalink3, you also have access to the link below.

Link to BPSL on metalink3 ---> https://metalink3.oracle.com/od/faces/secure/km/DocumentDisplay.jspx?id=554746.1&h=Y (credentials needed)

*Note: The current Business Analyst training does not teach the BPSL.