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.


Thursday, December 12, 2013

Authentication Business Service

Most people want security in this world. So whatever piece you design, Authentication becomes the key aspect. There are times when you want to authenticate whether the user-in-context is valid siebel user or not without actually logging into the system. This type of requirement is typical in Mobile Solutions using HTML5 and siebel webservices.

Here I unearth one more hidden gem of siebel, "Authentication Business Service". This magical service authenticates user against siebel irrespective of your security authentication mechanism. Be it database or LDAP it will return you valid siebel user name else invalid user/password error.The method is "Authenticate".  It accepts three input parameters:

1 - User Name - User Name to be authenticated in siebel
2 - Password - Password of the user
3 - GetPrivateCredentials - Y OR N based on the requirement.  If set to Y it will result user name in "Siebel User Name" output parameter.

One can see its usage in "LS Medical User Verification" workflow to get better feel of it. You can create web service based on this BS and can rest assured of your authentication approach. Hope it helps.

Happy Authentication!!

Wednesday, November 13, 2013

Live Webinar - Top 5 Siebel strategies for Siebel Customer

Renowned Siebel expert, J. Bruce Daley, vice president and principal analyst at Constellation Research, is planning to present a live webinar on top 5 siebel planning strategies. Please join me in attending the session as it can help you evaluate your current implementations and evolve go-ahead siebel strategies. 

In this webinar, Siebel experts will discuss findings from the Constellation Siebel reports.  Five different strategies are outlined – Move Forward, Move Away, Restart, Innovate Around the Edges, and Stand Pat – that you can use to move your implementation forward into the next decade. 

These are the topics:
  • The real position Siebel technology holds in the market
  • Why the conventional wisdom about the product is often wrong
  • What trends are driving misconceptions in the market
  • How to assess your Siebel implementations and a move-forward strategy
  • We want to set the record straight so you know where you stand with Siebel that will provide insights to your organization and your career.

When: Thursday, Nov 14, 2013, 10:00 am PT / 1:00 pm ET

Register now before its late. Don't give it miss at any cost as they say show must go on. 

Happy Learning!!

Sunday, September 22, 2013

Webinar Report and Survey

If you weren't able to follow Bruce Daley's webinar "Where Do You Stand with Siebel", here is a quick recap:

Oracle Siebel CRM is a mature application showing both continued robustness and signs of age. With Oracle sending mixed messages about the product’s future, Bruce Daley, VP at Constellation Research has published a report which helps Oracle Siebel customers understand the real position Siebel technology holds in the market, why the conventional wisdom about the product is often wrong, and what trends are driving misconceptions in the market. It also offers pragmatic advice for taking Siebel implementations in different directions and how associated careers will be impacted

You can view the replay and download the slides here.

You can download the report with compliments of Rimini Street here.

State of Siebel 2013 Survey

Along with the report, Constellation Research and the Siebel Essentials blog are conducting a survey to feel the pulse of the Siebel community. If you are involved in a Siebel CRM project, please take some minutes to fill in the survey form.

Click here to access the survey.

Thanks again!!


Saturday, September 7, 2013

Constellation Research to Host Webinar on Where You Stand with Siebel

This free 45 minute webinar will discuss what different directions Oracle Siebel professionals can take their Siebel implementation and their careers.

Who: J. Bruce Daley, Vice President and Principal Analyst Constellation Research
What: Webinar: "Where Do You Stand With Siebel”
When: Wednesday, September 18, 2013 at 9:30 a.m. US Pacific time

Constellation Research, Inc., the award-winning research and advisory firm focused on disruptive technologies is offering a free 45 minute webinar to introduce a new analyst, J. Bruce Daley, in one of his primary research areas - the standing, enhancement, and conversion of legacy enterprise class software technology.

His topic will be the different directions Oracle Siebel customers, partners, and consultants can take their Siebel implementation and their careers. This year marks the 20th anniversary of Siebel technology and as a mature application it shows signs of both robustness and age. With Oracle sending mixed messages about the product’s future, this webinar helps people making a living with Siebel determine exactly where they stand.
“Clearly Siebel technology is not dead and plays an important role in the IT infrastructure of many of our clients” noted R “Ray” Wang, CEO of Constellation Research.  “Figuring out exactly where Siebel fits into the mix is challenging. We are excited that Bruce will bring his wealth of understand and experience to helping Siebel customers meet this challenge. ”

Daley was, for many years, the publisher of the Siebel Observer, the largest publication covering the CRM pioneer.  Later he co-founded a boutique advisory services firm that brokered the sale of system integrator Blue Hammock Inc. to GCI International (now called Collabera) and conducted over 250 consultations with mutual funds, hedge funds, and private equity funds. Widely quoted in The Wall Street Journal, The New York Times, The Financial Times, Daley also founded the Enterprise Software Summit.
His first research paper for Constellation: “Seeing the Good, the Bad, and the Ugly in Legacy ApplicationsHow to Attack or Defend an Installed Base by Understanding How to Qualify the Success of a Legacy Applications was published this week. This original research helps sales representatives and sales management determine how likely a legacy implementation is to be converted so they can qualify opportunities and threats more quickly. The report is available for purchase at http://www.constellationr.com/

His second research paper “The State of Siebel in the 2013 Market: Different Strategies for Moving Siebel Implementations Forward and Assessing Career Risk will be published next week. This research helps Oracle Siebel customers understand the real position Siebel technology holds in the market, why the conventional wisdom about the product is often wrong, and what the trends driving the misconceptions in the market. The report also offers pragmatic advice for taking different Siebel implementations in different directions and how they will impact different careers. The report will be available on the Constellation website Wednesday, September 18, 2013 at:

9:30 a.m. US Pacific time
10:30 a.m. US Mountain time
11:30 a.m. US Central time
12:30 a.m. US Eastern time
17:30 UK time
18:30 Central European time
Webinar Information: To register for this complimentary webinar, go to: https://www3.gotomeeting.com/register/578393734

Tuesday, September 3, 2013

Multiple File Attachments

Necessity is mother of taking chances. In recent outrage by our business users, we were asked to provide option of selecting multiple file attachments. Unfortunately siebel doesn't provide option of creating multiple attachment in one go. Even drag and drop in High interactivity creates only one attachment. With Open UI there are options but with good old HI and SI mode this can be real tricky. However, With mix of HTML-Javascript-browserscript we were able to achieve a custom built html file with multiple file browse options. where user could select three files in one go.



Below custom file browse HTML was used . Name is as "MultiFileAttach.htm".


Once the HTML page is ready, copy it in  Siebel\Client\PUBLIC\Enu and \siebsrvr\WEBMASTER\enu folders. I was not able to use Multiple attribute for file input type (food for thought for Javascript masters) so was forced to use three different file controls. The key here is returnValue property which returns the "," separated file paths, which we use in our browser script to parse and create attachments in siebel file system.Below is the browser side code.

 

We are invoking the custom "MultipleFileAttach.html" using ShowModalDialog method. Once we capture the path of attachments, "FINS Industry BC Facility Service" is used to create the attachments. In order to use this BS on browser side one must define this as part of user property on Application Level. One on Open UI can sleep well as there are lot of plugins available for Multiple File uploads. Java punters can propose alternate solutions to this approach, as usual your comments/inputs/suggestions are most welcome.

Happy Crunching!!

Warning: This piece is for demo purpose. Please test this solution thoroughly before you implement in your production systems.

Monday, July 15, 2013

Sample ASI SOAP Message

A lot has been written about Siebel ASI's. Developers tend to swore by them in order to achieve anything. Despite being so famous, the-mother-of-document siebel bookshelf doesn't have enough sample examples of them. Though there are details about structure of the ASI's. How they can be deployed as web services, about Interface integration objects, etc but still those fascinating examples are missing which helps in quick understanding.
If you have already worked on ASI's you can directly jump to comments section for your experience else you can continue to have a look as the sample SOAP message which can be directly fired from your SOAP UI to fetch results.

Here i am discussing about OOB siebel ASI, Siebel Contact and its two operations:

1 - QueryById
As the name suggest you can query contacts available based on one Input, i.e. RowId. Sample input message for same will look like:


2 -QueryByExample
 With this operation you can query on any of the fields as mentioned in the integration object. Sample request message for the same will look like.  This will return you all the contacts starting with Ra* in the response message based on your output integration object.


We will discuss sample request messages pertaining to other operations in next posts. I also found a very good article written on ASI from oracle which can be of great help to others.

Happy Integration!!

Wednesday, July 10, 2013

Android and Siebel WebServices

Finally life has turned to, need of hour,development of MobileApps for siebel and trust me it is as thrilling as watching any bond movie. with new projects come new challenges. So while developing android app for our users we got stuck in one show-stopper issue.

The main requirement was to consume a webservice hosted in siebel. On Android, consuming a SOAP web service is more difficult (as opposed to consuming a RESTful web service), since it does not include any libraries to communicate with SOAP web services. Unfortunately you have to manually write the code to consume the service which is not as straightforward as compared to writing in any other Java project.

With siebel doesn't giving a direct hosted URL it was more difficult for us to write the code. As an alterate solution we have to write a .net webservice which consumes the siebel webservice. The next issue is to generate the Java classes needed from the .Net WSDL files, and this is where I was coming up short with knowledge. But with little help from google found library called kSOAP2 that filled the gap and helped in generating the classes. I am still not able to figure out how to directly consume siebel webservice in android app without wrapping it in another webservcie. Any idea on this will be of great help.

Happy Integration!!


Monday, June 3, 2013

Poll Result and Analysis

Results of the Poll Future of Siebel are out officially. @lex has collated and presented the analysis at this link. You can also catch up with the official press release here. The results have not taken many by storm but yet gave oxygen to the faith that there is no reason to panic and give up on Siebel. In the ever changing market dynamics, Siebel will continue to emerge with its architecture evolving and adapting to market needs.

With "Open UI" striking and more customers embracing it, its time to explore some Java skills. It also marks centuries of post on CRM Conundrum. Thanks to all readers/followers for making it success. Sooner or Later even you will be reading on piece of Open UI here till then stay tuned.

Happy Voting!!

Sunday, June 2, 2013

UIF Calendar Control in MVG Applet

Recently while working on multilingual application we faced strange issue. While setting values in MVG applet with calendar control, any date value was getting appended with UIF_ string. As a result invalid format error was coming. Eagle-eye pursuit resulted in the fact that even on the calendar control the month was like "UIF_May". To our surprise this issue was not happening on all machines. It was occurring only in some of the user machines with specific configuration. On discussion with Oracle it is found to be product defect.
                                                           


With configuration of Windows 7 and IE 8, it happens in ARA/ENU/FRA implementations. In order to resolve the issue IE 8 must be updated to latest patches from Microsoft or as an alternate solution could be:

1. In the Internet Explorer browser, go to Tools > Compatibility view setting > Uncheck all the options.
2. Press F12 and set the Browser Mode value to IE8.

This will resolve the issue for while.  

Happy Crunching!!

Thursday, May 23, 2013

Poll Closure

The poll for seeking your opinion regarding future of Siebel has been closed.  Gratitude to everyone who cast their votes and participated in discussions. 


Please stay tuned for a detailed analysis of the poll results on Siebel-Essentials. Many thanks again for voting to all Followers/Members/Readers/Friends. 


Happy Voting!!