Siebel Development

Date difference - Goovy

2016-05-18T18:22:00.001+05:30

Directly subtract date fields. Bookingdate_c - today() > 0

Oracle Sales Cloud - Groovy

2016-05-18T07:04:00.001+05:30

1. Use getPrimaryRowState().isNew() instead of getPrimaryRowState().isNew()==true

2. Don’t use variable to do get and then set , Instead use setAttribute('AccountName_c',nvl(var_record.getAttribute('AccountName_c'),''))

3. Use PartyId or RecordId instead of other fields for search when searching across objects

4. Set Dynamic Choice list field using Id instead of directly setting field

5. Where there is direct Read only not based on any condition we should use Page Composer instead of 1==2

6. Always make sure that code in BeforeUpdate is conditional. It should not get trigger everytime update is happening

Oracle Sale Cloud - Goovy Syntax

2016-05-16T11:09:00.004+05:30

Following are some syntax of groovy used in OSC- Oracle Sales Cloud while doing scripting.

1. setAttribute('FieldName_c',var) - Set a Field value of Object

2. getOriginalAttributeValue("Priority_c") - This syntax is to get Original value of Field commonly useful for Audit requirements.

3. def var=getAttribute('Field1_c') - To get value of a field.

4. PreferredDistributor_Obj_c?.Country - To get value of Country of a object

5. getEstimatedRowCount() - To get number of records.

6. def user = adf.context.getSecurityContext()?.getUserProfile()?.getUserID(); - To get Login user detail.

7. def sNewOpty = adf.userSession.userData.NewOpty - To get Session Attribute

8. def Role = getSelectedListDisplayValue('Role_c'); - Returns Display value of LOV

9. def PartnerId = adf.util.getUserPartnerCompanyId(); - Partner detail

10. throw new oracle.jbo.ValidationException('Budget field is required.') - throws error message

Oracle Sales Cloud

2016-05-16T10:56:00.002+05:30

Started working on Oracle Sales Cloud, A cloud based application for Sales. It is very light application with less features. May be in next versions Oracle will come up with more features.

Siebel OpenUI Mobile & Barcode Reader

2014-04-21T07:51:00.002+05:30

Recently, I worked to integrate siebel openui mobile application to read Barcode through camera & populate part fields. User would be able to read Barcode from camera and part pick applet should be populated automatically.

Siebel Grant users in Loacl Database without extracting Db for all users

2013-10-04T12:06:00.004+05:30

1.Connect your locala database with SQL utility with Siebel User/Password

2. Run below SQL Script.

grant connect to SSE_ROLE

grant connect to identified by

grant group to SSE_ROLE

grant membership in group SSE_ROLE to

Siebel Open UI: SR raised 1 month ago, 22 days ago...

2013-10-03T15:54:00.003+05:30

Siebel OpenUI _ Mobile

2013-10-03T15:44:00.003+05:30

Siebel OpenUI - showing Weather without popup window by using opacity...

2013-08-15T18:05:00.001+05:30

Siebel OpenUI Carousel View - Contact

2013-07-31T21:26:00.001+05:30

Siebel Open UI - 5 (Chart display)

2013-07-18T23:38:00.001+05:30

Opportunity details on account name hover.
Chart Presentation:

Conatct Me for any help.

Siebel OpenUI 4 (without Popup window)

2013-07-18T23:23:00.002+05:30

Google Map integration without Popup window.

Conatct Me for any help.

Siebel OpenUI -3

2013-07-18T23:18:00.004+05:30

Color Coding at Record level.

Conatct Me for any help.

Siebel OpenUI -2

2013-07-18T23:12:00.002+05:30

Linked In Integration On MouseHover through popup window.
Danish

Conatct Me for any help.

Siebel Open UI - Grid Layout For Tablet

2013-07-18T22:15:00.000+05:30

Imlemented for Tablet.
Danish

Conatct Me for any help.

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

2013-01-30T15:05:00.002+05:30

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"

Creates Siebel Technical Design Doc in Seconds...!!!

2012-03-04T13:11:00.001+05:30

Connects with Local Data Base, If you want Technical Design Doc in MS-World then copy Tables from Excel Sheet to MS-World Manually.

DownLoad

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

2011-11-16T17:48:00.001+05:30

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

2011-11-06T14:28:00.003+05:30

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)

2011-11-06T13:53:00.003+05:30

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

2011-09-02T16:10:00.001+05:30

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

2011-05-06T10:01:00.005+05:30

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

2011-05-06T09:55:00.002+05:30

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

2010-09-28T13:12:00.002+05:30

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)

2010-09-28T13:08:00.002+05:30

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