Tuesday, December 9, 2014

Cross-Browser Testing

With more power comes more responsibility. If you are browser aficionado and have heard of "BrowserStack" this post is not for you. If you are working with Open UI and have enabled siebel to open on multiple platforms including mobile versions, then it becomes inherent responsibiltiy to test the same on multiple browser and versions. In real world it is tough to install multiple browsers and test your application.

Recently while upgrading our browsers and eservice applications we encountered same scenario and came across tool named as "BrowserStack". BrowserStack is a cross-browser testing tool, to test public websites and protected servers, on a cloud infrastructure of desktop and mobile browsers. Websites can be tested interactively, or through the use of Selenium or JavaScript automated test suites. It is superb suite which provides  real browsers,Local Testing, Screenshots, Responsive, developer tools and APIs for integration. It can be boon for developers as well as QA team. 

If you haven't stumbled across this make sure you visit this site once.  Every click is worth it. 

Happy testing!!

Saturday, November 15, 2014

BI Publisher and OBIEE Dashboards

The most complicated skill is to be simple.

There are multiple ways to invoke BIP reports in siebel. You can go for Symbolic URLs or Browser scripts or if reports are IO based, standard menu based invocation is the option. However one more interesting way is to invoke BIP reports from OBIEE dashboards. Usually OBIEE dashboards are configured in the system to display analytical reports. If you want to blend your BIP reports into the dashboards, it can be easily done in one click. The advantage here is you don't have to touch siebel environment for anything. Build your BIP report and pull it in the existing dashboard in OBIEE.


The only catch here is if your BIP report is parameter based and if you use BI Publisher section in your dashboard page, you will loose your parameters. Parameter section doesn't come in the BIP reports displayed in OBIEE dasboard. As an alternate you have to use "Embedded Content" section in your dashboard page and need to use link of the BIP report With "No Header" option. Specify height and width of the pane and you are ready to go.  As simple as it can be.

Happy Reporting!!

Thursday, October 9, 2014

Input Parameter Validation in BIP

BI publisher is really simple-easy-to-use tool but with its own limitations. One of which is validation of the input parameter befor report execution. Yeah you might fire back stating we do have LOV concept there but what about Email and Phone formatting.

Keep all your worries at bay as there is always an alternate solution. We can't validate the parameters while keying but we can validate the same in the template. That's how much powerful BIP is. BI Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is

<?xdofx:expression?> for extended SQL functions

<?xdoxslt:expression?> for extended XSL functions

The key here is syntax. You might struggle in the begining if you are new to this part of world. However there are certain functions (read Instr as one) which are supported by xdof while some are supported by xdoxslt. Keep in mind you cannot mix xdofx statements with XSL expressions in the same context. Consider a simple scenario of validating email address parameter in template, whether it have '@' symbol or not. The syntax can be real tricky if you are using the same with conditional region in rtf. Below steps can be used to perform the same.

1 - Define input parameter in rtf template

<?param@begin:Email;u_rock@gmail.com?>

2- Define xdofx condition which checks for @ in the parameter. This will use extension function for the same.

<?xdofx:if Instr($Email,'@',1) <= 1?>

Invalid Email Address

<end if>

<?xdofx:if Instr($Email,'@',1) > 1?>

Your Report Data

<end if>


With the help of extension functions you can define your own conditional region and conditional formatting.  Do share your experience with the extension functions as the syntax can be quite tricky at times for these functions. In my next post i will try to take a dig on xdoxslt function for validation.

Happy Reporting!!

Thursday, September 18, 2014

Blogger Blog to Custom Domain

This has been interesting week for this tech blog! I finally moved it from blogspot subdomain to a custom domain. I have been wanting to do this since a long time (ever since this blog started getting some attention) , I somehow couldn't manage to do so but finally it has happened and feeling is as good as moving from rented apartment to owning your own villa. 

Thanks to all fellow readers and bloggers. You have been inspirational.

Thanks!!


Wednesday, September 17, 2014

The State of Siebel 2014 - Webinar 23/09/14

Renowned speaker and chief editor of the Siebel Observer, Mr Bruce Daley, will present a webinar on the State of Siebel 2014 on September 23rd 2014 at 11:00 AM EST.

Building on last year's successful State of Siebel address, this year's presentation helps Siebel customers and partners determine what different directions they can take their implementation and their careers in the light of Siebel Open UI. Is a Siebel Renaissance really taking place? Find out where you really stand in your career.

Register now before clock ticks over.

You wouldn't want to miss this for anything.

Tuesday, August 26, 2014

NOTE Datatype in OBIEE 10g


As entire world is ready to embrace Iphone 6, i am still stuck with Iphone 3s and as fate would have it OBIEE 10g. For those who have moved on with OBIEE upgrade there will be new challenges but currently we were hand-tied-in-hole sort of issue. It was not known fact to me that OBIEE 10g doesn't support columns with data type NOTE from siebel. So when we decided to import S_NOTE_SR table in OBIEE rpd we were in for surprise when dashboad reports bombed where we had to display NOTE column. NOTE column came perfectly into OBIEE rpd with type LONGVARCHAR and size as 32768 characters but when it was used in queries it was failing with error as below:

"State: HY000. Code: 25. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1722, message: ORA-01722: at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000"

Friends at Oracle were not kind in reponse when they told LONG datatype is not supported in OBIEE 10g. To do overnight upgrade was bigger challenge then problem at hand. Another option was to convert NOTE column into VarChar Column and bring it into OBIEE repository. Then friend-colleague-DBA-
Mastermind, Mr Shuaib, came to rescue when he was able to write function which converted NOTE datatype in VarChar and we created database View in SIEBEL schema to store curtailed-Notes.

Function: 
create or replace function f_long2Char (r rowid) return varchar2 is
  v varchar2(4000);
begin
    SELECT NOTE INTO V FROM SIEBEL.S_NOTE_SR WHERE ROWID=R;
      return substr(v,1,4000);
END;

View:
CREATE OR REPLACE VIEW VNOTE AS
SELECT ROW_ID, SRC_ROW_ID, f_long2Char(ROWID) AS NEWNOTE FROM SIEBEL.S_NOTE_SR;

Once db view was created things become simple. We were able to import this view into OBIEE rpd and reports started working like charm. However the catch here is in our case we knew the maximum length of data going into LONG column is upto 4000 characters. I might get Iphone 6 soon and upgrade sooner but if you are on OBIEE 10g and facing such issue. This might just help you.  Sometimes big is not that beautiful.

Happy Reporting!!

Monday, June 16, 2014

Error in Contact Recipient Group

Recently we stumbled upon strange issue of mutiple emails going to same contact record. To make matter worse it was not happening for all contact records. On further investigation we found if you set primary suspect id in multiple Case records for same contact record you will get this behavior. Multiple emails will go to the same Contact id. This issue is also reproducible in OOB Siebel Public Sector flavor. One can always use "Administration - Communications -> Outbound Request Overview" to verify this.

As devil lies in details and issue lies in SQL. On enabling all the logging parameter of Outbound Communication Manager, we found the join between S_CONTACT and S_CASE was causing this issue. The query was returning more than one record per Contact recipient Id. On Disabling the Join with Alias Name, Case Primary Contact in Contact BC, it worked perfectly.

We have raised SR with Oracle and same has been made as public Knowledge item by good guys at Oracle. Below is the link for same. Hope it helps many.

Multiple Emails Are Going When Using Outbound Communication Manager Business Service (Doc ID 1672680.1).

Happy Configuration!!

Wednesday, May 21, 2014

Escaping Characters in SOAP UI

It is very important and tricky to escape special characters whatever you are doing. In Siebel eScripts we do this escaping by using "\" . Same holds true while invoking any request from SOAP UI. Recently we hit an issue with one of our webservices as it was working fine for all accounts data but failed for couple of records.

While invoking the request from SOAP UI, we were getting response as "Supplied input in not well formed". Closer look of input exposed usage of '&' was giving the error. Yes you thought it right we need to escape special characters in request message.



Characters like "<",">","&" are criminals in XML.Once escaping is done the result was as expected. If you need to pass heavy duty XML message as request then the only gotcha is explicit CDATA sections where the special meaning doesn't hold.


So better Know Escaping else No Escaping.

Tuesday, March 18, 2014

Project and Resource Management in Siebel

Every now and then Siebel mesmerizes with its power and flexibility. Recently while doing an implementation, we stumbled upon where to do project/resource management activities as there was no major tool in place except good-old-excel. Siebel as good it is, comes with wonderful solution in form of Project and Resource Management module. It is power packed with options for creating Projects, Individual Tasks, Project Team and workbook, Timesheet module to keep track of each task/resource and many many more features.

Mother of all siebel documents (Bookshelf) suggests this module was designed in consultation with leading professional services organizations specifically to meet the needs of consulting and service organizations. It is built in such a way that it can compete and beat any current Resource management tool available in market. If you are implementing Siebel and your client doesn't have good resource management tool don't miss out to demonstrate this module of Siebel.

The path to Project Summary view is something you can learn a trick or so.


PS: Do check your Siebel flavors before proposing the solution.

Happy Crunching!!

Tuesday, January 28, 2014

Game,Set, Match - Siebel

The battle for supremacy in CRM space is just getting more intense. Open UI has come up to rescue Siebel in arena where they were dislodged by a weak team.  Here is the Fortune article that takes a dig at history, what went wrong for the giant and how new bee scored.

A member of the founding executive team, Bruce Cleveland had a ringside seat for one of the seminal technology industry battles of the last decade - Siebel Systems vs. Salesforce.com. He shares his perspective and lessons learned and on what went right and what went wrong for the company.

Not too long ago, I was asked to speak to a class of MBA students at INSEAD. Before I began my presentation, I asked the students how many were familiar with Siebel Systems, where I had spent 10 years as one of the members of the founding senior executive team.
Only about a third of the class raised their hands. Seven years had passed since Oracle acquired Siebel, which created the customer relationship management (CRM) business, now dominated by Salesforce (CRM). I was the head of Siebel's products division when it was acquired by Oracle (ORCL) in 2006.
Six months after Siebel was acquired by Oracle, I joined InterWest Partners as an investor. And, since that time, dozens of entrepreneurs have passed through our offices to present their new software business ideas. The theme of the presentation typically goes something like this: "We are going to do unto [fill in your favorite large incumbent tech company] as Salesforce did unto Siebel Systems."
The basic premise is that Salesforce summarily dismantled Siebel through its revolutionary software as a service (SaaS) business model and took so much market share away that by 2005 Siebel was forced to sell to Oracle. The proverbial story of
"David defeats Goliath" played out in the high tech industry. It sounds like a nice tale, but it's little more than that. The facts are quite different.
Siebel Systems was founded in 1993 by Tom Siebel and Pat House. Within five years, the company went from little-known startup to a nearly $2 billion a year powerhouse, with 8,000 employees and a market cap of $30 billion. It was the leader of the CRM market. In 1999, Siebel Systems was recognized by Deloitte as the "Fastest Growing Company" in U.S. history, with 782,978% growth over five years.
By 2002, the company's top line had stalled, the stock had fallen to a fraction of its former stratospheric level, and on Sept. 12, 2005, Oracle signed a definitive agreement to acquire the company. The transaction was valued at a little more than $6 billion. On March 1, 2006, Siebel Systems no longer existed as an independent entity, a rather inglorious end to a once unassailable company.
Siebel started out developing enterprise sales software. And, these applications were responsible for Siebel's initial growth. However, Siebel also had developed call center technology. In 1998, Siebel made a key decision to acquire Scopus Technology -- a company in the call center market that was nearly as large as Siebel. That decision dramatically changed Siebel's revenue mix and propelled the company into hyper growth. Over the next three years, a significant amount of Siebel's revenue growth was due to the rapid conversion of the world's custom-built call centers to Siebel's call center applications. In fact, the Siebel call center product line was responsible for 70% of Siebel's revenues during the company's peak sales years.
However, in 2001, a global recession hit. Businesses began to cut back on expenses in all areas, but especially in IT. And, one of the industries most heavily affected by the recession was the telecommunications sector, Siebel's largest source of revenue. During the recession, enterprise customer relationship management projects across all industries were put on indefinite hold. The people who had been assigned to those projects were let go or reassigned to other projects.
SAP (SAP), Oracle, and IBM (IBM) suffered through the recession as well. But Siebel Systems' reliance on telecom wreaked havoc on its revenues overnight, and it stayed that way for three years with no end in sight.
Why didn't the recession hurt Salesforce? From 1999 to 2004, Salesforce primarily sold its software to small companies and divisions of larger companies across the U.S. that couldn't afford, or didn't want, a "complex" enterprise CRM system. The average seat count for Salesforce was around 24 per company. By contrast, Siebel sold into large enterprises with a complex product line and had 5,000 customers with 5,000,000 active seats, an average of 1,000 seats per customer.
With the recession in full swing, there were few IT workers in place to install Siebel applications. Salesforce needed no IT -- well, very little IT -- and it was able to fill a gap in the small and medium size business market segment that Siebel could not easily move into.
Siebel was optimized to sell to large companies and had on its roster a large, expensive direct sales team. Salesforce was built to go after the small and medium-size business market, with nimble internal telemarketing, and telesales teams. In 2005, Salesforce reported $176 million in revenue when Siebel recorded around $1.4 billion. Siebel was nearly eight times the size of Salesforce and could not easily change its business model.
Through 2005, the growth of Salesforce was primarily fueled by its uptake in the small and medium-size business market, while Siebel was dragged down by a drop in demand from large companies. Salesforce came out on the other side of the recession in 2006, filling the void Siebel left behind.
In the summer of 2005, Siebel's turnaround plans were interrupted by Larry Ellison's surprise offer to acquire Siebel Systems. Siebel's board approved the offer. The process of integrating the two companies left Salesforce virtually unopposed in the CRM market for the past eight years. As a result, Salesforce now has significant market share and recently entered the call center market with an offering called "service cloud."
While Marc Benioff didn't create this market, he did reimagine how CRM and other business applications could be delivered via a new type of business model -- software as a service (SaaS). For that, he deserves to be recognized and rewarded. So, what can companies competing in the market today learn from this history lesson? Business models are stubborn creatures. Once the "DNA" of a company -- the business model -- is set, it is very difficult to modify. Today, software companies that rely upon a perpetual license "do it yourself" model struggle to compete against the software as a service business model.
Always be adapting. No matter how successful your company currently is, you should always be willing to adapt to the market and competitors, despite how small or seemingly inconsequential they may appear. The moment you hear a senior executive stand up on stage or in a meeting and say something like, "We will win this market because we are smarter and bigger than everyone else," it is time to get nervous. Very nervous.
Diversity is your best shot at survival. It is critical that your company not rely on any one product or any one market for too long. The very thing that drives your success today may be your undoing in the future. Architecture is critical. Today, your product architecture may enable you to compete and win in the market but it will surely be a drag on your business in the future. Your ability to recognize when that is happening and to actually do something about it in time will determine whether your company survives.
Beware of the status quo. Large organizations thrive on status quo and attempt to kill anything that appears as though it may upset it. New products, new business models, new employees, new processes are all anathema to the status quo. Large organizations and Wall Street reward predictability and reliability; they abhor uncertainty and instability, the very things that innovation foments. This is why true "innovation" is seldom found nor survives inside the four walls of a large and successful incumbent. Today, it is becoming popular to create a chief innovation officer to foster internal innovation -- this reads well in annual reports to shareholders. But unless companies move innovation outside the legal, technical, and business constraints of the existing company and allow people to build businesses that may cannibalize and destroy the existing business of the parent company, these well-meaning efforts are doomed to failure.
The mythical story of "the David" Salesforce slaying "the Goliath" Siebel that has been propagated over the years may play well inside the halls of Salesforce or in various industry reports, but the truth is far more pedestrian.
Both companies were headed toward an eventual collision. But Siebel succumbed well before such an epic battle occurred, to a much bigger problem -- a global recession. And once Siebel was acquired, few of the people who made the company successful stayed at Oracle.
In another 10 years, I wonder which companies MBA students will be studying and discussing in their classes. Will Salesforce survive an impending transformation or will a new startup emerge with a new technology -- and perhaps a new business model -- that upends the unassailable CRM leader?

Used with permission as part of our syndication agreement with the Siebel Observer.

Siebelish View 
We don't completely agree with Mr Bruce where he states that Siebel has succumbed. Definitely it has lost some of his mojo but with Open UI coming big time it still has long way to go. Siebel still scores in effective ROI over large implementations for longer run(> 5 years).  Saas has its own implementation advantages but security still remains major concern. For short/mid scale companies it may be boon but over longer period the scalability and customization becomes issue. I have been lucky to have taste of both World and the flexibility which siebel gives is far superior than SFDC. From technical point of view, If one thinks the SFDC has advantage of cloud, that changes can be deployed on run time then Siebel also gives lot of features.  Workflows/DVM/Personalization/Runtime events if properly used can lead to non-srf change deployments.
I hope you have enjoyed the above article. Many thanks to Mr Bruce Daley for allowing above article on Siebelish.