Pragmasys MSCRM Team: MSCRM 2011 Ribbon and SiteMap Editor

Pragmasys MSCRM Team: MSCRM 2011 Ribbon and SiteMap Editor: "Pragmasys team is pleased to release the initial version of the PragmaTools for MSCRM 2011 aimed at imporving developer efficiency and accur..."

OPENINGS FOR SIEBEL DEVELOPERS

Company: Pragmasys Consulting LLP (http://www.pragmasys.in) is a startup consulting organization focusing on providing business solutions to its Customers in the Enterprise Solutions space. With strong partnership with Oracle and Microsoft, Pragmasys provides services such as – Implementation Advisory, Solution Architecture consulting, Enterprise Design consultancy, end to end product implementation, performance tuning. To fuel our growth, we are looking for strong expertise in the Enterprise solutions space currently in the areas of Siebel CRM, MS CRM and OBI.

Why should you join? If you want to gain hardcore consulting experience on your profile and gain new skills and abilities, this is a right opportunity for you.

Location: Pune


1. Designation: Siebel Developer
Experience: Fresher (who has completed siebel training) / 1-2 yrs of experience in siebel configuration

Desired Profile:
Key Requirements:
* Good knowledge and experience in-
o Siebel Configuration/ eScripting
o Siebel Workflows

* Preferable skills-
o Siebel 7.x +

For more information please visit www(dot)pragmasys(dot)in

Workflow Queries

1.Query to know the Policy by which required workflow is fired.

select c.name as policy_name, d.DEFAULT_VALUE as workflow_name
from S_ACTION_DEFN a, S_ESCL_ACTION b, S_ESCL_RULE c,S_ACTION_ARG d
where a.row_ID = d.action_id
and b.action_id = a.row_ID
and c.row_id = b.RULE_ID
and d.DEFAULT_VALUE = 'Account Notify Children'


2.To know all Steps of a workflow

SELECT P.NAME PROCESS, S.NAME STEP --A.NAME ARG,A.VAL_TYPE_CD VAL_TYPE, A.VAL VAL
FROM S_WF_STEP P, S_WF_STEP S
WHERE P.TYPE_CD = 'PROCESS'
AND P.STATUS_CD = 'ACTIVE'
AND P.ROW_ID = S.PROCESS_ID
AND P.NAME = 'Status Change' --- WF Name


3.To Know All Workflows and Step in which particular Business Service is called

select B.NAME PROCESS_NAME , A.NAME PROCESS_STEP, A.SERVICE_NAME BUSINESS_SERVICE , A.METHOD_NAME METHOD
from S_WF_STEP A , S_WF_STEP B
where A.PROCESS_ID = B.ROW_ID
and A.SERVICE_NAME = 'Change Subscriber Status' -- Business Service Name
and B.STATUS_CD = 'ACTIVE'
order by 1,2,3


4.To Know the workflow Process and step which uses particular method of business Service

select b.name as process_name , a.name as process_step, a.service_name , a.method_name
from S_WF_STEP a , s_wf_step b
where a.process_id = b.row_id and
a.method_name = 'Change Subscriber Status' -- Name of the Bus Service Method
and b.status_cd = 'ACTIVE'
order by 1,2,3


5.To know all workflows and steps which uses particular workflow process as a subprocess

select P.NAME MAIN_PROCESS, S.NAME PROCESS_STEP , s.method_name SUB_PROCESS
from S_WF_STEP p, S_WF_STEP S
where P.TYPE_CD = 'PROCESS'
AND P.STATUS_CD = 'ACTIVE'
and s.process_id = p.row_id
and s.type_cd = 'SUB_PROCESS'
and s.method_name = 'Check Latest Order' -- Name of Subsprocess



6.Query to know All the input arguments passed to the method of particular Business Service through particular workflow

SELECT P.NAME PROCESS, S.NAME STEP, s.service_name BS_NAME , s.method_name , A.NAME ARGUMENT ,A.VAL_TYPE_CD VALUE_TYPE, A.VAL VALUE
FROM S_WF_STEP P, S_WF_STEP S, S_WF_STEP_ARG A
WHERE P.NAME = 'Account Online Status Update' -- Name of Workflow
AND P.TYPE_CD = 'PROCESS'
AND P.STATUS_CD = 'ACTIVE'
AND P.ROW_ID = S.PROCESS_ID
AND S.ROW_ID = A.STEP_ID
AND A.INPUT_FLG = 'I'
AND s.service_name is not null
AND s.method_name is not null
ORDER BY 1,2,3,4,5

SIEBEL and BI Publisher Integration

Pre-requisites:-
Siebel Version 8.1.1.x
BIP Version >= 10.1.3.4.1

1. Enable following Siebel Server components:-
• Siebel Application Object Manager (AOM)(for example, Call Center Object Manager (ENU))
• Siebel Enterprise Integration (EAI)
• XMLP Report Server component

2. Copy JAR files to the Oracle BI Publisher Server and Siebel Server
BI Server Path: ORACLE_HOME/oc4j_bi/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib
Siebel Server Path: SIEBSRVR_ROOT\CLASSES
• XSLFunctions.JAR
• SiebelCustomXMLP.JAR
• SiebelCustomXMLP_SIA.JAR
• Siebel.JAR
• SiebelXMLP.JAR

3. Go to BIP Server->Admin tab, select Properties under Runtime Configuration.
• Disable External Reference attribute=False

4. Import an archive file to apply the new Siebel Reports features for 8.1.1.x
Lock the Below Projects
• XMLP Integration Project
• Table XML
• Symbolic Strings
• Reports UI
• User Preferences

5. E.g. Import the BIP_8113.sif
Make changes to tools.cfg(SymStrPrefix=SBL_) before importing sif.

6. Apply Schema of below tables to server database.
• S_REPOUTPT_PSTN
• S_REP_TMPL_PSTN
• S_XMLP_REPOUTPT
• S_XMLP_REP_TMPL
• S_XMLP_RPT_VIEW

7. Copy fonts:

• C:\WINDOWS\Fonts to JAVA_HOME\lib\fonts

8. Add an explicit reference to JAR files for the Oracle BI Publisher Server
• Administration - Server Configuration screen->Enterprises-> Profile
Configuration view.

• XMLPJvmSubsys=/classes/SiebelXMLP.jar;/classes/
xdoparser.jar;/classes/fix6312772.jar;/classes/
xdocore.jar;/classes/xmlparserv2-904.jar;/classes/
versioninfo.jar;/classes/share.jar;/classes/
jewt4.jar;/classes/jdbc12.jar;/classes/
i18nAPI_v3.jar;/classes/collections.jar;/classes/
bipres.jar;/classes/bicmn.jar;/classes/
siebel.jar;/classes/XSLFunctions.jar;/classes/
SiebelCustomXMLP.jar;/classes/SiebelCustomXMLP_SIA.jar

Through SRVRMGR : FROM CMD ->SIEBSRVR->BIN->SRVRMGR /g SERVERIP /e ENTERPRISE /u SADMIN /P SADMIN
change param CLASSPATH=SIEBSRVR_ROOT\classes\SiebelXMLP.jar;SIEBSRVR_ROOT\classes\
xdoparser.jar;SIEBSRVR_ROOT\classes\fix6312772.jar;SIEBSRVR_ROOT\classes\
xdocore.jar;SIEBSRVR_ROOT\classes\xmlparserv2-904.jar;SIEBSRVR_ROOT\classes\
versioninfo.jar;SIEBSRVR_ROOT\classes\share.jar;SIEBSRVR_ROOT\classes\jewt4.jar;
SIEBSRVR_ROOT\classes\jdbc12.jar;SIEBSRVR_ROOT\classes\i18nAPI_v3.jar;
SIEBSRVR_ROOT\classesvcollections.jar;SIEBSRVR_ROOT\classes\bipres.jar;
SIEBSRVR_ROOT\classes\bicmn.jar;SIEBSRVR_ROOT\classes\Siebel.jar;
SIEBSRVR_ROOT\classes\XSLFunctions.jar;SIEBSRVR_ROOT\classes\SiebelCustomXMLP.jar
for named subsystem XMLPJvmSubsys

9. Configuring the Outbound Web Service for the Oracle BI Publisher Server

• Using your browser, enter the following URL to retrieve the Web service definition.
http://:/xmlpserver/services/PublicReportService_v11?wsdl
• Save the definition as PublicReportService_v11.WSDL.
• Using Siebel Tools, delete the PublicReportService outbound Web service and related integration objects
• In Siebel Tools, choose File, New Objects, the EAI tab, Web Service, and then click OK.
• Check the Deploy Integration Object(s) and Proxy Business Service(s) checkbox, and then click Finish.
• Administration - Web Services screen, then the Outbound Web Services view
• Note : Typically, there is no need to change this address because it is automatically populated when you configure the business service and Web service in Siebel Tools using the Web service wizard.

10. Creating Views
• Navigate to the Administration - Application screen ->Views.
• In the Views list, create the following new views, and complete the necessary fields:
• Report Job List View
• All Report Output List View
• All Template View
• Manager's Report Output List View
• Manager's Template View
• My Template View
• Report Standard Template Registration Admin View

11. Create the following new responsibilities
• XMLP_ADMIN Administrator role for the Oracle BI Publisher Server with no
access limitations.
• XMLP_DEVELOPER Assign this responsibility to allow for uploading reports from the Oracle BI Publisher Server to the Siebel application.
• XMLP_SCHEDULER Assign this responsibility to allow for scheduling of reports.
• XMLP_SIEBEL_GUEST Assign this responsibility to limit access to reports. This responsibility only allows for generation, viewing, and deletion of user’s own reports.

12. Associate the new views with the appropriate responsibility as shown in
the following table.
View Responsibility
• Report Job List View ->XMLP_SCHEDULER
• All Report Output List View ->XMLP_ADMIN
• All Template View ->XMLP_ADMIN
• Manager's Report Output List View -> XMLP_ADMIN
• Manager's Template View -> XMLP_ADMIN
• My Template View -> XMLP_ADMIN
• Report Standard Template Registration Admin View -> XMLP_ADMIN



13. Process of Authenticating User Access to the Oracle BI Publisher Server
• Import and administer the Web service used by the Siebel Security Model by doing the following:
• Navigate to the Administration - Web Services screen, then the Inbound Web Services view.
• Import the BIPSiebelSecurityWS.XML file from the SIEBEL_TOOLS_ROOT\REPPATCH directory
(where Siebel Tools is installed).
• In the Address field of the Service Ports subview, replace the existing address with the URL used to access the EAI Object Manager.
• Address:http://SIEBELSERVERIP/eai_enu/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute

14. Create Super User -> Go to BIP Server->Admin->Security Configuration

Security Model section choose Siebel Security Model from the Security Model drop down List

Parameter Value
Security Model:Siebel Security
Siebel Web Service Endpoint:http://SIEBELSERVERIP /eai_enu/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute
Administrator Username: SADMIN
Administrator Password: administrator password

Log in to the Oracle BI Publisher Enterprise application using the Siebel administrator credentials entered.

15. Click the Admin tab, select Roles and Permissions (in the Security Center section), and then add SiebelCRMReports folder to the following roles:
• XMLP_ADMIN
• XMLP_SCHEDULER
• XMLP_DEVELOPER
• XMLP_SIEBEL_GUEST

16. Create New Template Using:
• Import the XML Data source from Data in Word.
• Create From or table and insert the field.
• Save as .rtf.
• Go Tool ->Translate Template-> Extract Text
• Save as xlf.
• Go to Export and convert it to XLFo Style Sheet and save as .xls.
• Export both .xlf, xls and rtf to respective folder of Server_root/xmlp/XMLP/xlif , Server_root/xmlp/XMLP/Template

17. To upload pre configured report layout templates to the Oracle BI Publisher Server
• Administration - BI Publisher Reports screen, then the Reports – Standard Templates view.
• From the application-level menu, select Edit, and then Select All.
• Click Upload Files.

Changing the Password for the Siebel Administrator Database Account

Use the following procedure to modify the password for the Siebel administrator database account. You must also change the corresponding password parameter for the Siebel Enterprise and change the password in the Windows Registry.

To change the password for the Siebel administrator database account

Change the Siebel administrator's password for the Enterprise as follows:
Log into a Siebel employee application, such as Siebel Call Center.
Navigate to Administration - Server Configuration, and then Enterprises.
Click the Parameters tab.
In the Enterprise Parameters list, select the Password parameter.
In the Value field, enter the new password, then commit the record.
Log out of the Siebel application (all users must log out).
Change the Siebel administrator's password in the database.
For more information, refer to your RDBMS documentation on changing passwords.

Change the Siebel administrator's password in the Windows registry of each Siebel Server in your Siebel Enterprise as follows:
Make a copy of the Siebel Gateway Name Server parameters file, siebns.dat, located in the Admin folder of the Gateway Name Server root directory.
Edit the copy of siebns.dat using a text editor, and locate the new encrypted Siebel administrator password by navigating to the entry similar to the following:
[/enterprises/EnterpriseName/parameters/Password]
Persistence=full
Type=string
Value="9HtkUOUf"
Length=16

The Value parameter contains the new encrypted Siebel administrator password.

In the Windows Registry, navigate to the following entry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\siebsrvr_EnterpriseName_SiebelServerName

where EnterpriseName is the name of your Siebel Enterprise and SiebelServerName is the name of the Siebel Server.

Right-click ImagePath, and select Modify.
The ImagePath value is shown.

Change the old encrypted password listed (the value following the -ep flag) with the new Siebel administrator password you located in the siebns.dat file in Step b):
C:\sia81\siebsrvr\bin\siebsvc -s siebsrvr -i siebel_siebel -a "-g localhost:2320 -e siebel -s siebel -l ENU -u SADMIN -ep 9ntkUOUf" -t 120 -h C:\sia81\siebsrvr

CAUTION: Changing the Windows Registry can corrupt the Windows Registry file and require a reinstallation of the operating system. Take care when modifying the Windows Registry, therefore, and ensure you have a backup copy of the Windows Registry file.

Stop and restart the Siebel Server system service.

go to SWEApp/bin and open eapps.cfg
change anon user password if anon user is same as sadmin.
If password is encrypted go to cmd prompt
C:\sba81\gtwysrvr\BIN>encryptstring newpassword >string.txt
then copy encrypted password from string.txt to eapps.config anon password.
do iisreset

Siebel - Unlock Repository Objects Using Database Queries

UNLOCK REPOSITORY OBJECTS

VIEW
UPDATE SIEBEL.S_VIEW BC SET BC.OBJ_LOCKED_FLG = 'N', BC.OBJ_LOCKED_DATE = NULL, BC.OBJ_LOCKED_BY = NULL, BC.OBJ_LOCKED_LANG = NULL
WHERE BC.ROW_ID = ‘1-CDGI-1MIPC’;
COMMIT;

TABLE
UPDATE SIEBEL.S_TABLE TAB SET TAB.OBJ_LOCKED_FLG = 'N', TAB.OBJ_LOCKED_DATE = NULL, TAB.OBJ_LOCKED_BY = NULL, TAB.OBJ_LOCKED_LANG = NULL
WHERE TAB.NAME = ‘S_APPLICATION’
AND TAB.ROW_ID = '1-CDGI-E5E5';
COMMIT;

BUSCOMP
UPDATE SIEBEL.S_BUSCOMP BC SET BC.OBJ_LOCKED_FLG = 'N', BC.OBJ_LOCKED_DATE = NULL, BC.OBJ_LOCKED_BY = NULL, BC.OBJ_LOCKED_LANG = NULL
WHERE BC.ROW_ID = ‘1-CDGI-CD6C’;
COMMIT;

BUSSERVICE
UPDATE SIEBEL.S_SERVICE SERV SET SERV.OBJ_LOCKED_FLG = 'N', SERV.OBJ_LOCKED_DATE = NULL, SERV.OBJ_LOCKED_BY = NULL, SERV.OBJ_LOCKED_LANG = NULL
WHERE SERV.ROW_ID = '1-CDGI-1I9E2';
COMMIT;

APPLET
UPDATE SIEBEL.S_APPLET APPL SET APPL.OBJ_LOCKED_FLG = 'N', APPL.OBJ_LOCKED_DATE = NULL, APPL.OBJ_LOCKED_BY = NULL, APPL.OBJ_LOCKED_LANG = NULL
WHERE APPL.ROW_ID = '1-CDGI-D8I';
COMMIT;

PROJECT
UPDATE SIEBEL.S_PROJECT AS PROJ SET PROJ.LOCKED_FLG = 'N', PROJ.LOCKED_DATE = NULL
WHERE PROJ.NAME = 'Account Hierarchy';
COMMIT;

Note:-
How to find out the row id of any object?
Go to Siebel tools
Select object(Applet/BC/View) -> Help -> About Record -> Details
Row# will give the Row Id details.

WC2011 Final @ Wankhede Stadium

Winning moments of Cricket World Cup 2011 captured by me @ Wankhede Stadium!