Category: Tips and Tricks

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…

Siebel OpenUI Enhancement: Recent Record Plugin

Its a common question asked these days.. Can Siebel OpenUI save Siebel from dying..? Well, only Innovation can save SIEBEL. And Siebel OpenUI is the tool with which we can innovate our applications and be in this dynamic world. Good news is few good people from Siebel, are doing very good stuffs with OpenUI. You need not to trust me,…

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 Integration with Facebook, Twitter and LinkedIn using Siebel OpenUI

I have posted this video on Siebel groups and I got very good response from Siebel community. So, I have decided to explain steps of integrating this plugin and make it available for all. Lets call it.. Siebel Social Integration Plugin [su_youtube url=”https://www.youtube.com/watch?v=ZzWnGZupueI” width=”540″ height=”360″] In this post, I will explain all pre-requisites for this plugin and how it works.…

All you should know about XSLT Transformation

What is XSLT? XSLT, Extensible Stylesheet Language Transformations provides the ability to transform XML data from one format to another automatically. How XSLT works? An XSLT stylesheet is used to define the transformation rules to be applied on the target XML document. XSLT stylesheet is written in XML format. Why do we need this? We need XSLT for any kind…