Siebel Musings

Scripting --> How to PopUp Applet Using scripting

2011-09-07T03:01:00.000-07:00

Using below code we can pop up applet using scripting

case "MyTest":
var oServiceAF = TheApplication().GetService("SLM Save List Service");
var inputPropAF = TheApplication().NewPropertySet();
var outputPropAF = TheApplication().NewPropertySet();
inputPropAF.SetProperty("Applet Name",);
inputPropAF.SetProperty("Applet Mode", "6");
oServiceAF.InvokeMethod("LoadPopupApplet", inPropAF, outPropAF);
return(CancelOperation);

drilldown on ActivityType in Activity Applet. It doesn’t take you to the record you have clicked on but takes you to the firs

2011-07-14T03:11:00.000-07:00

Thanks Bhavesh for sharing below info

When on Home Page, and drilldown on ActivityType in Activity Applet. It doesn’t take you to the record you have clicked on but takes you to the first record in activities.

à What was done to fix it.

Go to the Activity Home Page Applet. Check for all drilldown objects on ActivityType

Add ‘Id’ (specifically) in Source & Destination fields

Compile n release the SRF

Siebel v7.7 has a different query than v8.1..

Sample Thick Client Not working .IE showing Page Cannot be displayed

2011-07-14T02:59:00.000-07:00

Thick client is not working for sample in IE 7 .

I tired below things

Put the site under Trusted Site
Checked for the ODBC Connection
tried to open from debug mode [Still not working ]

At last i did two changes i dont know which helped me in resolving it .

--> Client CFG >> EnableFQDN Changed to False
Siebel Mobile Web Client. To use FQDN for this client type, configure the following parameters in the Siebel application configuration file, such as uagent.cfg for Siebel Call Center, on each local client machine.

[Siebel]
EnableFQDN = TRUE

EnableFQDN is set to TRUE by default for the Siebel Mobile Web Client.

If you do not also specify the FQDN parameter, the system constructs the URL automatically. For example, the system might construct the FQDN for CCHENG as ccheng.corp.oracle.com. Optionally, you can explicitly provide similar information below, using the FQDN parameter.

CAUTION: When you explicitly configure an FQDN for use with the Siebel Mobile Web Client, you must specify the local machine name. The localhost string from the default Siebel Mobile Web Client URL (which is used when EnableFQDN = FALSE) cannot be used as an element in an FQDN. The localhost string is only functional when used by itself, with no additional qualifying elements.

FQDN = hostname.primaryDNS.domainsuffix

where:

* hostname is the name of the local client machine
* primaryDNS is the primary part of the domain name (such as siebel)
* domainsuffix is the domain type (such as com)

For example, you might set FQDN to ccheng.corp.oracle.com.
---> Reinstall IE 7

after doing tht it starts working

thanks and regards
Joseph (Joju)
joju2002@gmail.com

Calc the working days between two days including the public holidays

2011-07-05T00:18:00.000-07:00

Using below code we can find the number of working days between two dates inculding the public holidays . I wrote this code long back for one POC .I guess it will work :-) .

Req : I have to find working days between two dates ie : i have to remove weekends/ Public Holidays between two dates

function Service_PreInvokeMethod (MethodName, Inputs, Outputs)
{

if (MethodName=="Working Days")

{
//MM DD YYYY format
var StartDate = Inputs.GetProperty("StartDate");
var EndDate = Inputs.GetProperty("EndDate");
var start= new Date(StartDate);
var end = new Date(EndDate);

return (ContinueOperation);
}

Siebel Configuration Best Practices

2011-06-22T05:32:00.000-07:00

Adding System Columns as BusComp Field Objects Definitions

System columns are exposed as BusComp fields. These columns can be exposed as controls or list columns on applets without explicitly defining them in the BusComp definition.

System Field	System Column Name	Description
Id	ROW_ID	Primary key for the table
Created	CREATED	Creation date and time of the row
Created By	CREATED_BY	User logon ID of the person who created the row
Updated	LAST_UPD	Date of last update of the row
Updated By	LAST_UPD_BY	User logon ID of the person who last updated the row

Consequence

The fields Id, Updated, Updated By, Created, and Created By are available system fields that can be exposed and presented in the user interface or used in script without explicitly defining them as BusComp fields.

This introduces a data integrity issue, if such a field is exposed in the UI and the user enters data into it, the data will not be saved to the database. The application will ignore the user’s data and use the system data. When a user enters a value in such a field and later accesses the same record, they will not see the value entered.

Recommendation

Do not create BusComp fields mapped to system columns, as they are available for use in configuration and scripting without being explicitly defined, and doing so may introduce the type of issues indicated above in the consequence section.

Where such fields have been created, remove them from the BusComp definition and remap any existing references, such as list columns, controls, joins, and so forth to the supplied system column. Do not forget to verify that any script that references the custom fields is also updated.

Join Specifications on S_PARTY Extension Tables

Join specification to Party extension table has been created with the destination column property set to ROW_ID.

Consequence

Only the PAR_ROW_ID column should be used as the destination column in join specifications to S_PARTY extension tables. This is because the PAR_ROW_ID column contains the proper foreign key relationship to S_PARTY.

Although ROW_ID and PAR_ROW_ID is equivalent in most cases for party extension tables, configuring a join in this manner is not recommended, and this unexpected behavior may not be the case in future releases and this accidental success may not be the case in future releases if the table structures change.

Recommendation

When creating joins to S_PARTY extension tables such as S_ORG_EXT, S_CONTACT, S_POSTN or S_USER make sure that the join specification has a destination column of PAR_ROW_ID. Perform a search in the Siebel Tools and look for the Base table property to identify the S_PARTY related tables. The screenshot below shows some of the S_PARTY tables in the customer repository.

3. Non-Indexed Search / Sort Specifications

Several search and sort specifications were identified as keying off non-indexed columns. When specifying search and sort specifications it is important to use fields mapped to indexed columns, whenever possible.

Sorting or searching on non-indexed fields can have detrimental effects on database performance, especially on large tables, as it will produce table scans and temporary tables in the SQL execution plan.

Keep in mind that pre-defined queries where the filter or sort is based on a non-indexed column will also result in a performance impact.

How to update the Query fired in UI [this.GetSearchExpr();]

2011-06-22T04:54:00.000-07:00

Req: I have to catch the Query before firing in UI .

Solution : this.GetSearchExpr(); In BC Server Script PreQuery

Code

function BusComp_PreQuery ()
{
/
try
{

var sSearchExpr;
var sActiveViewName;
sSearchExpr = this.GetSearchExpr();
//If u want to update query for a particular view
sActiveViewName = TheApplication().ActiveViewName();

//add the validation
if(TheApplication().GetProfileAttr("EEEE")>="Value"&& (sActiveViewName == "DSDS" || sActiveViewName == "XCDD" || sActiveViewName == "ZXXX"))
{
//SearchBuild Method is a custom method for creating Custom Query
var SearchString = SearchBuild();

if(sSearchExpr!="" && SearchString !="")
sSearchExpr += " AND (" + SearchString + ")";
else if (sSearchExpr!="" && SearchString =="")
sSearchExpr = sSearchExpr;
else
sSearchExpr = SearchString;

}

// If u need this Query in somewhere else put it in Profile attribute

this.SetSearchExpr(sSearchExpr);
this.ExecuteQuery(ForwardOnly);
}
catch (e)
{
var dbg = e.errText;
TheApplication().RaiseErrorText(e.errText);
}

return (ContinueOperation);
}

Note: GetSearchExpr returns the current search expression for the business component.

Returns
A string containing the current search expression. An example of a returned search expression string is "Revenue > 10000 AND Probability > .5".

Usage
GetSearchSpec retrieves the business component state, not the values. The business component state does not change until the query is executed. Note that it may never change to the original value if the user input is invalid.

When using GetSearchExpr in a browser script and the Applet_PreInvokeMethod, GetSearchExpr returns a null value even if a query filter has been added.

Used With
Browser Script, COM Data Control, COM Data Server, Java Data Bean, Mobile Web Client Automation Server, Server Script

10 Ways To Access Blocked WebSites

2011-06-21T21:45:00.000-07:00

Copy Paste from Another Site .But it is useful :-)

Websites like facebook, twitter and other social networking sites are generally blocked in schools, colleges and offices. There exist some tricks by which you can bypass the restrictions and access blocked sites, the most obvious is the use of proxies or Anonymizer websites. But using proxies doesn’t always works as they gets blocked by firewall as well. Here I am listing some other methods to access blocked contents.

1. Use IP instead of URL
Each website has its equivalent ip address. This method works best when blocked sites are stored as a list of URLs. You can use ip address to access blocked contents . For example to access facebook you can use ip address 69.63.189.11 in your address bar. You can use ip-address.com to find the ip address of other websites.

2. Use Google Cache
All major search engines like Google yahoo and Bing stores cached pages of websites themselves. You can access blocked websites by viewing their cached copy on search engines.

3. Translations services
Translation services like Google Translate, translate a website from one language to another and display the translated results on their own page. You can access the blocked website by re-translating blocked url using such online translation services.

4. Retrieve web pages via Email
Web2Mail is a free service that sends any websites into your inbox. All you need to do is send an email to www@web2mail.com with the URL as subject title.

5. WayBack Machine
Wayback machine periodically keeps a copy of almost all websites on the internet from the date they have started. You can access your blocked site by fetching its latest copy from archives.

6. Screen-Resolution.com
Screen-Resolution.com allows you to view any website in a different resolution. This could be an interesting tool to access blocked websites.

7. Google Mobile Search
Google Mobile Search displays a web page as if you are viewing it on a mobile phone. You can use it to access blocked websites but javascript and css will be disabled.

8. Redirect with Short URL service
Short URL service are used for converting a long URL in a shorter one. You can convert your blocked url into a shorter one and use it to access blocked websites. This trick dont always works. The two popular url shortening service are bit.ly and adf.ly

9. USB Browsing
You can use this method if you have access to usb port, you can load usb with your own portable Firefox, with the portable Tor plugin or you can directly use tor-firefox.

10. Proxy Websites
This is the generally known method to access blocked websites. There are thousands of online proxies you can use to surf anonymously or to access blocked websites. Here is 90+ Proxy Websites To Access Blocked Websites.

3 buttons with same method as “Show Popup” for showing popup applets

2011-06-20T04:17:00.000-07:00

This Req/Solution i got it from Karthik . Thanks Karthik

Issue: We have 3 buttons with same method as “Show Popup” for showing popup applets, but the buttons need to enable/disable based on the conditions. It would be difficult to enable/disable button as the all buttons are sharing the same method name.

Solution:

Inputs taken from another Siebel blog.

Give different method names for 3 buttons.

Alternative way to invoke the show popup using browser script

Write the below Browser script to invoke the “Show popup” method, when the button is clicked.

function Applet_PreInvokeMethod (name, inputPropSet)

{

// code to enable the buttons as show popup

try

{

if(name == "XXX" || name == "YYY" || name == "ZZZ")

{

inputPropSet.SetProperty("SWEMethod","ShowPopup");

this.InvokeMethod("ShowPopup",inputPropSet);

return("CancelOperation");

}

Write the server script in Pre Can Invoke method as usual to disable/enable button based on conditions.

function WebApplet_PreCanInvokeMethod (MethodName, &CanInvoke)

{

try

{

var pstntype = TheApplication().GetProfileAttr("Primary Position Type");

if((MethodName == "XXX" || MethodName == "YYY") && (pstntype == "CCC" || pstntype == "DDD"))

{

CanInvoke = "FALSE";

return(CancelOperation);

}

else

{

CanInvoke = "TRUE";

return(CancelOperation);

}

catch(e)

{

TheApplication().RaiseErrorText(e.tostring());

}

finally

{

pstntype = null;

return (ContinueOperation);

}

Some more Business Component Methods

2011-06-16T03:45:00.000-07:00

ActivateMultipleFields
Property set containing a collection of properties representing the fields that are to be activated

SetMultipleFieldValues assigns a new value to the fields specified in the property set for the current row of the business component.

GetMultipleFieldValues returns values for the fields specified in the property set.

Code
var ContactBO = TheApplication().GetBusObject("Contact");
var ContactBC = ContactBO.GetBusComp("Contact");
with (ContactBC)
{
SetViewMode(AllView);
var fieldsPS = TheApplication().NewPropertySet();
var valuesPS = TheApplication().NewPropertySet();
fieldsPS. SetProperty("Last Name", "");
fieldsPS.SetProperty("First Name", "");
ActivateMultipleFields(fieldsPS);
ClearToQuery();
ExecuteQuery();
if (FirstRecord())
{
GetMultipleFieldValues(fieldsPS, valuesPS);
var slName = valuesPS.GetProperty("Last Name");
var sfName = valuesPS.GetProperty("First Name");
}
}

GetFormattedFieldValue Method

A string containing the value of the requested field, in the same format as displayed in the user interface, or an empty string ("") if the field is inactive or empty.

Usage
GetFormattedFieldValue is useful for code that is used in multiple countries with different formats for currency, date, and number. This method can be used only on fields that have been activated using ActivateField.

Some special behavior is associated with particular data types.

PreWriteRecord to fire only for New Records being saved [Method : isNewRecordPending]

2011-06-13T03:55:00.000-07:00

I got this information from my friend Pranoj . Thanks Pranoj ..

Scenario: User wants a few validation written on the PreWriteRecord to fire only for New Records being saved
Solution :
A Vanilla Method “isNewRecordPending” can be used to achieve the required functionality

This method can be invoked by using a script in the PreWriteRecord event to determine if the current record is newly created. If the record is a new record, this method returns the value TRUE

Sample Code :

function BusComp_PreWriteRecord ()

{

var isNewRecord = this.InvokeMethod("IsNewRecordPending");

if(isNewRecord == "TRUE")

{

************Code Goes Here***********
}

return (ContinueOperation);

}

Syntax :
BC.InvokeMethod(“isNewRecordPending”)

Advantage : This method reduces the overhead of Setting and Resetting the Global Variable captured at the NewRecord Event

Note : This method can be used across Events and is not specific only to PreWriteRecord

How to make your cell phone Not Reachable

2011-06-13T00:10:00.000-07:00

First of all Thanks for visiting our Siebel Musings Blog .Actually this is an Siebel Technical blog [Siebel Musings].But this time i am giving a tip to avoid Work related calls in weekends. As we have to give importance to our personal life some times it is necessary to use this trick .

There are times when you wished you should be in the mountains away from mobile network reach.

Or sometime you wanted to avoid a call but did not want the caller to know you are not picking calls intentionally?

Definitely you will not switch-off the mobile. The caller will hear a message saying your mobile is switched off. That means you intentionally switched it off! and some phones got features like offline mode .but still the end user will hear mobile switch off message. Excuses like your phone charge went off ..you didn’t take the charger wont make any sense .So we need some good excuse .

So what if the caller hears a message like “the phone is not reachable”, or “out of network”?

‘Mobile not reachable’ is a good excuse for everything you wanted to avoid. Now see how easily you can do it. After all it was the operator’s fault. Not yours!

Problems being not reachable on cell phone:

Yes, there could be problems. You never know when you miss a very important call.

Pre-requisite

--Call your family , Gal frd /boy frd.[Otherwise thy will get afraid] :-)

Step

1) This trick is very simple . Without switching it off remove the Battery of ur mobile.WE normally do it when our phone got hang ,Do the same . And don’t switch it on .

Nw if someone is trying to call you thy will hear Mobile not reachable message .. ;-) Cool naaa

Tested in Sony ericsson and Nokia

2) If the end user is intelligent .they will drop a sms with delivery report on . that means whn u switch it on message will get delivered and the end user will get the Delivery report and he will come to know tht ur phone is on .

For this .. Go to message setting in your fone >>Text Message >> Message Centers >> find the correct SMS Center for ur service operators .

there will be a number note that number some where and remove the number and save it .Once you back from your cover you can update the number back.

Now you wont receive any sms and the end user wont get any delivery report .if there is any emergency you can switch on your Phone .Make the call and again switch it off .. ;-)

Note : I wont be responsible for any personal or professional issues by using this trick .:-)

Joseph Thomas (joju)

Runtime versus Compiled Business Services with same name

2011-06-01T05:40:00.000-07:00

If you define a business service called MyService as a runtime business
service and as a compiled business service, the compiled version executes and
the runtime version is ignored. For clarity, if you migrate a business service
from a runtime version to a compiled version, you should inactivate or delete
the runtime version so that it is clear to all developers that the runtime
version is no longer being used.

Business services may be defined in Siebel Tools and compiled with the .srf
file, or created as runtime business services in the client user interface. The
decision on whether to make a business service compiled or runtime has no
hard and fast rules. It ultimately depends on what you intend the service to
do and how frequently you expect the code in the business service to change.
Runtime business services are not compiled into the .srf file.

The database stores them as records and you can change them at any time. The next time a
runtime service executes, it uses the changes to the definition. This makes
them useful for logic that changes frequently and logic that you need to
change without deploying a new .srf file.

The drawback to a runtime businessservice is that anyone with access to the Business Service Administration view
can see the code. This can pose a security issue.Runtime business services can be useful in a development environment to test frequent changes to scripts by using the business service simulator. Since no
compiling is required, code development may be faster in the runtime
environment. Once the code is complete and tested through the simulator,
the developer can choose whether the business service should remain as a
runtime service or if it should be migrated to Siebel Tools.
Compiled business services are defined in Siebel Tools and represent a
functionality that needs more security and is not likely to change. You must
compile and implement a new .srf file to implement any changes. Because
these business services are compiled, they provide more security than
runtime services and they are faster to load.

Performance Tuning SOS !

2011-05-28T03:36:00.000-07:00

If you are in a Siebel project and in the midst of performance issues firefight, we can help you !!!
Post in your performance issues to Siebel Musings !
You can use the comments section to provide details !

Some Facts on Data Visibility

2011-05-02T01:17:00.000-07:00

Some Facts on Data Visibility

Fact 1

clicks on the "Generate Reporting Relationships" button :

Records in the S_PARTY_RPT_REL are created when a new record is inserted in S_POSTN, or when a user clicks on the "Generate Reporting Relationships" button in the Position administration view.

It would be extremely difficult to describe an unknown number of iterations of the position/parent position relationship with a single SQL statement. Siebel solves this problem by writing each position's reporting relationships to a table called S_PARTY_RPT_REL

Fact 2

Error

SBL-DAT-00309: 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.

Corrective Action

Corrective Action

1. Inspect the record where the user receives the error:

a. Determine if the user is on the access list for the record. To determine what controls the visibility of the record, review the BusComp View Modes set up for the business component and check the Visibility Field and Visibility MV Field properties.

b. Make sure there is at least one user on the access list for the record, especially if the record was imported using EIM or if you have customized the visibility settings for the related objects.

c. If the drilldown is on the same buscomp, any constraint on the original context of the buscomp, such as a query executed by the user, will be maintained.

2. In Siebel Tools, check the configuration of the drilldown, drilldown view and applet, and related business component to determine why the user does not have visibility to the drilldown record.

a. On the destination view, check the Visibility Applet and Visibility Applet Type properties. Check for a default PDQ, or a Search Specification defined on the driving applet or destination business component, which would prevent the user from seeing the drilldown record

b. On the Drilldown Object, check the following:

i. Visibility Type property on the Drilldown Object. For more information, refer to Siebel Bookshelf version 8.1 > Siebel Security Guide for Siebel eBusiness Applications > Configuring Access Control > Additional Access Control Mechanisms > Configuring Drilldown Visibility.

ii. Business Component setting on Drilldown Object

iii. Make sure the Hyperlink property is set.

iv. If you have defined the Source Field and Destination Field properties, make sure the field values will be an exact match. For example, if you use a non-System field that defaults to a Row Id, ensure that records created through EIM will have this field set appropriately.

3. If you have configured a dynamic drilldown, check the following in Siebel Tools:

a. The logic in the configuration of the dynamic drilldown must ensure that users will drill down to a view where they can see the records in question.

b. The parent Drilldown Object should have Sequence = 1.

c. The destination view defined for the parent Drilldown Object should be available in the user's responsibilities.

d. The Field property on the Dynamic Drilldown Destination object must be active in the buscomp instance.

e. Check the Value property defined in the Dynamic Drilldown Destination object

For more information on the above suggestions, refer to Siebel Bookshelf version 8.1 > Object Types Reference > Siebel Object Types for the Drilldown Object, View, BusComp View Mode, Business Component, and Applet object types. Also refer to Siebel Bookshelf version 8.1 > Configuring Siebel eBusiness Applications > Configuring Screens and Views > About Drilldowns.

4. If you have customized the Calendar Drilldown behavior,

5. You must extract a mobile client before you can drill down on the mobile client name.

6. Create bookmarks from list views instead of detail views.

7. When registering a Partner, you need to check the Organization flag.

Fact 3

Why does my -Pick Applet- display all records for a user who does not have -All- visibility?.

When the Popup Visibility is set to FALSE, no visibility is applied to Pick and Association Applets.

For example, in the standard Siebel configuration, the ‘Popup Visibility’ for ‘Account’ Business Component is set to FALSE. Hence, any Pick Applet or Association Applet based on the ‘Account’ Business Component will display all the Account records irrespective of whether the user has visibility to ‘All’ Accounts or not.

Setting the Popup Visibility of a Business Component to TRUE, should limit the records displayed in Pick Applets and Association Applets to only those records that are displayed in a ‘My’ view of that Business Component.

For example, in the standard Siebel configuration, the ‘Popup Visibility’ property on the ‘Opportunity’ Business Component is set to TRUE by default. Hence, all Pick Applets and Association Applets based on the ‘Opportunity’ Business Component will always display only those Opportunity records that are visible to a user in the ‘My Opportunities’ view.

Runtime Workflow

2011-04-20T22:37:00.001-07:00

I heard this question from my colleague ..
Q) Workflow Process manager is down in the server .There is an Run time which will call the workflow on an particular event .Now the Question : If the event happened will the workflow will execute or will it fail . If yes how how it will be executing .

-->Some Hints
calling workflow from Run time

run-time environment is available both as a business service and as a server component.

The two Workflow business services are:

Workflow Process Manager
Workflow Process Manager (Server Request)
When the Workflow Process Manager business service is called, the workflow process is run in the object manager of the application called. When the Workflow Process Manager (Server Request) business service is called, the workflow process is run in the server component called Workflow Process Manager.

The Workflow Process Manager server components act as the application object manager to run workflows.
The Workflow Process Manager server components are specialized server components configured and tuned to run workflow processes. Like all server components, the Workflow Process Manager server components provide a multi-threaded environment.

The Workflow Process Manager uses the Siebel Object Manager framework and runs workflows as a business service.
The Workflow Process Manager hosts the Business Object layer and the Data Object layer. It is a scalable architecture with the ability to run multiple object managers and multiple tasks for each object manager.
NOTE: The name Workflow Process Manager refers to both the Workflow business service (referred to as the Workflow engine) and the workflow server components.

http://download.oracle.com/docs/cd/B31104_02/books/BizProcess/BizProcess_Architecture6.html

Calling workflow from the script

When invoking a workflow process from script, you can specify that the process run on the server or in the object manager:

To run a process on the server, call the service Workflow Process Manager (Server Request).
To run a process in the application object manager, call the service Workflow Process Manager.
Note that invoking a workflow process from script is performed in Synchronous mode.

Eg service Workflow Process Manager (Server Request)

//function Invoke_Process()

{

var svc = TheApplication().GetService("Workflow Process Manager(Server Request)");
var Input = TheApplication().NewPropertySet();
var Output = TheApplication().NewPropertySet();
var bo = TheApplication().ActiveBusObject();
var bc = bo.GetBusComp("Opportunity");
var rowId = bc.GetFieldValue("Id");
var accountId = bc.GetFieldValue("Account Id");
Input.SetProperty("ProcessName", "My Opportunity Process");
Input.SetProperty("Object Id", rowId);
// Pass the value of the Account Id field to the Account Id process property
Input.SetProperty("Account Id", accountId);
svc.InvokeMethod("RunProcess", Input, Output);

}

Eg: / Example: Invoking a Workflow Process through scripting
function Invoke_Process()
{
var svc = TheApplication().GetService("Workflow Process Manager");
var Input = TheApplication().NewPropertySet();
var Output = TheApplication().NewPropertySet();
var bo = TheApplication().ActiveBusObject();
var bc = bo.GetBusComp("Account");
var rowId = bc.GetFieldValue("Id");

Input.SetProperty("ProcessName", "My Account Process");
Input.SetProperty("Object Id", rowId);

svc.InvokeMethod("RunProcess", Input, Output);
}

Oracle Function --CONNECT BY PRIOR

2011-04-18T02:17:00.000-07:00

Today i come across new oracle Function "onnect by Prior "

CONNECT BY PRIOR
Desc:-
A condition that identifies the relationship between parent rows and child rows of the hierarchy

Syntax:-
CONNECT BY =

Example :-
SELECT employee_id, last_name, manager_id
FROM employees
CONNECT BY PRIOR employee_id = manager_id;

To show Level
First to note here is a pseudo column named "level" (similar to rownum) available with connect by clause showing
where in the hierarchy is current row. We could use it to show the hierarchy in list more visible.

SQL> SELECT LEVEL, lpad(' ', LEVEL*2) || ename ename
2 FROM emp
3 START WITH mgr IS NULL
4 CONNECT BY PRIOR empno = mgr;

SRF Problem

2011-04-15T05:04:00.000-07:00

Hi ,

For this problem i wasted one full day in it . i did one release in our dev env and as it is critical issue lead ask me to release in another env. AS this new env doesnt have local he said make the changes directly in server [Too risky] and the same time said test it using that server srf using dedicated .

First i logged into the server tools and made the changes carefully to that BS . then i took that server srf and compiled the changes to the srf . everything went fine ..

Now the testing part .. i opened the dedicated started with the testing .but it failed ..

i started with the dedug and started .. everything is fine .. in the BS there is one step where it will query for a record in a BC .. and it is not returning anything . But in my another env it is returning the record.

Then i thought there will be some issue with BC search spc in other server. i checked the search spc ..there is no change in the search spc...

then i took the spool of both the env for that query .. still it same .

then later i came to know that the srf i copied from the server was a wrong one .... whn i copied the correct one and tested it worked fine .

Dont know whats the exact issue .But issue got solved when i copied the correct SRF .

thanks and regards
Joseph Thomas (Joju)

How to create a VBC for a Pickapplet

2011-04-11T23:14:00.000-07:00

Yes i know it is a well document section in siebel Bookshelf .But i like to share my experience in it .

My requirement was i have to create Picklist for a VBC so for this requirement i have to create below objects
1) VBC
2) Pick Applet
3) PickList
4) BS

in our requirement when the user clicks on the pickapplet icon depending on the values the user entered Pick Applet have to Query and display the values

for eg: If value A entered in the BC field X for the record then the picklist has to show values
AA, BB,CC .If values B entered in the BC field X for the record then the picklist has to show values DD,EE,FF from the external system .

It is very clear straight forward requirement . The tricky point is the picklist is on Econfigurator

**Solution ***
Created all the above objects
BC-- >when we create a VBC we are not suppose to give the table name it has to blank and class of the particular type
have to create user property as Service Property of the BS name

BS --> Created new BS with Init and Query method

Configured the picklist and pickapplet .. compile the object and when i open Picklist is not opening .

Debugging
As the picklist is on econfigurator we have to do below action before testing

As part of testing we copied below files copied to my local .But still unable to open the pickapplet

Step 0 -> Download WebTemplate from clearcase path \SIE_DEV\Webtempl and copy into local folder \web client\WEBTEMPL

Step 1 -> Download cfgclient.js, cfgui.js, customconfigurator.js from SIE_DEV\css_EVOLUTIVO and copy into local folder PUBLIC\lang_code\siebel_build_number\SCRIPTS

Replace the srf

Run genb.bat in local

Cleared the browser temp files

restarted the client .Still it is not opening the pickapplet .

After checking we come to know that there was small issue in my query and it is throwing error . After fixing the error in Query, Pickapplet start showing

Joseph (Joju)

Error acquiring file lock(SBL-GEN-10116)

2011-02-23T01:57:00.000-08:00

Problem
-------

Importing a workflow in Siebel Tools 8.1.1 gives the following error
"Error acquiring file lock(SBL-GEN-10116)"

OS: Windows 7

Fix
----

Open Siebel Tools as an Administrator (right click on the Siebel Tools Shortcut and choose "Run as administrator").Import the workflow.This should work fine.

Interview Qt: Is BC necessary for an applet ?

2011-01-05T22:03:00.000-08:00

Simple but not so simple.

Answer: No, BC is not necessary for an applet.

Yeah this is possible.

Here are few quick samples to look at in Siebel Tools

Applet:About SRF Applet
Class: CSSSWEFrameAboutCDFDialog

Applet:About Siebel Applet
Class: CSSSWEFrameAboutSiebelDialog

Applet:About Record Applet
Class:CSSSWEFrameAboutDialog

Applet:Change Records Popup Applet (SWE)
Class: CSSSWEFrameChangeRecordsPopup

Applet:EAI Web Service Export Popup Applet
Class:CSSSWEFRImpExp

--------------------¤OptimusPrime¤----------------------------------

Creating Sequence Number Field

2010-12-30T01:59:00.000-08:00

1. Creating sequence number

1)In the child BC create a new sequence field that maps to an unused column & has a Data Type of DTYPE_NUMBER.

2)Define a BC user property for the Child BC as follows:

Name: Sequence Field

Value:

3)Create a new BC having name=.(Sequence) & class=CSSSequence.

4)The Sequence BC will be based on the same table as the child BC.

5)Create a new Sequence field in the Sequence BC(created above) that points to the same column as that of the Sequence field in child BC.

6)Create a second field in the Sequence BC that is FK field to the Parent BC.

7)Create a link between the Parent & Sequence BC.

8)Expose the new link in the BO that holds the Parent & Child BC.

9)Expose the Sequence field of child BC in the child applet.

Copy paste from another site .But it is helpful

thanks and regards

Joseph

By-Pass State Model

2010-12-27T23:52:00.000-08:00

Req: in our project we got one entity using state model and click on a button i want to update the status to A to B . but B is not part of the state model . in script if i tired to change it ,it will throw error saying restricted status change because B is not part of the state model .

Guys! which is the best way to achieve this .

One way is create a dummy BC for that entity and change the status in script using it .

is there any other approach

thanks and regards

Joseph thomas (Joju)

Assign To MVG has to show dynamic names in the MVG applet

2010-12-18T07:29:00.000-08:00

New requirement --New Lead create .user fills required data like type, sub type and other details . Default the person who creates the lead gonna be the primary in the assign to field . user change the assign to someother user depending on some condition [Default on left panel he can see all the user in the mvg]

Req:

eg: Lead of type 1 has to assign to user 1 and lead of type 2 has to assign to user 2 .

Current situation :sadmin creates a new lead and fill all the corresponding fields and type selected as "Type 1" . Sadmin has to assign to user 1 . sadmin click on assign to field and sadmin can able to view user 1 and user 2 in the mvg applet .

But as per our requirement i have to show only user 1 in the MVG . I dont want to show user 2 for lead type of TYPE 1 . User 2 only has to show for Lead type of type 2 .

How i can achieve this . ???

thanks and regards

Joseph thomas

Siebel 8.1.1 with IE 8

2010-12-15T00:29:00.000-08:00

Hi Guys,

i am facing some issues with Siebel 8.1.1 in IE 8 in windows 7 . we able to open the web client but the pop up,help ,pick applet, mvg etc not working . i tired couple of things still it is not working .

anyways i will post the solution once it is resolved ..

thanks and regards

Joseph thomas (Joju)

/************** Solution *********************/

Updated on 18 Dec 2010

Siebel Support for Internet Explorer 8 (IE8) [ID 796015.1]

Workaround or Resolution
Configuration The following configuration changes need to be made on the Siebel Application Server for each Siebel installation, so that it knows the capabilities of the IE8 browser. This configuration step is mandatory for all Siebel versions whenever IE8 is used in any environment, regardless of patch level:
1. Go to SiteMap (shortcut: control+shift+A)
2. Click on Adminstration > "Web Browser" > Browsers
3. Create a Browser with name : MSIE 8.0
4. For the browser add the following capabilites
o User-Agent -- Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0)
o Parent-- IE 8.0
o Accept-- image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
o JumpTab > True
5. Create another browser with name: IE 8.0.
The capabilites for this will be the same as those displayed for the IE 6.0 browser; only the version will change to 8.0
6. Reload all Siebel Application servers

Wish u all the best

Siebel Events Order

2010-12-12T23:51:00.000-08:00

Hi,

I am always got doubt in the order of the events .but i didnt find any proper doc for it . I checked in metalink , ittoolbox etc for the same .But didnt find any proper document .

Guys!!! shall we discuss it !!!

Joseph Thomas (Joju)

--- Added by ¤OptimusPrime¤ ----------
For all users, here is the order of events....

Runtime Applet.PreInvokeMethod
Browser Applet_PreInvokeMethod
Server WebApplet_PreInvokeMethod
Runtime BusComp.PreInvokeMethod
Server BusComp_PreInvokeMethod
Runtime BusComp.InvokeMethod
Server BusComp_InvokeMethod
Runtime Applet.InvokeMethod
Server WebApplet_InvokeMethod
Browser Applet_InvokeMethod

Siebel Config/Scripting/workflow Interview Questions

2010-12-09T01:16:00.000-08:00

Hi Team,

This is for the first time i am writing something to the blog. first of all i m sharing some interview questions which i collected from my friends. this is a very good start for our friends who are looking for a change . the collection includes many scenarios and start forward questions.

Note : You can also forwards interview questions to us.

*********************Set 1*********************

What is an extension table and how is it related to base table? Give an example.
What is the difference between Join and Link?
How does your b/c and view relate?
When do we go for BC level user properties
Constrainted picklist displayed value based on contraint used.
What is the difference between "PickList Generic" and "PickList Hierarchical" Business components?
What is the function of SWSE on the Web Server?
What is the use of LDAP user?
What is s_party table?
Which are the tables used by Workflow Manager to execute the workflow process?
Draw the Siebel server architecture
Draw the Siebel Layered architecture
Which type of clients access the server through Object Manager?

a) HTML Thin Client

b) Dedicated Client

c) Mobile Client

d) Windows/Java Thin Client

/*****************************Set 2**************************/

If an pickapplet is activated from an applet. Discribe how the data is fetched to the applet using the siebel architecture.
How to configure an MVG
Is BC necessary for applet
what are joins and different types of join
Position and Responsibility
How is user created
what if the user cannot login
what if he can login but cannot see anything
what is BS
can a BS be called from a Server Script or Browser Script
does the Browser script works by itself or any other setting is required
what is Repository BS and Client BS
what is the default class of Repository BS
Picklist
Search Spec
Is the BC a required field in the picklist
Hierarchial Picklist
Joins & Links
Can 2 Business Objects be linked
Can any 2 Business Components be linked
Relation between Table and BCs
Can a BC refer to only one table or more? How?
Web Services in Interface

/****************Set 3*********************/

If SR is a parent applet and Activities is the child, will deletion of SR also delete the activities associated with it. If no then what setting will ensure this.
If SR is a parent applet and Activities is the child, if a SR is closed will the related Activities become read only or not. If not, how can it be achived
If I log in and move to Accounts screen. I am able to insert, delete or merge accounts. However, you would only be able to see the account. how can this be achived
How the output returned from the BS
Working of one workflow that you are confident about
Few User Properties
How is a button configured on an applet
How is a workflow called via button
How is a BS called via button
One example where config can be used instead of scripting
How is sort specification used on an Applet, & on BC
Where are PDQs defined
How to get login Id of users using script.
Best practices of Scripting
How is a BC instantiated and Fields values retrived in Scripting
Whats the life cycle of a requirement

/***************set 4****************************/

Draw a workflow ::Depending upon account type, something should get updated.
Difference between User, Employee and Contact
Party model, Why is party model required
Assignment manager
Why is MVL required for making MVG
Is sort spec available at applet level
When should a code be written in PreWrite method and when in Write method
Sequence of Script method firing
Parent value in child applet. ie. Account-Contact view, how will you get the Account details on the Contact applet
What is code to invoke Business Service
Error handling
Standards followed while coding
What are user properties and what all have you used
Have you configured an MG
How does a class matter in defining of Business Component
Access control and have you used them
Hierarchical pick list, how to configure them
Cascade delete. Where it exists and what it is
Using button, call workflow.
Where are the PDQ defines

· Admin- Application: but only admin can access it.

· We can create Queries and save them as PDQs

Activate field
View modes
UTC Date-Time

/********************Set 5*******************/

SR detail applet and Activities list applet are there on a view. You want to display the number of activities for that SR in the SR detail applet. How? --> count(MVL)
Different ways to grant access to a view --> Personalization, Applet User Property (NoDataHide), Responsibility
How to coordinate time in a global application --> UTC Date Time - Type
drill down
Employee, Contact, User
What application is Call Center? -->Horizontal
IFB file in detail
Workflow propeties for email
S_Party structure
Runtime events(money withdrawl)
Exception handling (eScripts)
On Error Resume Next
Difference between Server scripts & browser scripts.
Profile attributes
Global Variables
If a field value is changed from 10 to 20 & control is moved to the next field without saving the record. what would be the value of BC.PreSetFieldValue & BC.SetFieldValue --> 10

Sp � l > x�[ ��Y le='mso-list:Ignore'>· Admin- Application: but only admin can access it.

· We can create Queries and save them as PDQs

Activate field
View modes
UTC Date-Time

/*****************************Set 6********************/

State model (restrict transition)

Ø Restrict the transition between states

Ø Restrict transition for login and position

If all the three Agreement items are closed then the Agreement should get closed. OR if all the Products in the Opportunity are lost then the Opportunity is also lost

http://siebelunleashed.com/closing-service-request-–-scriptless-siebel/

http://siebelunleashed.com/updating-parent-based-on-child-records/#disqus_thread

Stastatic Drilldown: Drilldown on a field in the list applet navigates to the form (detail) applet. However, the record in the form applet is different from the one on which drill down was done. (say drill down is done on 10^th record 1-12ABC on the list applet but it navigates to 1-45XYZ in the detail applet). Why?

Dril Down

Dynamic Drilldown: The drilldown navigates to a view which is not specified in any of the conditions. Why?

View wont be registered in

http://www.siebeloracle.com/error-using-drilldown-in-siebel-is-not-licensed-for-this-site-sbl-dat-00327/

Where are triggers stored?

S_ESCL_RULE

Where are workflow policies stored?

S_ESCL_RULE

How is workflow fired?

http://siebelunleashed.com/how-to-invoke-a-workflow-process/

http://it.toolbox.com/blogs/siebel-answers/different-ways-to-call-a-workflow-from-siebel-server-script-27299

How can I invoke a popup message in a workflow?

No way it will crash the system

How can I pass the popup message to other BC which is not related to the one on which the workflow is based?

Error management is scripting

In an applet, if a record is closed, then all fields in the record should become read-only but for one field. How can this be achieved.

Siebel Musings welcomes Joseph !

2010-12-09T01:12:00.000-08:00

Its my pleasure to introduce our new author Joseph Thomas.
Joseph brings along with him 3 years of hardcore experience in Siebel Configuration.
Readers can expect some dazzling posts in near future !!!

RESPONSE TO IMPOSSIBLE SIEBEL SCRIPTLESS CHALLENGE

2010-05-04T00:37:00.000-07:00

[Requirement]

Display a floating tool tip with dynamic text, when a user hovers over a form applet label or image in High Interactivity.

Complete details are over here:
Scriptless Challenge - ToolTip

Solution

One liner solution

Edit the Caption - String Override for the control .

<label style="COLOR: RED" title="Welcome to Siebel Musings © Geeksajan">Person Id</label>

THERE EXISTS .... A SIEBEL BLACK BAG

2010-04-06T22:31:00.000-07:00

A picture speaks a thousand words.

First and second are open for reader guesses. You can contact me at geeksajan@gmail.com.

Hints:
1) These are super powerful features (works both on Thick and Thin clients) that can lead us into amazing results.
2) _svf0 … pretty useful.

Third one is a POC that circumvents URL JavaScript Injection restrictions (if any exists).

v8.1 APPLY/ACTIVATE FIX

2010-03-30T22:50:00.000-07:00

For all the Siebel folks out there who are facing a problem with DB Apply/Activate in Siebel v8.1.

geeksajan provides a root cause and fix for the issue:

Root Cause Identified: It seems there is a bug in the Internal Logging mechanism of Siebel Local Setup. The logging code goes for a toss without getting to the cursor end.

Fix:
Set Env variable SIEBEL_LOG_EVENTS = 0.
If not present add it and set it to zero.
So this basically tunes off the logging and thereby the buggy logging code :)

"Credential retrieval failed"

2010-01-13T05:23:00.000-08:00

Recently I was facing an error given below while connecting to the dedicated client:

"ORA-12638: Credential retrieval failed" trying to connect to Oracle database

So what did I do next ?

Followed the Standard procedures.

1) Checking if I am connected to the wire :)
2) Checking my credentials against the DB.
3) ODBC setup is proper and working standalone.
4) Disable Hashing/Encryption

Still the problem persists.
I was able to solve the problem by changing the following parameter in
SQLNET.ora file (Network\Admin folder of Oracle Home)

# SQLNET.AUTHENTICATION_SERVICES = (NTS) --- Commented by geeksajan
SQLNET.AUTHENTICATION_SERVICES = (NONE) --- Added

Basically I made oracle ignore the Windows NT native security and use the credentials that I provided to authenticate with the DB.

Done !!!

SRFDiff: Compare two SRF's !!!

2009-12-01T06:18:00.000-08:00

Cool new feature in Siebel 8.1 (much awaited)

The SRFDiff utility allows you to compare two repository (.srf) files. Both SRFs must be from the same locale and language and compliant with the current Siebel Tools schema version. From the Help menu in Siebel Tools, choose Technical Support to view the schema version of the SRF that Siebel Tools is using.
NOTE: The SRFDiff utility validates only for a major schema version. Therefore, SRFs with different minor schema versions, such as 44.39.0.248 and 44.40.0.1, are valid schemas.
The differences between the two files, that is new, deleted, and changed objects, are recorded in two user-specified XML output files, depending on what the comparison discovers:
1)diff_srf1_srf2.xml. This output file contains differences between the two SRFs and provides a list of new and modified objects. It may also contain new objects found in srf2 that are not found in srf1. This output file shows the differences found during the comparison using an attribute name/value list format.
2)deleted_records_diff_srf1_srf2.xml. This output file contains deleted objects (objects present in srf1 but not in srf2).
If no differences are found or both SRF files are identical, then the SRFDiff utility does not generate output files.

Sample Output

1) Adding a new field in the BC

<FIELD Name="Test1" CALCULATED="N" CALCULATED_VALUE="" COLUMN="CONFLICT_ID" COMPOSITE="N" CURRENCY_CODE_FIELD="" DEST_FIELD="" DISABLE_SEARCH="N" DISABLE_SORT="N" EXCHANGE_DATE_FIELD="" FORCE_ACTIVE="N" FORCE_CASE="" HIDDEN="N" IMMEDIATE_POST_CHANGES="N" INTERNAL_PICK_APPLET="" JOIN="" LINK_SPECIFICATION="N" MESSAGE_DISPLAY_MODE="User Msg with Error Code Only" MULTI_VALUE_LINK="" MULTI_VALUED="N" NO_COPY="N" ORACLE_SEQUENCE_OBJECT="" PICKLIST="" POST_DEFAULT_VALUE="" PRE_DEFAULT_VALUE="" PRECISION="" READ_ONLY="N" REQUIRED="N" SCALE="" TEXT_LENGTH="15" TYPE="DTYPE_ID" USE_DEFAULT_SENSITIVITY="Y" VALIDATION="" VALIDATION_MESSAGE=""></FIELD>


2) New script in the BC:
New Script is not visible but there is an indicator that says a new object was added.


<BUSCOMP_SERVER_SCRIPT Name="sscfcli">
</BUSCOMP_SERVER_SCRIPT>

BROWSER SCRIPT IN SIEBEL: REVELATIONS

2009-11-12T05:35:00.000-08:00

This is just a post to let the readers know whats coming next.

We all know Siebel HI provides many soothing features to the Siebel Application.
But how safe is Browser Script?
Siebel provides very powerful Vanilla Business Services that can perform a CRUD (Create, read, update and delete) on Siebel DB thru Business Layer.

Ideal Scenario:
All Business Service's not exposed as ClientBusinessService will not be available in a browser script.
For eg: Try invoking EAI Siebel Adapter from a Browser Script.
You will get an alert: Cannot get service: EAI Siebel Adapter.

Siebel blocks the execution of Business Services not marked as a Client BS and that are not within the list of permissible ones.

Reality
You can invoke any Business Service using a Browser Script :)

Follow this space to know more revelations in this wild world of Siebel !

RUNTIME BUSINESS SERVICE MAGIC: PROOF OF CONCEPT DEMONSTRATION

2009-10-14T01:47:00.000-07:00

In the last post (SADMIN CREDENTIALS REVEALED !) we had seen the SADMIN credentials being popped out in the Output Property Set of a Runtime Business Service.

I enhanced the functionality of the script to:

a) To accept an input argument: Command.
This tells the BS which credentials the user is looking out for.
Command = APPLICATION (Displays Siebel Administrator Credentials)
Command = DB (Displays DB Table Owner Credentials)
b) The code is enhanced to display the SIEBEL credentials.

A proof of concept was performed on one of the sandboxes.
Please check out the demo (Play in SWF Format).
http://tinyurl.com/ylf5okz

Follow this space to know more revelations in this wild world of Siebel !

SADMIN CREDENTIALS REVEALED !

2009-09-29T02:31:00.000-07:00

Welcome to the wild world of Siebel !!! I got bored coding business logic and wrote a small different script. Look at what it does (Screenshot).

And what does all these mean.

Here's the explanation.

1) All credentials including those for SADMIN and SIEBEL can be easily thrown out in Siebel Output Property Set.

2) I wrote a Runtime-Business Service on thin client to achieve this functionality that can be easily plugged in and out. Also the code has been reliably tested across multiple environments and on different versions (Versions 8.0 and 8.1).

3) There are other cooler ways (zero footprint I mean !!! )

You can contact me thru twitter: (@geeksajan: http://twitter.com/geeksajan)

DISCLAIMER

There are no code or methodologies published in this posting.

This post is a security advisory and should be treated as a responsible disclosure.

SIEBEL ORACLE DRIVER: CAUGHT IN THE ACT

2009-09-11T00:19:00.000-07:00

Recently I came across a very peculiar problem in the wild world of Siebel:

There was a PDQ when fired took around 100 secs + to return the result set on the UI.
I was able to trap the killer SQL (SQL Execution Time: 98 secs)
But the same SQL fired directly on the DB took only 2 secs.

The culprit was caught red handed.

The Siebel Oracle driver sscdo90.dll (Sqlstyle : CBO) tunes off the HASH JOIN(with optimizer MODE set to FIRST_ROWS_10) for the session and then fires the query.
Since HASH JOIN is disabled, the performance of this specific query is heavily impacted.

Most popular Interview Question

2009-09-09T07:11:00.000-07:00

I am sure you might have heard this in 1st round

How will you edit the joined field values in join?

My First Post

2009-09-09T06:55:00.000-07:00

This is my first post on my blog Siebel Musings !