My Discovery

Monday, 31 October 2016

Find Files in Windows with Modified Date

Hi Guys,

Just this command .

C:/Siebel/8.1.1.14/Client > forfiles /P . /S /D +10/27/2016 /c "cmd /c echo @path"

Above command will give you all the files modified from 27th October 2016 from Current Directory and also all sub directories.

if you want this information in a file, then use this command.

C:/Siebel/8.1.1.14/Client > forfiles /P . /S /D +10/27/2016 /c "cmd /c echo @path" > ModifiedFiles.txt

Enjoy...

--
Srikanth

Wednesday, 28 January 2015

Siebel Innovation Pack 2014 on Windows(2012) 64 Bit Server

Hi All,

I have got a Server and I wanted to get hold of Siebel Open UI. So I have decided to install Siebel 8.1.1.14.0 64 bit on windows 2012 Server.

Siebel Innovation Pack 2014

On one Single Server, I have installed.

(64 bit) Oracle Database Server
(32 bit) Oracle Client
(b4 bit) Siebel 8 1 1 14 0

Here is my exp, enjoy.

1. Download Windows 2012 Server, you will get 6 Months Evolution period.

First Thing that we have to do, disable the IE Enhance Security Configuration Setting
Click Here to see the steps for the same

Install IIS Server as a windows Feature.
Make sure you select the all the below components also.
* IIS 8
* IIS6 metabase and IIS6 configuration compatibility

* IIS6 WMI compatibility

* ISAPI Extensions

* IIS Management Console

2. Download and Install Oracle 11g R2 from below link
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

One Database:
Name : ORCL - running the 1521 port

3. Download and Install Oracle 32 Bit Client from below link
  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

Siebel uses 32 bit client only, that's why we need 32 bit client.

At this point We have 64 Bit Server(it comes with Client) and 32 bit Client installed.
Follow below steps to make sure we have PATH & Environment Variables set correctly.
Server is installed in C:\app\oracle\11.2\db_home1
32 bit client installed in C:\app\oracle\11.2\client_x86

Go to c:\windows\system32 folder in command prompt,
Create a Symbolic link ora112 to the folder c:\app\oracle\11.2\db_home1
Go to c:\windows\SysWOW64\ folder in command prompt
Create a Symbolic link ora112 to the folder c:\app\oracle\11.2\client_x86

Set Environment variable ORACLE_HOME to c:\windows\system32\ora112
Also update the PATH variable,
remove individual oracle folders and put C:\windows\System32\ora112\bin

COMMAND to create Symbolic link
mklink /d ora112 c:\app\oracle\11.2\client_x86

Full details about these steps you can found in this Link.

At this stage Oracle Server and Client are ready and we can start Siebel Installation.

4. Download Siebel 81114 from eDelivery for 64 bit. Download the following files.
Siebel Enterprise Server
Siebel Image Creator
Siebel Tools
Siebel Enu Language Pack

Extract all the zip files in one Folder.

Use the Image creator to create the Images for Siebel Server, Web server, Tools etc.

5. Install Siebel Server, Select all the components.
Gateway Name Server
Siebel Server
Database Configuration Utilities
EAI Connector
I have given the installation folder C:\Siebel\81114\ses\
You can find all the Responses Text files here.

6. Configure the Siebel Gateway Server and Enterprise Server in Gateway, these two should be straight forward. Find the details in Response files.

7. At this moment, there is SBA_82_DSN 32 bit oracle dsn is created, make sure you use 32 bit odbc tool to test the connection.

8. Before you proceed any furthur, Siebel Server config will update this DSN to use Siebel Server DLL but some files are missing. So please copy below files form gtwysrvr/bin to siebsrvr/bin
You can override the files.
    Ivse.lic
seicu25.dll
seor825.dll
seor825r.dll
seor825s.dll

9. Run the grantusr.sql file to ORCL database as SYSTEM user.

10. Start the Database Server Configuration, it will take about 3 hours to finish full config.

11. Now you can start the Siebel server config, and it work with no issues, if you follow the above steps exactly.
If the server is not coming up and gives the error about WFProcMgr compnent is not available, use the SRVRMgr to sync the components.

12. Install SWSE and Apply the logical profile, at this time, IIS server should show the siebel urls.
Check the Responses files for the values I have used.

13. Restart the server and Siebel Server should start with Open UI. Enjoy.

14. You can find the screenshots of the same here.

Friday, 19 September 2014

Siebel - Assignment Manager - SADMIN - Default Organization

Hi All,

We all have faced the issue with Assignment Manager, that if no rule is satisfied then it will assign SADMIN in Positions and Default Organization in Organization.

If this is causing issues in your project, then the following solution avoids such problem.

Configure the Dynamic Candidate for Account for existing Organizations and existing positions.

Below screenshot show the same. (for both position & Organizations).

Click the image to enlarge

Then create a Assignment Rule as below

no criteria at all
select the value "Account Organization" in the Organization Candidates Source drop down.
Select the value "Account Positions" in the Person Candidates Source drop down.

This rule always be satisfied and also keep the existing Organizations & Positions

This way SADMIN / Default Organizations never be assigned.

Enjoy !!!!

Monday, 18 August 2014

Siebel - Custom Profile Attribute

Hi All,

There will be requirements for which you may need custom Profile Attributes. This post will give you idea on how to create Custom Profile Attribute.

Profile Attributes will be coming from BC : Personalization Profile.

Make the Proper Joins on this BC to derive the value as needed.

Name of the field will be Profile Attribute Name.

For ex : Personal Country.

Make the Join to S_ADDR_PER on ROW_ID is Primary Personal Address Id field.

Create a New field : Personal Country -- S_ADDR_PER --> COUNTRY (Join created above step).

You can use this attribute as GetProfileAttribute('Me.Personal Country') where ever needed.

Enjoy !!!!

Wednesday, 11 September 2013

Call Account Sync from Org / Address MVG

Requirement :
----------------------
Siebel need to call Sync with Customer Master (EBS / ECS / Middle Ware etc) when ever change of Address or Change of Organization happens.

Solution :
-----------------------

Usually Siebel kick off integration on Account Save.
Once Organization changes, and if we kick off Account Sync from MVG we will get issues like "Record already Modified" etc.

Simple Solution is, keep a dummy field on Account.

Write a Script on Internal Division / Organization , WriteRecord event,

Update this dummy field of Account / Contact using ParentBusComp, so that, the Record will become dirty.

once MVG is closed, step out of the Account record will call Save Record and that will kick off Account Integration from Account.

Monday, 20 August 2012

Siebel EAI Object Manager in your local Machine

Here is the Problem.

I have developed the Siebel EAI Web Service and I wanted to test this before I check-In to the server. I can use simulator but you have to build Siebel Message following all hierarchies. It would be awesome if I can test my service with SOAP-UI client.

So Here is solution for that.

Steps To Enable your Local Web Client as EAI Server to accept SOAP - Calls

1. Copy the HTIM cfg file as HTIM_Local_EAI.cfg

Add the following parameters in the [Siebel] section

EnableWebServices = TRUE

WebServicesPort = 2330

2. Make a shortcut for the Siebel Web Client with the HTIM_Local_EAI.cfg.

The command should be like this.

"D:\Siebel\8.0\web client\BIN\siebel.exe" /c D:\Siebel\WEBCLI~1\bin\ENU\htim_Local_EAI.cfg /u SMUTHAVARAPU /p SMUTHAVARAPU /d Local /webservice 2330

3. Open the Local Web Client, Go to Webservice Administration Screen and modify the Address as following

http://localhost:2330/eai_enu/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute&UserName=SMUTHAVARAPU&Password=SMUTHAVARAPU

Note : Here use only your user name & password as your local will have only your user name.

4. Generate the WSDL from Webservice Administration Screen and call from SOAP. Check the following Screen shot.(Attached)

References

http://siebel-essentials.blogspot.com/2010/03/siebel-mobile-web-client-and-web.html

Wednesday, 16 March 2011

Siebel WebService Call - From - PHP

This blog will explain how to call Siebel Web Service from PHP.

This will also shows, how to handle the Siebel complex XML structure in PHP.

Here I am using following WSDL file, I am also giving the Request and Response for the same.

WSDL --> SSO_Service.WSDL (This file is physically located in the PHP code folder)

Note : Please test your Webservice from SOAP Client before you start coding in PHP, so that it will be easy to code.

SOAP Request :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:zeb="http://siebel.com/SOService">
<soapenv:Header/>
<soapenv:Body>
<ns:SSO_spcService_Get_spcUser_spcInfo_Input>

<ns:User_spcId>SADMIN</ns:User_spcId>
</ns:SSO_spcService_Get_spcUser_spcInfo_Input>
</soapenv:Body>
</soapenv:Envelope>

SOAP Response :

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<ns:SSO_spcService_Get_spcUser_spcInfo_Output xmlns:ns="http://siebel.com/SSOService">
<ns:NumOutputObjects>1</ns:NumOutputObjects>
<ListOfSsoContact xmlns="http://www.siebel.com/xml/SSOContact">
<Contact>
<EmailAddress>sadmin@company.com</EmailAddress>
<FirstName>Siebel</FirstName>
<LastName>Administrator</LastName>
<LoginName>SADMIN</LoginName>
<Status/>
<Id>0-1</Id>
<ListOfAccount/>
<ListOfResponsibility>
<Responsibility>
<Name>Siebel Administrator</Name>
</Responsibility>
<Responsibility>
<Name>Marketing Analytics Super User</Name>
</Responsibility>
</ListOfResponsibility>
</Contact>
</ListOfSsoContact>
</ns:_spcSSO_spcService_Get_spcUser_spcInfo_Output>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

PHP Code to Handle above SOAP Method :

$soapClient = new SoapClient("SSO_Service.WSDL");
$inputParam = array('User_spcId' => 'SADMIN');
try

{

$info = $soapClient->__call("Get_spcUser_spcInfo", array($inputParam));

}

catch (SoapFault $fault) {

echo ' ************ Error ***********' . $fault->faultcode;

echo ' *************** Error ************' . $fault->faultstring . '
';

}

//NumOutputObjects is Immediate Output
echo " # of Records : " . $info->NumOutputObjects . "";

$ListOfSsoContact = $info->ListOfSsoContact;

//Pick the first Contact

$Contact = $ListOfSsoContact->Contact;

echo ' Email Address : ' .$Contact->EmailAddress . ' ';

echo ' First Name : ' .$Contact->FirstName . ' ';

echo ' Last Name : ' .$Contact->LastName . ' ';

Please post your questions if you need more information....

Wednesday, 12 January 2011

Siebel Tools / Web Client in Windows 7

Started installing Siebel Tools / Web Client in Windows 7
Installed Oracle Client OK. tnsping to server worked OK.
When I install Siebel Tools first time, i got the error "Class not Registered" error.
Installed "http://support.installshield.com/kb/files/Q108312/ikernelupdate.exe" as per metalink suggestion.
Now, started Siebel Tools Installation, it crossed "Class Not Registered" Error.
Tools 8.0.0.0 installed without error.
WebClient 8.0.0.0 installed with one Error, It could not open IE
Tools 8.0.0.10 installed with out error.
Web Client 8.0.0.10 installed with the one Error. It could not open IE.
Started the Siebel tools -- with Local Database. First Time Login, running the DB Extract.

DB Extract completed and Downloaded the Local DB with out errors.

Check the Screen shot of the Tools in Windows 7

Checked out some objects from Server, that went well.

Started Full Compile from Tools, got errors, then Started Full compile from batch file. with the following Command

C:\Siebel\Tools\bin\siebdev.exe /BC "Siebel Repository" "C:\Siebel\Web Client\OBJECTS\ENU\siebel_sia.srf" /TL ENU /d Local /u UNAME /p PASSWORD

Launch the Web Client, Remember you need to Right click onthe icon, and select "Run As Administrator".

If you want it to be automatic, Right Click on the Web Client icon, Properties, and slect the check box as in the following Screen shot.

The Siebel Active X gave me some problems, other wise, it went well.
Here are some screen shots of the Siebel Web Client in windows 7

Initial Active X Install

Pick Applet

MVG Applet