SBL-DAT-00359: The value '%1' cannot be converted to a date time value.

SBL-DAT-00359: The value '%1' cannot be converted to a date time value.

Some time when we do query in siebel on Date field  of applet with following value (Including Time)

> "1/24/2012 11:00 AM" AND < "1/25/2012 11:00 AM"

We get the SBL-DAT-00359 Error. Work Around is, use following format Hour:Minute:Second

> "1/24/2012 12:00:00 AM" AND < "1/25/2012 12:00:00 AM"

Siebel: Unable to reduce the height of the labels after certain limit in a form applet.

Delete Siebel Preference File(.spf) in web client bin folder. Allow you to reduce the height. A new .spf file will be created again.
                   e.g. "SADMIN&Siebel Call Center.spf"
         

Siebel : Calculate 18 years age Flag including leap years

Ways to calculate 18 years age Flag including leap years:

1. Create Calculated Field of todays date in YYYYMMDD Format:
e.g: Formatted Today Date : ToChar(Today(),'YYYY') + ToChar(Today(),'MM') + ToChar(Today(), 'DD')
       Field Type: DTYPE_NUMBER

2. Create another Calculated Field Birth date in YYYYMMDD Format:
e.g: Formatted Birth Date : ToChar([Birth Date], 'YYYY') + ToChar([Birth Date], 'MM') + ToChar([Birth Date], 'DD')
       Field Type: DTYPE_NUMBER

3. Set the Calculated Age Under 18 Flag as mentioned below:
        Age Under 18 Flg : IIf(([Formatted Today Date] - [Formatted Birth Date]) < "180000", "Y", "N")
        Field Type: DTYPE_TEXT

Siebel Hierarchical Pick list by using List Of Values Dynamic (REL)

1.Create Pick List for Field1

Name: Pick List Field1 Demo
BusComp: PickList Generic
Type Value: FIELD1_DEMO

2. Create Pick List for Field2

Name: Pick List Field2 Demo
BusComp: List Of Values Dynamic (REL)

"List Of Values Dynamic (REL)" business component has fields named "Parent Value" and "Parent Type".

Search Specification: [Parent Type] = ' FIELD1_DEMO'
Type Value: FIELD2_DEMO



3. Configure Siebel FIELD1 on  business component


Name: FIELD1
Immediate Post Change: TRUE
This property needs to be set to TRUE for parent field.
Picklist: Pick List Field1 Demo
PickMap:

Field: Field1
Picklist Field: Value


Field: Field2
PickList Field: NULL (leave this field as blank).

(This pick map is configured to set the  Field2 to NULL Field1 is changed)



4. Configure Field2 on business component


Name: Field2
Picklist: Pick List Field2 Demo
PickMap:

Field: Field1
Constrain: TRUE
This property is set to constrain Filed2 by Field1.
Picklist Field: Parent Value

Field: Field2
Picklist Field: Value



5. Compile the changes


6. Set up the Parent/Child List of Value (LOV) relationship between field1 and field2 at the client level. Without setting the Parent/Child relationship properly, the hierarchical Pick List does not work as expected. Please refer above image.

OPA - Oracle Policy Automation / Siebel

Step to create OPA/Siebel Project :

Assumption : OPA determination server, Siebel server & Siebel Connector installation is already done with all seed data. Currently OPA 10.2 version is for siebel.

Steps :
1. Create mapping in Siebel
2. Export Siebel Mapping
3. Create project in OPA
4. Import Siebel Mapping in OPA-Project
5. Create Rules in DOC/EXCEL
6. Build
7. Test it on integrated Oracle web Determination
8. Deploy it on Production Server(Tomcat/Weblogic Server)
9. Create port in siebel (Outbound Web Service)

10. Test

RunTime Event & WorkFlow

Recently, I came across a situation where I need to call a WF on some BC fields value conditions, I prefer Workflow policies for Siebel Integration only, not always for Config. Hence, I would have only two options Scripting or Runtime.BC has already a lot of scripting and no place remains for new script.

Condition Sub-Status = "Dis Approved" + ... on SR BC.

So, I implemented this by using RunTime Events. If you have to call a WF from Runtime Event do't go for Administration -> RunTime, Use WF process events and use conditions inside WF process. Attached image is property window of start branch of WF. This process will be called at PreWriteRecord of SR.

Siebel automatically creates record in Admin->Runtime with Row_id of WF. And don't forget to click Reload runtime from Administration -> RunTime.

Boolean Values in Siebel Expressions

In Siebel expressions,

Bool has three values NULL, Y & N. Hence, If you are using bool in any expression, make sure you are taking care all three values."Y" & "N' does not work every time.

Publish Post

Current Record Refresh

Current Record Refresh

Sometime we do some scripting and update current record but updated value does not reflect immediate, we need to do again query and go.

We can solve this issue by using following scrip at the end.

TheApplication().GetService("FINS Teller UI Navigation").InvokeMethod("RefreshCurrentApplet",TheApplication().NewPropertySet(), TheApplication().NewPropertySet());

The SRF file specified is not compatible with this version of the application.(SBL-DAT-00145)

The SRF file specified is not compatible with this version of the application.(SBL-DAT-00145)

Application version and tool version should be in sync. This issue comes when we do incremental compilation and tool version is different then client.

check version

C:\Program Files\Siebel\8.0\web client\UPGRADE\base.txt

C:\Program Files\Siebel\8.0\tool\UPGRADE\base.txt

Siebel Tool : unable to load dictionary

Disable Antivirus and try again.

Siebel Remote Flow/ Details

Siebel Remote Flow/ Details

Hi,

Following Oracle links are very useful to understand Siebel remote flow , that describes all used processes as well.

Master Transaction Log
Transaction Processor
Transaction Router
Inbox / Outbox
DX files (.dx)
TOC files (.toc)
Remote clients process transactions in their local database
synchronization process
Transaction Merger


Siebel Remote data flow Digrame / Siebel Remote processes details

Remote up flow diagram

Remote Downflow Diagram

You can not continue to work on this page because the state of this page can not be restored on server

if you create a new record in Siebel eService, populat newly record and saved, Moved to next page.

Now you want to do some update on newly created record, you might come back by Using BACK Button of browser. The moment you will click Back button, you will find following error message.



I have implemented and fixed this by two ways.

1.By using cookies(javaScript) : You can set cookies the way that the moment it goes to defaulter page it should redirect to some other page.

2.Delete History : After saving newly created record, user will go to next page, the moment user click Next Page, bu Using delete History u can delete defaulter page from cache.

Thanks

The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)

While working with eService-Standard Interactivity,

User needs to populate all detail on one page then needs to proceed next page .(eg: On first Page populates Contact Details, Next Page Populates Income Details.)

if user wants to come back on previous page(eg: contact) then he can use BACK button of browser.

But when he does some changes on previous page (eg: on Contact) and click save button, a error message prompts as follow,

The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)

Solution :

What I did , Goto browser script of applet, Write following script

function Edit__0__Control__WriteRecord__onclick (applet, id)
{
Top().SWECount = Top().SWEServerCount;
}

SWECount is page count & SWEServerCount is server request count.

Thanks

Profile Attribute

Profile Attribute :

You can find out value of any profile attribute by just using following code in URL of Siebel Application.

javascript: alert(theApplication().GetProfileAttr("Is Anonymous"));


Danish

Siebel Audit Trail : Basics

Audit Trail :

1. Can keep tracks of Read,Update,Delete,new and export on BC.
2. Internally it uses "Audit Trail Engine" BS. Hence BS user property : Enable should be TRUE.
3. Audit trail works on BC having class "CSSBCBase" or inharited by this class.

Enabling Audit Trail :

EnableAuditing system preference should be TRUE.
EnablEimAuditing system preference to TRUE for EIM purposes.

Create a new record in Administrator -> Audit Trail
Significant of property are as follow :

1. Assoc : Specify parent Child relationship Audit

2. Delete : Audit for Deletion.

3. End Date : end date for audition.

4. New : Audit for new operation

5. Restriction Type :Specify condition that determine which should be audited.

6.Update : Audit for update operation.

7.Export : Audit for Export Operation.

Create a record in Field on child Applet, that has to be audited.

1.Read Field Value : Field that you want to store at the time of record reading.
2.Reading : check if you want to audit read operation.

Table Apply Activate issue in Siebel Tool

Table Apply Activation Issue in Siebel Tool :

Some time when we do Table Apply Activate, Siebel tool hangs and required restart.
Few times, It hangs each and every time.

So you can use following approach to avoid it.

1. Do spool and check which column(Column_Name) is not present in underline database.

2. Find out table(Table_Name).

3. Simply run following sql statement with DBO privilege.
Alter Table Siebel.Table_Name
Add Column_Name DATA_TYPE

Data_Type could be Varchar, Date etc. Take data_type as per requirement.
It works fine.
As per my understanding above is good approach to avoid siebel hang on Table Apply.

Your feed back would be appreciable.

Adding Custom View to Vanilla Responsibility

Currently, I came across a requirement, where I needed to add a custom View in Vanilla Responsibility.
It is not possible through UI. Vanilla Responsibility never allows to add any custom views.

But you can add custom view in Vanilla responsibility by using following parameter(/editseeddata) in command line, As;

/U Username /P Password /s c:\spool.txt /editseeddata

Siebel thick Client URL Issue - FQDN

Siebel thick Client URL Issue:

Whenever, we open siebel thick client(local) it takes URL automatically as

http://(machine name)/start.swe

but when we move from local network to Client network by using VPN or whenever we change port or IP. Siebel thick client disconnected and we get message 'Page not found' and need to restart thick client again.This can be avoided by using following two parameters of cfg file under section [Siebel]

EnableFQDN = TRUE
FQDN = localhost

Command Line for Siebel Application

Command Line Parameter for Siebel Application.

/c : Configuration file

/h : Debugger mode

/d : Default database.

/s : Spool

/u : UserId

/p : Password

Note: For Spooling in WF simulator process, Need to pass /s before /h in debug arguments in Siebel tool.

Siebel Client / Tool / system Performance

Siebel Client / Tool / System Performance

Siebel Tool and Client should run smoothly otherwise it irritates a lot on work.
As per my understanding, Apart from my previous post, For improving performance of Siebel Tool / Client And System, you need to regularly delete all *.log ,*.txt and *.dmp and spool.txt of Siebel Log directory on your local.

Also delete all temporary files of your local system, That resides in TEMP Folder.You can check your temp file directory.
Go to Run and Type %TEMP%
Delete all file of this dir, but don't delete structure. Means don't delete any folder only files should be deleted.You can use Dos CMD for same.
I have written following bat file that regularly delete all temp file as well as all siebel logs after a time interval.

log.bat

REM*****************************

REM Delete Log and temp file

REM*******************************

cls

cd C:\Program Files\Siebel\8.0\web client\LOG

del /F *.txt

del /F *.log

del /F *.dmp

cd\

cd C:\Program Files\Siebel\8.0\Tools\LOG

del /F *.log

del /F *.dmp

cd\

DEL /F /S /Q %TEMP%

On Production Server,You can use environment variable SIEBEL_LOG_ARCHIVES = 3, It will keep only recent 3 copy of a log and will delete old.

You can use window scheduler to schedule this after a regular time interval(Like reboot).