יום שני, 16 בדצמבר 2013

Query Issue in Siebel Open UI 8.1.1.11

There is an issue with Siebel open UI 8.1.1.1 . When you query a record, OpenUI displays records. But you cannot drill-down or edit that record, even though you have all privileges.

steps to reproduce.
got to any list applet, Click on query, Press "Enter" try to drill-down. This drill-down works only if that record is current record.
or
Try to navigate by clicking next record, you cannot, you have to use next/previous button

Temporary Solution:
Instead of pressing enter click on "Go" Button.




יום חמישי, 12 בדצמבר 2013

Custom File Upload Applet Based On Class CSSSWEFRImpExp / CSSSWEFRImpExp Fails

We have an Import Button in an Applet, on clicking that button, a small popup applets comes and we can upload CSV which is to be imported in to parent applet. This functionality works well in HI mode. But this functionality fails in OpenUI.
Oracle support says this issues addressed in 8.1.1.11, but still I am getting error.

We can Implement this feature with some tricks.

lets create a button on applet and give method name as "FilePopup". And make sure that CanInvoke is true for this method.



function WebApplet_PreCanInvokeMethod (MethodName, &CanInvoke)
{
    if(MethodName == "FilePopup")
    {
            CanInvoke="TRUE";
            return (CancelOperation);
    }
    return (ContinueOperation);

Now open Applet Browser script. 


function Applet_PreInvokeMethod (name, inputPropSet)
{
    switch(name)
    {
        case "FilePopup":
        var ShowModalOptions= "dialogHeight:150px;dialogLeft:100px;dialogWidth:350px;scrollbars:no";
        var intRet = theApplication().ShowModalDialog ("FileImport.htm", "", ShowModalOptions);
       
        var Bc = this.BusComp();
        var csvval=intRet.split("|");
       
        for(var j=0;j<csvval.length-1;j++){
            this.InvokeMethod("NewRecord");
            var csvvalue=csvval[j].split(",");
            Bc.SetFieldValue("First Name",csvvalue[0]);
            Bc.SetFieldValue("Last Name",csvvalue[1]);
            Bc.SetFieldValue("Age",csvvalue[2]);
            Bc.SetFieldValue("Sex",csvvalue[3]);
        }

        return ("CancelOperation");
        break;

        default:
        return ("ContinueOperation");
        break;
    }
    return ("ContinueOperation");
}


Next step is creating an HTML file. Copy the below code and save it as  "FileImport.htm"
in Webserver as well as siebel server. ( \Client\PUBLIC\ and \siebsrvr\WEBMASTER\ )

<html>
</head>
<script language="javascript" src="23030/scripts/3rdParty/jquery.js"></script>
<script>
$(document).ready(function(){

$("#filename").change(function(e) {
var ext = $("#filename").val().split(".").pop().toLowerCase();

if($.inArray(ext, ["csv"]) == -1) {
alert('Upload CSV');
return false;
}

if (e.target.files != undefined) {
var reader = new FileReader();
reader.onload = function(e) {
var csvval=e.target.result.split("\n");
var inputrad="";
for(var j=1;j<csvval.length-1;j++){
    var csvvalue=csvval[j].split(",");
    for(var i=0;i<csvvalue.length;i++)
    {
    var temp=csvvalue[i];
    if(inputrad==""){
         inputrad=temp+"";
    }else if(i!==0){
         inputrad=inputrad+","+temp+"";
    }else{
        inputrad=inputrad+""+temp;
    }
   
   
    }
    inputrad =inputrad+"|";
}

window.returnValue = inputrad;
return inputrad;
};
reader.readAsText(e.target.files.item(0));

}


});
$("#import").click(function(){
    self.close();
});
})
</script>
</head>
<body>
<input type="file" name="filename" id="filename">
    <div id="csvimporthint_1">
        <table border="1" id="csvimporthint">
        </table>
    </div>
<input type="button" id="import" value="import">

</body>
</html>

compile applet and run GenB script.
Click on Import button and test this functionality.

How to add custom JavaScript files in Siebel OpenUI 8.1.1.11

Siebel OpenUI 8.1.1.11 comes more more systematic way to manifest the custom JavaScript.
In the Administration level, we have options to add files as well as map those files with applets/views/Applications.

First we need to add our custom files in Manifest files

Now we can map those files with our Application /Applet


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!!

יום חמישי, 28 בנובמבר 2013

Siebel Open UI : Migrating a renderer from 8.1.1.10 to 8.1.1.11

Siebel Open UI : Migrating a renderer from 8.1.1.10 to 8.1.1.11

This tutorial is all about how to migrate code from 8.1.1.10 to 8.1.1.11


thanks to  Duncan Ford

יום שלישי, 19 בנובמבר 2013

Internet Explorer 7 (IE7) no longer certified with My Oracle Support and Cloud Support Portal after April 4, 2014

 Oracle stops supporting IE7

"On April 4, 2014, Oracle Support will remove Internet Explorer 7 (IE7) from the My Oracle Support and Cloud Support portal certified browser list. It is important that you make the transition to a more current version of Internet Explorer prior to April 4, 2014.

We recommend that you review the “Supported Browsers” link for a list of My Oracle Support and Cloud Support portal certified browsers. When upgrading your browser, it is important to note that Internet Explorer 11 (IE11) is not yet certified with My Oracle Support and Cloud Support Portal. Newer versions of supported browsers are usually certified within six months from their release date.

If you have any questions or feedback, please log into My Oracle Support and use the "Contact Us" link located in the upper right hand corner."

יום רביעי, 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!!

יום שלישי, 5 בנובמבר 2013

White screen issue after patching openUI (8.1.1.11)

Some of developers getting white screen after patching open UI, and error console says.
 
Message: Object doesn't support this action
Line: 38
Char: 799
Code: 0
URI:
http://192.168.1.104/callcenter_enu/23030/scripts/siebel/navctrlmngr.js?_scb=

Oracle support web came with a solution for this problem.

Cause
FP 8.1.1.11, aka Innovation Pack 2013, contains many changes for the Siebel Open UI. When the pre-8.1.1.11 SRF is used for Siebel Open UI, it cannot perform the operation correctly and the above error is shown

Solution

Please download the new SRF to replace the pre-8.1.1.11 SRF as below.

1) Login to Oracle Software Delivery Cloud, aka edelivery (https://edelivery.oracle.com/)

2) Search Siebel CRM product with the following criteria then click "Go" button.
Select a Product Pack: Siebel CRM
Platform: (corresponding platform)

3) Find the description below then select it.
Description: Siebel Industry Applications Innovation Pack 2013 Release 8.1.1.11 Media Pack for "corresponding Platform"

4) Find Siebel Repository Files (SRF) as below and click "Download" button.
Name: Siebel Industry Applications Version 8.1.1.11 Siebel Repository Files
Part Number: V39883-01

5) Downloaded file contains SRF for many languages. Choose the correct one for the system and unzip it to siebsrvr\objects\LANGUGAE folder.
** LANGUAGE should be replaced by the appropriate three letter language code.

Please use
https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=2ygn9xguq_9&_afrLoop=59616672061561

יום רביעי, 9 באוקטובר 2013

Siebel OpenUI 8.1.1.11 Fix Pack - Features

The next release on 8.1.x is 8.1.1.11. This innovation pack is releasing with lot of features, that is available in non-open UI versions and missed in older open UI versions(8.1.1.9/10)
  • Siebel Mobile Disconnected
  • Customer Facing Sales Applications
  • Partner Facing self Registration
  • Marketing - HTML/Rich Text Editor, Allocation, Calender, Flow Universal Inbox
  • C/OM - Sum totals on list: Contact hierarchy view
  • Sales - Funnel Chart
  • Right-to-left language support
  • List views - Column lock, column resizing, save state
  • Online Help- Searchable, Context sensitive help
  • Personalization, Applet Location/Hide
  • Expression/Rule Designer
  • Outbound email f9/Email Response
  • Calendar Drag/Drop Validation
  • Applet right click menu
  • Bar code toolbar
  • Chat
  • CTI toolbar - Hotelling
  • GANTT Chart
  • Chart program Designer
  • SmartScript -Designer/Player

יום ראשון, 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!!


יום שלישי, 10 בספטמבר 2013

Constellation Resarch Webinar "Where You Stand with Siebel" on Sept. 18th

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
How: https://www3.gotomeeting.com/register/578393734

Research and advisory firm Constellation Research will hold a Webinar on Where You Stand with Siebel on September 18th. The 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 pleased to be helping Siebel customers meet this challenge."

The webinar is based on the research paper "The State of Siebel in the 2013 Market: Different Strategies for Moving Siebel Implementations Forward and Assessing Career Risk" that will be published next week by J. Bruce Daley, Vice President and Principal Analyst at Constellation Research.

Daley was, for many years, the publisher of the Siebel Observer, the largest publication covering the CRM pioneer. Widely quoted in The Wall Street Journal, The New York Times, The Financial Times, Daley also founded the Enterprise Software Summit.

Bruce's 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.

Webinar Information

When: 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

יום שבת, 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

יום שלישי, 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.

יום שישי, 2 באוגוסט 2013

Two Buttons with same Method Invoked = ShowPopup, displaying different popup applets!!




After reading the title of this post, you might have got some idea
what the scenario I am going to talk about today. This is the scenario where I
have two buttons exposed on the UI and both having the same Method Invoked =
"ShowPopup".


Here
below is the snapshot:






1.
Create SR : this
button is being used for displaying “Create

How to display Popup applet in Siebel - Possible ways!!





Siebel provides various different OOB ways to display
a Popup applet, no matter if it a list applet or form applet. Here below is the
list of all possible ways:



1.
ShowPopup



This is a straight forward OOB way to display a popup
applet which is mostly used to display a popup when button is clicked.



a.