Integrate third party application with Siebel/Open UI using Symbolic URL
So start our discussion with an example. Suppose we want to display market statistics (like stock price, stock analysis) of accounts in Siebel application where statistics come from third party application. Here we will use rediff.com as third party application which will give us market statistics.
Let’s say we have 3 accounts Infosys, Oracle and Yahoo. As per business requirement, we have to display market statistics of these 3 accounts.
Rediff URLs to display stock details are like below:
Infosys > http://search.rediff.com/dirsrch/default.asp?src=web&MT=infosys
Oracle > http://search.rediff.com/dirsrch/default.asp?src=web&MT=oracle
Yahoo > http://search.rediff.com/dirsrch/default.asp?src=web&MT=yahoo
For symbolic URL, it is mandatory to have one static unique URL for each account. So, lets start configuration step by step.
Step 1:
– Create a project or lock an existing project in Siebel tools. Here we have created a new project ‘Symbolic URL Test’ to keep all symbolic URL related changes in one place.
Step 2:
– Create a calculated field under Account BC to display market statistics as per account name. We have created a calculated field with below specs:
Field Name = Account Portfolio
Calculated = True
Calculated Value = “Account_Portfolio”
Step 3:
– Create a list applet (Account Portfolio Web Applet) based upon Account BC and the field
‘Account Portfolio’
– Modify the applet web template as ‘ePortal URL Applet’ in Base Read Only mode
– Don’t add any control in the applet
– Change the Class from CSSFrameList to CSSFrameListWeb
– Change the list column properties of ‘Account Portfolio’
HTML display mode = DontEncodeData
Field Retrieval Type = Symbolic URL
Step 4:
– Create view (Account Portfolio Web View) with SIS account Entry Applet and Account Portfolio List applet so that upper applet displays account details and lower applet is for market statistics from third party application rediff.com
Step 5:
– Add the view in Account Screen as details view and compile everything
Step 6:
– Go to siebel application and register the view ‘Account Portfolio Web View’ and add it with responsibility
Step 7:
– Goto Application – Integration > WI Symbolic URL and from the dropdown, select Symbolic URL
Administration
– Add symbolic URL with name Account_Portfolio, Siebel may add suffix to the Symbolic URL
– Set the value for URL as ‘http://search.rediff.com/dirsrch/default.asp?src=web&’
because next part of the URL i.e MT works as variable (like : MT = Infosys / Oracle / Wipro)
– Set SSO Disposition as IFrame
– Set the argument for MT, specify from where the argument will get value in run time
Here it looks like below:
Argument type = Field
Argument Value = Name
Append as Argument = True
So in run time, Siebel will get value from ‘Name’ field and append it to the original URL (Like http://search.rediff.com/dirsrch/default.asp?src=web&MT=infosys)
Step 8:
– Except ‘MT’ argument, we need to add few more arguments like below
src with Arg Type = Constant and value = Web
IsrecordSensitive with type = Command and value = TRUE
IFrame with type = Command and set proper Value
That’s all, now goto Account screen and check it is working as per our requirement or not.
If you have any doubt/question, please leave your comment here. To get more updates on recent activities, follow ‘TechOneStop‘ on Facebook/Twitter/LinkedIn or join our website as followers.
Watch our Youtube videos on Siebel Open UI training:
Configure Siebel Home page Using Microsite VBC
Is it difficult to configure!! To meet such requirement, we have to modify HTML script which is responsible to build user interface. In any CRM, except Siebel or Open UI, first we have to find out the HTML/CSS file which is responsible to display message on Home page, then change HTML script, test it. If anything is not in proper place, then again modify the template and test it.
Lot of work, isn’t!! Now see, how easily we can meet such requirement in Siebel or Open UI.
In Siebel, customized home page is derived from Microsite. Siebel provides specialized business component ‘ERM Microsite Section Body VBC’ to display data from Microsite. Throughout this article, we will use Partner Portal Home page to describe configuration steps. So our applet name is ‘ePortal Cat Splash Applet’ which is based upon ‘ERM Microsite Section Body VBC’ business component and view is ‘Home Page View (SCW)’.
This is two step configuration. First configure Microsite VBC in Siebel Tools and then Administration-Microsite in Siebel Client.
Step 1:
– Select the business component ‘ERM Microsite Section Body VBC’ in Siebel tools and expand
BusComp User Properties in OBLE
– Check user property ‘MicrositeSection’ is already present or not. If not, then create an user property with name ‘MicrositeSection’ and Value ‘Body’
– Compile all changes
Step 2:
– Go to Administration-Content Center > Content Sets and add new content. If you have the content file ready, then upload it by clicking on ‘Add Content’ button otherwise create new content.
– Here we will create a new content ‘eChannel Home Screen Content’, so click on New button and
give the content name and title.
Step 3:
– Below in ‘Asset’ tab, click on New to upload asset which will be displayed on home page
– If you don’t have any file to upload for home page, then just build one blank file with .DOC or
.HTML extension. We will modify it once the file is uploaded.
– Give the asset Name, title and browse the file on popup applet. File format could be anything
(example .JPG, .DOCX, .HTML), then click on ‘OK’ button to upload. There are few advanced
properties as well, like Language Code, Private, Data Length. We could leave these as it is.
– To modify the file, click on ‘Check Out’ button if it is not grayed out already and then ‘Edit HTML’. Don’t worry! no need to write any HTML script here. It will open one popup applet just like word document. We could build our custom template within few minutes. Once template is ready, save it
and do check in.
Step 4:
– Go to Administration – Microsite > Page Administration, create a new page and click on Publish
For partner portal home page, we have used below specification.
Page Title: eChannel Home Screen
View : Home Page View (SCW)
Content Set : eChannel Home Screen content
SBL-EAI-04397 / SBL-BPR-00162: No user key can be used for Integration Component
SBL-EAI-04397: No user key can be used for the Integration Component instance ‘ePortal MM Page EAI’.
SBL-BPR-00162: Error invoking service ‘Content Project’, method ‘Export’ at step ‘Publish’.
Reason:
There could be many reasons behind these two error codes. One possible reason is larger page name size in the content project. If you try to publish a content project with more than 50 characters long page name, Siebel will throw these errors.
How to solve:
Follow below steps to fix both errors
- Open Siebel application and navigate to SiteMap > Administration – Microsite > Page Administration
- Verify page name length. If it contains more than 50 characters, reduce it to 50 and publish the page.
If you have seen this error due to some other reasons, please share with us.
Do you have any question? Please feel free to comment below.
Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.
<< SBL-DBC-00105 or ORA-00904 SBL-SCB-00014 and SBL-NET-01023 >>
How to Call PL/SQL or Batch file from siebel escript
Suppose, we have to fetch Opportunities which start with Opportunity Name like ‘Test’ and write it in to a file. So our first task is to write one batch file which will have SQL statement with spooling option to fetch opportunities and next step, call batch file from siebel browser script.
Step 1:
Write all sql statements into a file, including the query “SELECT A.ROW_ID, A.NAME FROM SIEBEL.S_OPTY A WHERE A.NAME LIKE ‘Test%’; ” and save the file with .sql extension. We have saved it as opty.sql. The SELECT SQL statement will fetch all opportinities where name starts with ‘Test’ and spool it in opty.txt. Our opty.sql file looks like below.
Set heading off
Set echo off
Set feedback off
Set pagesize 0
Set inlinesize 256
Set serveroutput off
Spool “D:Runsqlopty.txt”
SELECT A.ROW_ID, A.NAME FROM SIEBEL.S_OPTY A WHERE A.NAME LIKE ‘Test%’;
Spool off
Step 2:
As we can not call SQL statement directly from Siebel script, we will put it in one batch file. So we have created one batch file opty.bat which will be used in script. Batch file should look like below:
Absolute path of Sqlplus.exe Database_UserName/Password@dbname @absolute path of the sql file
Step 3:
Now write one client side business service which will call opty.bat. Go to Administration – Business Service and create a new BS ‘Generate Report’ with method name as ‘Generate Report’.
In PreInvokeMethod, use Clib function to call the bat file.
function Service_PreInvokeMethod (MethodName, Inputs, Outputs)
{
Clib.system(“D:\Runsql\opty.bat”); //give the absolute path of the file location.
retunr (CancelOperation);
}
Now verify the bisuness service, go to Administration – Business Service > Simulator and create a record with Service name and Method name and click on Run. It will create an output file ‘opty.txt’ with opportunity details where Opportunity name starts with ‘Test’.
If you have any doubt or question, feel free to comment here. To get more updates on recent activities, follow ‘TechOneStop‘ on Facebook/Twitter/LinkedIn or join our website as followers.
Siebel Configuration Interview Questions & Answers
In Siebel interview, many companies take online test first and then face to face round. Here we have listed down few Siebel configuration interview questions and answers (multiple choice) that will help you to pass the online exam with good percentage.
Siebel Configuration Interview Questions:
1. Types of web template files, choose 3
A) List Applet Web Template
B) View Web Template
C) Screen Web Template
D) Web Page Web Template
Ans: A, B, D
2. Find out all party entities, choose 2
A) Service Request
B) Account
C) Activities
D) Position
Ans: B, D
3. Use join for, choose as per applicable
A) 1:1
B) 1:M
C) M:1
D) M:M
Ans: A, C
4. If Outer Join Flag is TRUE, join returns
A) all rows from base table, even when there is no related row in joined table
B) all rows from join table, even when there is no related row in base table
C) all rows from base table as well as join tables
D) no rows from base table as well as join tables
Ans: A
5. Person related entities in Party Business Components, choose as per applicable
A) User List
B) Partner
C) Contact
D) User
Ans: B, C, D
6. Organization related entities in Party Business Components
A) Household
B) Organization
C) A and B
D) Neither A nor B
Ans: C
7. Business Object, choose 2
A) is a collection of business components
B) provides the foundation for applets
C) keeps the relationship among BCs
D) is associated with table
Ans: A, C
8. Link is used for, choose 2
A) 1:1
B) M:1
C) 1:M
D) M:M
Ans: C, D
9. In M:M relationship, we need to populate below link properties, choose as per applicable
A. Inter table
B. Inter Parent Column
C. Inter Child Column
D. Inter Child Delete
Ans: A, B, C, D
10. Below statements are true about Cascade Delete Property, choose 2
A) It determines how child records will be deleted when parent record is deleted
B) It is part of business component object definition
C) Values would be one among three: Delete, Clear, None
D) Use this property for 1:1 and 1:M relationship.
Ans: A, C
11. Types of Applications, choose as per applicable
A. Customer
B. Partner
C. Web
D. Employee
Ans: A, B, D
12. One List Applet could be based on ___ Business Component
A. More than One
B. One or Many
C. None
D. One and only one
Ans: D
13. Siebel Gateway Name Server uses ___ file to get details about component groups and components definitions
A. eapps.cfg
B. uagent.cfg
C. siebns.dat
D. All of the above
Ans: C
14. Which statement/s about views and responsibilities is/are true?
A. One view could be associated with one and only one responsibility
B. Users see the union of all views from all of their responsibilities
C. Data control is possible using proper responsibilities
D. All of the above
Ans: B
15. What are all access control mechanisms for controlling customer data, choose as per applicable
A. Access based on user id
B. Access based on responsibilities
C. Access based on catalog
D. Access based on user position
E. Access based on user organization
Ans: A, D, E
16. _____ table is used to store object definitions for Siebel applications.
A. Data
B. Interface
C. Repository
D. System
Ans: C
17. “Every object definition could be associated with one and only one project”. Is the statement true?
A. Yes
B. No
Ans: A
18. How do you choose the best view web template when building a new view using wizard?
A) When the wizard asks for the view template, scroll through the list and check each template’s layout in the preview window until you find a perfect one
B) The view wizard will automatically select the best template based on applet/s that you select to display in the view
C) Before starting the wizard, find an existing view that has the desired applet layout and check the view template object definition to determine the template being used
D) Always use the view default web template
Ans: C
19. What is View Web Template Item?
A) View object definition
B) Applets that have been bound to a view
C) Controls that have been bound to an applet
D) All of the above.
Ans: B
20. To bring party data into non-party business component, the join specification destination column should refer
A) ROW_ID
B) PAR_ROW_ID
C) ROW_ID of Party BC
D) Id
Ans: B
21. Which statements are true about customer data, choose two
A. Includes dynamic, transactional data
B. Is created and managed by company administrators
C. Can be grouped into catalog and category
D. Has access controlled at the record level
Ans: A, D
22. How can you assign access groups to child categories, choose two
A) Manually enter access groups for each child category
B) Right-click on the parent access group and select ‘Make Child’ to create a child with same properties
C) Click on the propagate button to assign the parent access groups to all child categories
D) Click on ‘Cascade’ button to assign the parent access groups to all child categories
Ans: A, D
23. If there is always a related row in a join table, should you set the ‘Outer Join Flag’ to ‘TRUE’?
A) Yes, it is necessary in order to pull data form join tables
B) Yes, it will improve performance
C) No, it will cause a conflict and join would not work properly
D) No, it is not necessary and will have a negative performance impact
Ans: D
24. ‘All View’ displays all records – view is, choose one
A) Directly assigned to user
B) Associated with the user’s organization
C) From all organizations
D) From the organization and its subordinate organization
Ans: B
25. S_PARTY_PER stores relations for, choose 3
A. Employee & Position
B. Account & Contact
C. Access Group & Members
D. Person & Employee
Ans: A, B, C
26. If you lock a project locally in Siebel Tools, what all statements are NOT TRUE, choose 2
A. You can not check-in your changes to the server
B. You can check-in your changes to the server
C. You can use Tools > Unlock to unlock a project
D. You can not undo your changes
Ans: B, D
27. Suppose in Contact List Applet, there are 20 records without any MVG and in Contact Form Applet, there are 4 MVGs without primary. How many queries Siebel will fire to display all 20 records on Contact screen?
A. 1
B. 24
C. 5
D. 20
Ans: C
28. You don’t need to compile below objects in a SRF file, choose 3
A. Workflow
B. Project
C. Access Group
D. Task
E. Integration Object
Ans: A, C, D
29. Steps to configure a list applet, choose 3
A. Create a new applet object definition
B. Associate applet template with applet object definition
C. Bind controls and list columns to the template
D. Add the applet to the screen
Ans: A, B, C
30. What all statements are correct about Detail Category, choose 2
A. Detail Category appears in the link bar or visibility filter dropdown list
B. It may belong to an aggregate category
C. It groups detailed views
D. It does not contain any view
Ans: C, D
31. Difference between an organization and a division
A. Organization can do data access control but not division
B. Siebel developers can delete an organization from UI but not division
C. Siebel developers can delete a division from UI but not organization
D. Positions are assigned to organizations, not divisions
Ans: A
32. What statements are true about ‘Flat Tab’ in Object Explorer, choose as per applicable
A. It removes parent child relationship between two objects
B. It helps developers to find out child object with unknown parent
C. In ‘Flat Tab’, developers can expand top level object to see all child objects
Ans: A, B
33. What all products can you install using Siebel Enterprise Server Installer, choose as per applicable
A. Siebel Server
B. Siebel Gateway Name server
C. Siebel Tools
D. Siebel Web Client
E. Siebel Web server Extension
F. Sample Database
G. Database Configuration Utility
Ans: A, B, G
34. Suppose for Service Request BC, ‘Search Specification’ property value is ‘Status = Open’ and for Service Request List Applet, ‘Search Specification’ property value is ‘Status = Closed’. How records will be displayed in Service Request List Applet?
A. Users will see all service request records where status is open or closed
B. Users will not see any record in the applet
C. Users will see only those SR records where status is open
D. Users will see only those SR records where status is closed
Ans: B
35. Siebel File System contains, choose 3
A. Products
B. Contacts
C. Accounts
D. Solutions
E. Literature
Ans: A, D, E
Hope you have learnt something new from our Siebel configuration interview questions & answers.
If you have any question or want to give us feedback on Siebel configuration interview questions, please feel free to comment below.
Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.