Siebel - Pick Applet /Dynamic Pick List
1.
Project OT
RCNR (Right Click New Record) on RHS.
Name
First
2.
Locked
Business Component OT RCNR
Name
Proj Name
F Service Request BC
First
(+)
Table
S_SRV_ REQ
Field OT RCNR
Name
Column Name
Service No
Summary
Satus
A/c In Ser Req CST_OU_ID (FK in F Service Request BC)
(+)
Join OT RCNR
Table
S_ORG_EXT
(-)
Alias
S_ORG_EXT (auto populated)
Outer Join Flag
Join Specification OT
1
Destination Column
ROW_ID
Name
Con Acc
2
Source Field
A/c In Ser Req
Once Again go back to Fields OT RCNR ( now add columns from joined table)
(+)
Field OT RCNR
3
Join
S_ORG_EXT
S_ORG_EXT
Name
Account Name
Account Site
3.
Business Object OT RCNR
Name
F Service Request BO
(+)
Proj Name
First
Bus Comp Object RCNR
BusComp Name
Link
Column Name
Name
LOC
F Service Request BC
4.
Applet OT RCNR
Name
F Ser Req List Applet
(+)
Proj Name
First
BusComp
F Service Request BC
List RCNR (Right Click New Record)
(+) List Column RCNR
Field Name
Last Name
First Name
Account Name
Account Site
Proj Name
First
First
First
First
Name
L Name
F Name
Name
Location
Display Name
Last Name
First Name
Account
Location
Go to the Applet F Ser Req List Applet RC Edit Web Layout.
Click Yes.
5.
View OT RCNR
Name
Proj Name
F Service Request View
First
Bus.Obj
F Service Request BO
RC Edit Web Layout Select Applet Select Template eg: View Detail
6.
Screen OT RCNR
Name
F Service Request Screen
(+)
Proj Name
First
View Bar Text Menu Bar Text
Sonata Ser Req Sonata Ser Req
Screen View RCNR
View Name
Add the View name created in step 5 (F Service Request View)
7.
Application OT RCNR
Name
Sonata Application
(+)
Page Tab OT RCNR
Project Name
First
(add 5 more properties with values)
Screen Name
F Service Request Screen
(+)
Text
Sonata Account1
Screen Menu OT RCNR
Screen Name
F Service Request Screen
Text
Sonata Account1
At this point we need to compile the Project we have created, in order to make an .srf file.
Criteria for Creating a Join :
1. Join is created between a Business Component and a Table, other than Base table
of the BC.
2. Relation Between the BC and Table should be 1: 1
3. In Join Specification ,
1. Destinations Column is always pre-filled with ROW_ID of the Joined table
(in this example row_id of s_org_ext ) for all Non- Party BCs
2. Source field is a field from the Current Business Component, we need find out
what is the foreign key column, which corresponds to the row_id of s_org_ext.
3. Alias : Its Alias is what we use when adding Fields from BC not the Join
Name
How to Find out which Column should be map to Source field from BC.
Steps:
Go to Table OT, Query for S_OPTY table, if that table is present,
Go to the Column OT, query in on one Column Foreign key Table (eg: s_org_ext)
If there are any foreign key fields from s_org_ext, it will throw, u need to select
the appropriate Column name by looking at Comments column.
Work to be Done In Application :
Go to site map ,
i. In Application Administration Views RCNR
Add the exact View Name (created in Step 5) in tools
ii. In Application Administration Responsibility RCNR
Add a new Responsibility in the below Views Applet Search for the new View we
have added and associate it and in the Users Applet assign the Responsibility to the User
u want to see that view.
Note: 1.All the changes done in tools are called srf changes.
2. In order to make the screen visible, we need to perform certain tasks at
Application (Call center or sales etc., ) level too these are called Non srf changes.
Path for .cfg files c:\sea752\client\bin\enu
Path for .srf files c:\sea752\client\objects
Pre Requisites for Running a Siebel Application:
1. Copy Siebel Executable from C:\Sea752\client\Bin on to Desktop. RC give
the .cfg path u want to invoke
2. Copy srf file and paste and rename it to Sonata.srf
3. Copy Uagent.cfg and paste and rename it to Sonata.cfg (changes to be done are)
a. Siebel Repository File: Sonata.srf
b. Application Name
: Sonata Application -- same Name as Step - 7
c. Database
: Sample
