Web Survey Deamon Installation and Configuration Recently I got a chance to work on Siebel Marketing module and do a small poc on Web Surveys and saved its responses back to Siebel. Although its a common topic for developers who have experience in Siebel Marketing. But I find its really complex and worth sharing it with you guys.. Requirement:…
Category: Uncategorized
Siebel Administration, Siebel Configuration, Some Useful Information, Tips and Tricks, Uncategorized
Steps to Extract Local Database in Siebel & Common Issues
Encountered many issues while working on Local Database Extract on Unix environment, with this post I want to share all issues and its solution as well. Steps for DB Extract in Unix Environment: Step 1. Create User -> Employee with required fields(Position & Responsibilities) Step 2. Register user in Siebel Remote->Mobile client Step 3. Open Command Prompt and connect to server manager…
How to open BI Publisher reports inside Siebel using Symbolic Urls
Requirement: Open BI Publisher reports inside Siebel applets. [su_slider source=”media: 1249,1247″ link=”lightbox” target=”blank” width=”1420″ height=”700″ autoplay=”0″] Solution: We can achieve this using Symbolic URLs in Siebel. We have to follow below steps: Add host entry in Host Administration Configure Symbolic URL Host entry in Host Administration – Navigate to the Administration – Integration screen, then the Host Administration view.…
How to get count of all concurrent logged in Users in Siebel ?
If you want to know all agents connected to Siebel database, just run select count(*) from v$session where username not in (‘SADMIN, any other system login ids) and program = ‘siebel.exe’ And to get the list of active users in a specific timeline, The column LAST_LOGIN_TS on the table S_USER shows the last time a user logged into the…
Troubleshooting Open Cursor Issues
Troubleshooting Open Cursor Issues Similar to any application that uses Oracle Database as backend repository, Oracle Identity Manager runs several SQL statements. For every SQL statement execution in Oracle Database, certain area in the memory is allocated. Oracle PL/SQL allows you to name this area. This private SQL area is called context area or cursor. These cursors take up space…
Siebel Interview Questions: Basic User Property Questions
These are very basic questions which you must encounter some day. So, be prepared.. How to make records read only based on Users’ Responsibility ?? Create a Calculated Field with following details: Name: Val Calculated Value: IIf(InList(“Junior Sales Representatives”,GetProfileAttrAsList(“User Responsibilities”))). Inlist functions returns Y or N based on the condition evaluated in the expression. Add the above calc field to…
Siebel Interview Questions: All about Calculated Fields
How to update a calculated field in Siebel ? Calculated fields do not support updates (even simple expressions like [Field]), unless specialized business components override SqlSetFieldValue. But this answer can be proved wrong with some stupid workarounds…see the next one How to make Calculated Fields editable ? By default, calculated fields are read-only but we can make it editable. Create a…
How Can You Test Connectivity to a SMTP Mail Server?.
In case you are not able to send mails from Siebel and needs to test the connectivity of Siebel Servers to SMTP mail servers. This post will help you for sure. Obtain the IP address of the SMTP Mail Server Example: mail.askmesiebel.com Obtain the numerical IP address to confirm which host you are connecting to. From a Microsoft Windows or…
Siebel Administration, siebel upgrade to 8.1.1.11, Some Useful Information, Tips and Tricks, Uncategorized
Export Siebel schema from database server using command line
While migration, we usually requires to export the Siebel data base dump from one environment and import the same into another environment. of course, we are talking about Oracle database. Well Siebel never allowed such DB level interaction, so we have to do it using Oracle export/import utility (i.e. imp/exp or data pump utility).If you wanna go further on this,…
How to get Interactive dialog boxes in Siebel
In this post, I am sharing all the methods I know to get interactive dialogue box in Siebel. Hope this will help someone in need. Popup messsage using Vanilla Business Service Business Service: LS Pharma Signature UI Service Method Name: ShowConfirmDialog Popup messsage using Siebel Server Scripts TheApplication().RaiseErrorText(“the message”); //server script In order to pop up the message and…