Oracle Siebel 简易部署手册

Siebel CRM SmartScriptSiebel SmartScript is a powerful, flexible tool that provides a workflow-based, dynamic user interface that guides a user on the web or an agent in a Call Center through a guided sequence of steps. It combines setting a workflow process with a dynamically generated user interface to offer information on a “just in time” basis. It can be used for automating a wide variety of tasks including diagnostic Q&A for problem resolution, call scripting for telemarketers, or needs analysis for product recommendations systems. SmartScripts can be easily constructed using a drag-and-drop interface to build questions, text, and branches. All questions are reusable, and the same script can be deployed across HTML pages on different browsers and devices. Scripts can be continually refined without programming.S I E B E L S M A R T S C R I P TK E Y F E A T U R E S∙Dynamic agent desktop with “just in time” question-answer interface∙Dynamically generate questions based on branching logic∙Visual representation of question sequence to agents to allow easy traversing of the script ∙Group related questions using page sections ∙Flexibility to branch from any question to any other question in Smart Script Player∙Drag-and-drop flowchart UI for administering SmartScripts without programming∙Support extending scripts with Siebel VB and eScript∙Reusability of SmartScript pages and questions across multiple scripts∙Simple deployment of scripts in multiple languages without changing the script structure∙Save & Resume Capability for multi session interactions Dynamically Generated UI Ensures The Quality Of Each Customer InteractionSiebel SmartScript provides a dynamic desktop with a question-answer interface where the next question asked may be determined by answers given on prior questions. Branching logic can be easily built so that questions that prompt the agent are generated dynamically to guide the agent through the interaction. Agents can view and navigate to related questions, which are displayed and grouped as Pages. Agents easily navigate through the SmartScript sequentially, by following the question order, or through a treecontrol where they can directly jump to a particular question.Reduce Training Time and Increase ProductivitySmartScripts incorporate elements that are of tremendous use by inexperienced and experienced agents. Instead of navigating through unfamiliar and sometimes complex screens, agents will be prompted with the next question based on previous answers and a set workflow. Agents will not be required to remember what and how to ask question. They instead will be provided with the exact wording and answer options for every question. Once the business analysts design the SmartScript, it can be immediately deployed to the call center or to the Web.Integrate Sales and ServiceSiebel SmartScript can be designed to incorporate rules for cross-selling or up-selling. Based on answers provided by a customer over the phone, SmartScript can prompt the agent to inquire about other product or service options. In addition, the sales effectiveness of different approaches can be tested out and refined using SmartScript. Sales per agent can be continually improved using different word phrasings or question sequences.Deploy SmartScripts Over The WebSiebel SmartScript allows call centers to deploy across HTML on the web. With the deployment capability of “create once, deploy everywhere, the same administration and same SmartScripts can be used for both call center and Web. In order to improve the ease of using scripts on the web, all of the questions from the SmartScript that don’t require a branch will be displayed at once so it is not necessary to constantly refresh the HTML page. The next set of questions will be displayed based on how the user answers the last question.Graphically Design And Modify Call Scripts Without Technical ExpertiseSiebel SmartScript uses a graphical, simple, drag-and-drop user interface that allows visualization of the structure of a script. Users simply add new pages or questions through this interface and drag branches between them to create the sequence logic. Instead of requiring weeks or months of IT or engineering time to build a script, SmartScripts can be built at the business analyst level in a fraction of the time. Changing SmartScript structure can be done using the same flowchart UI, allowing continuous improvements to productivity.Easily Deploy Multilingual SmartScriptAny number of translations of SmartScripts can be built just by translating the question and answer strings with the Siebel Administration screen. Once the structure of the SmartScript is built, then it is not necessary to alter it for additional languages. Once a question is translated, since it is reusable across multiple scripts, the task of translating multiple scripts is considerably reduced. When agents run a script, they can choose which language they want to run it in. Alternatively, a question in the script can be used to invoke the proper language in the SmartScript.Leverage the power of Siebel Products with SmartScriptSiebel SmartScript is fully integrated into Siebel Applications. Siebel CTI can be used to capture information about a call, start a SmartScript, and use this CTI information in the SmartScript. Assignment Manager can be used to assign tasks created in a SmartScript and then return that information to SmartScript. Siebel’s knowledgebase of Decision Issues and Solutions can be effectively used to build a dynamic troubleshooting script. SmartScript can capture information about a user, which can then be passed to the Siebel Product Configurator to make product suggestions.C O N T A CFor more information about Siebel CRM, visit or call +1.800.ORACLE1 to speak to an Oraclerepresentative.C O N N E C T W I T H U S/oracle /oracle /oracle Copyright © 2014, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and。

日出东方CRM项目客户端程序安装操作文档操作手册作者:HAND创建日期:2014-9-26最后更新日期:2014-9-26版本：V1.0编写说明系统用户通过IE浏览器的方式进行系统首次登陆时需要安装Siebel HighInteractivity Framework插件，以保证系统的正常使用。

本操作文档主要针对上述插件安装的流程进行详细说明，包含以下几个部分：•信任站点设置：叙述在IE浏览器端将系统加入信任站点，以保证插件可正常下载•浏览器设置：叙述如何设置以保证系统界面可以正常使用•插件安装流程：叙述首次登陆用户如何安装插件•常见问题解决：叙述在插件安装过程中可能遇到的一些常见问题及解决办法使用对象全体用户Contents编写说明 (ii)使用对象 (ii)CRM主系统-信任站点的设置 (1)流程描述 (1)操作说明 (1)操作过程 (1)CRM主系统-针对IE8或更高版本的兼容性设置 (9)流程描述 (9)操作说明 (9)操作过程 (9)CRM主系统-选项卡设置 (11)流程描述 (11)操作说明 (11)操作过程 (11)CRM主系统-浏览器插件的下载 (14)流程描述 (14)操作说明 (14)操作过程 (14)Reip中CRM账号维护 (19)业务简述 (19)操作说明 (19)操作过程 (19)CRM主系统用户密码修改 (21)流程描述 (21)操作说明 (21)操作过程 (21)CRM门户系统用户密码修改 (23)流程描述 (23)操作说明 (23)操作过程 (23)录入用户名及密码，并点击常见问题及解决办法 (27)⏹无法登陆到系统操作页面 (27)⏹无法添加系统网址至“可信网站”列表 (28)⏹无法进入或点击Siebel系统的菜单栏选项的问题 (28)⏹无法看到系统登陆页面或其他登入、下载插件的问题 (29)CRM主系统登录-信任站点的设置流程描述1. 需使用IE8浏览器，将正式环境地址加入IE浏览器的信任站点中，并将安全等级设置为“低”操作说明操作过程1．首次访问系统登陆界面及网址记录•首次进入登陆界面•正式环境网址：/2．添加网址至可信任的站点•选择，IE浏览器菜单上的“工具——>Internet选项”•选择，IE点击“安全”选项卡，选择“受信任的站点”•点击“站点”按钮，弹出安全站点添加界面•在“将该网站添加到区域中”下的录入框中填入刚刚记录下的网址，并将下方的“对该区域中的所有站点要求服务器验证(http: ）”的选项去掉•点击“添加”，将键入的网址添加到可信站点的“网站”列表中•点击“确定”按钮，添加可信站点的操作完毕3．更改可信任站点的安全性设置•点击“自定义级别”按钮，弹出“受信任的站点区域对话框”•将“重置为”选择为“安全级–低”•检查“下载未签名的ActiveX控件”是否选为“启用”，若为“禁用”请选为“启用”•检查“文件下载自动提示”是否为“启用”，若为“禁用”请选为“启用”•点击“确定”按钮•返回登陆页面，查看右下角的状态栏，如果前述设置正确，网站状态为“可信站点”CRM主系统登录-针对IE8或更高版本的兼容性设置流程描述1. 对兼容性视图进行设置操作说明操作过程1．进入“兼容性视图设置”界面•在IE的命令栏中选择“页面”选项，在下拉菜单中选择“兼容性视图设置”，进入“兼容性视图设置”界面2．对兼容性视图进行设置•在“兼容性视图设置”界面中，勾选“在兼容性视图中显示所有网站”选项CRM主系统登录-选项卡设置流程描述1. 对选项卡进行设置操作说明操作过程1．进入“Internet选项”设置界面•打开IE浏览器。

Oracle 10g RAC for AIX6.1硬件环境：2台IBM P520 服务器，2台光纤交换机，1台IBM DS4700磁盘阵列（1.2TB）软件环境： Oracle 10g R2 （需升级到10.2.0.4）， AIX6.11.IP规划:racdb1 公网：172.16.28.31VIP：172.16.28.33心跳: 192.168.100.1racdb2 公网: 172.16.28.32VIP: 172.16.28.34心跳：192.168.100.22.需要的软件包：bos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsxlC.aix61.rte:9.0.0.1xlC.rte:9.0.0.1通过lslpp -l bos.adt.base 查看软件包是否已安装# lslpp -l bos.adt.baseFileset Level State Description---------------------------------------------------------------------------- Path: /usr/lib/objreposbos.adt.base 6.1.3.0 COMMITTED Base Application Development Toolkit需要的补丁:由于此次项目的系统是最新的AIX6.1，无法在网上确切查询到所需要的正确补丁，所以在安装过程中遇到很多问题，最终安装了p6613550_10203_AIX64-5L、p8705958_10204_AIX5L(CRS PSU补丁,解决升级后VIP起不来BUG)3.通过命令“# chfs -a size=30G /”调整文件系统，结果如下：# df -gFilesystem GB blocks Free %Used Iused %Iused Mounted on/dev/hd4 30.00 29.79 1% 13717 1% //dev/hd2 10.00 8.03 20% 45904 3% /usr/dev/hd9var 10.00 9.76 3% 7296 1% /var/dev/hd3 8.00 7.67 5% 608 1% /tmp/dev/fwdump 5.00 5.00 1% 4 1% /var/adm/ras/platform /dev/hd1 30.00 11.28 63% 53931 2% /home/dev/hd11admin 2.00 2.00 1% 5 1% /admin/proc - - - - - /proc/dev/hd10opt 10.00 9.54 5% 9610 1% /opt/dev/livedump 5.00 5.00 1% 4 1% /var/adm/ras/livedump /dev/lv00 0.25 0.24 4% 18 1% /var/adm/csd/dev/fslv00 0.25 0.25 1% 8 1% /audit4.在2个节点上分别建立oinstall、dba、hagsuser组，Oracle用户，并保持组ID和用户ID相同# smitty group# smitty user：Primary GROUP 为“oinstall”，Group SET 为“dba”和“hagsuser”改为“-1”（无限制）5.编辑/etc/hosts文件，添加以下内容：172.16.28.31 racdb1192.168.100.1 racdb1-priv172.16.28.33 racdb1-vip172.16.28.32 racdb2192.168.100.2 racdb2-priv172.16.28.34 racdb2-vip6.配置系统参数，配置每用户的最大进程数，调整water mark# smitty chgsys7.存储划分asm 400G hdisk4vote 2G hdisk5ocr 2G hdisk6arch 200G hdisk7# lspvhdisk0 00cbc154bde9ce42 rootvg active hdisk1 00cbc1a4cb987b44 rootvg active hdisk2 none Nonehdisk3 none Nonehdisk4 none Nonehdisk5 none Nonehdisk6 none Nonehdisk7 none None# cd /dev# chown root:oinstall hdisk6# chown oracle:oinstall hdisk4 hdisk5# chmod 664 hdisk4 hdisk5 hdisk6# chown root:oinstall rhdisk6# chown oracle:oinstall rhdisk4 rhdisk5# chmod 664 rhdisk4 rhdisk5 rhdisk68.配置.rhosts文件，用于节点间的通信认证和加密# cd /home/oracle# mkdir .rhosts# vi .rhostsracdb1 oracleracdb2 oracleracdb1-priv oracleracdb2-priv oracleracdb1-vip oracleracdb2-vip oracle9.配置NTP服务，用于2个节点的时间同步用date命令调整时间至1000秒以内，如果2个节点时间相差多于1000秒，NTP服务会失败如date 0508013030 表示 5月8日1点30分30秒racdb1# vi /etc/ntp.confbroadcastclientserver 127.127.1.0 (添加)driftfile /etc/ntp.drifttracefile /etc/ntp.trace# startsrc -s xntpdracdb2# vi/etc/ntp.confbroadcastclientserver 172.16.28.31 (添加)driftfile /etc/ntp.drifttracefile /etc/ntp.trace# startsrc -s xntpd10.配置环境变量# cd /home/oracle# vi .profileORACLE_BASE=/home/oracleexport ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0.1/racdbexport ORACLE_HOMEORACLE_CRS_HOME=$ORACLE_BASE/product/10.2.0.1/crsexport ORACLE_CRS_HOMEORACLE_SID=rac1export ORACLE_SIDORACLE_TERM=xtermexport ORACLE_TERMNLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport NLS_LANGLD_LIBRARY_PATH=$ORACLE_CRS_HOME/lib:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/l ibexport LD_LIBRARY_PATHPATH=$PATH:$ORACLE_HOME/bin:$ORACLE_CRS_HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/uc b:$HOME/bin:/usr/bin/X11:/sbin:.export PATH11.打补丁p6718715_10203_AIX64-5L.zip，然后以root用户执行补丁6718715里面的rootpre.sh文件；再用oracle用户执行CRS安装程序./runInstaller点击Next点击Next选择CRS安装的目录/home/oracle/product/10.2.0.1/crs，点击Nextoracle进行系统参数检查无问题，点击Next添加Cluster中两个节点及相关的公网、私网、VIP网络名称，点击Next选择ocr文件的位置为/dev/hdisk6，点击Next选择voting disk的位置为/dev/hdisk5，点击Next执行安装至完成。

Learn more from Oracle University at/education/Siebel T ools Rel 15.5Student Guide | Volume ID70458GC20Edition 2.0 |May 2016 | D94391Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Disclaimer This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle. The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free. Restricted Rights NoticeIf this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable:U.S. GOVERNMENT RIGHTSThe U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract.Trademark NoticeOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.AuthorCustomer Experience (CX)Curriculum DevelopmentTechnical Contributorand ReviewerCustomer Experience (CX)Product DevelopmentTeamPublishersJayanthy KeshavamurthyRaghunath MContents1 Siebel Tools: Course IntroductionLesson Agenda 1-2Instructor and Class Participants 1-3Training Site Information 1-4Course Audience 1-5Course Prerequisites 1-6Course Goal 1-7Course Objectives 1-8Course Methodology 1-9Course Materials 1-10Information Sources 1-11Course Agenda 1-122 Configuring a Siebel ApplicationObjectives 2-2Siebel Customer Relationship Management (CRM) 2-3 Siebel CRM Applications 2-4Comparison of Siebel CRM Applications 2-5Configuring a Siebel Application 2-6Siebel Tools 2-7The Repository and Siebel Tools 2-8Siebel Repository File 2-9Object Definitions 2-10User Interface Layer 2-12Tailoring the Logical User Interface 2-13Business Layer 2-14Tailoring the Business Layer 2-15Data Layer 2-16Extending the Data Layer 2-17Basic Configuration Steps 2-18Create or Edit Object Definitions 2-19Compile the Edited Object Definitions 2-20Test the Modifications 2-21Lesson Highlights 2-22Practices 2-233 Using a Local Development EnvironmentObjectives 3-2Siebel Application Development 3-3Create a Separate Development Environment 3-4 Creating a Local Developer: Overview 3-5Repositories 3-6Develop on the Local Repository 3-7Projects 3-8Assigning Object Definitions to Projects 3-9Viewing Object Definitions by Project 3-10Check Out/Check In Mechanisms 3-11Copying Projects 3-12Getting Projects 3-13Checking Out a Project 3-14Check Out a Project 3-15Checking In a Project 3-16Check In a Project 3-17Canceling Check Out 3-18Project Differences 3-19Undoing a Check Out 3-20Undo Check Out 3-21Object Check Out/Check In (COCI) 3-22Checking Out an Object 3-23Using Object COCI 3-24Disabling Object COCI 3-25Creating New Projects 3-26Create a New Project 3-27Locking Projects 3-28Locking Projects Locally 3-29Do Not Lock Projects on the Server 3-30Developing a Proof of Concept 3-31Lesson Highlights 3-32Practice 3-334 Editing and Compiling Object DefinitionsObjectives 4-2Editing An Object Definition 4-3Creating a New Object Definition 4-4Symbolic Strings 4-5Using Symbolic Strings 4-6Changed Flag 4-7Validation 4-8Validating an Object Definition 4-9Compiling 4-10Compiling Projects 4-11Compiling Object Definitions 4-12Rapid Unit Testing 4-13Auto-starting the Web Client 4-14Debug Settings 4-15Basic Configuration Strategy 4-16Recommendations: Object Definitions 4-17 Recommendations: Projects 4-18Lesson Highlights 4-19Practices 4-205 Managing Object DefinitionsObjectives 5-2Archiving Object Definitions 5-3Exporting Object Definitions 5-4Importing Object Definitions 5-5Conflict Resolution 5-6Resolve Import Conflicts 5-7Importing Multiple Archive Files 5-8Source Code Control Integration 5-9Backing Up 5-10Comparing Object Definitions 5-11Compare Objects 5-12Inspect Differences 5-13Compare Two Object Definitions 5-14Inspect Differences 5-15Planning 5-16Implementing 5-17Lesson Highlights 5-18Practice 5-196 Siebel Web TemplatesObjectives 6-2Siebel Web Template Files 6-3Siebel Tags 6-4Web Template Explorer 6-5Siebel Web Template Files 6-6Siebel Open UI Web Template Files 6-7Configure Siebel Tools to use Open UI Web Templates 6-8 Cascading Style Sheets (.css files) 6-9Using Web Template Files 6-10Web Template Object Definition 6-11Types of Web Templates 6-12Form Applet Web Templates 6-13List Applet Web Templates 6-14Applet Web Templates 6-15View Web Templates 6-16Web Page Web Templates 6-17Container Page 6-18Working with Web Templates 6-19Assigning a Web Template to a View 6-20Example: Assigning a Web Template to a View 6-21Assigning Components in a View or Applet 6-22Mapping Information 6-23Example: Assigning Applets in a View 6-24View Web Template Items 6-25Summary of Object Types 6-26Lesson Highlights 6-27Practice 6-287 Configuring Form AppletsObjectives 7-2Applet 7-3Common Applet Types 7-4Applet Properties 7-5Editing Properties 7-6Controls for Form Applets 7-7Expanding and Collapsing Form Applets 7-8Control Object Definitions 7-9Web Templates for Form Applets 7-10Grid Layout Editor 7-12Grid Layout Editor: Additional Operations 7-13Web Controls Palette 7-14Creating a Form Applet 7-15Form Applet Wizard Inputs 7-16Form Applet Wizard 7-17Grid Layout Editor 7-18Show More Mode 7-19Enabling Show More 7-20Summary of Object Types 7-21Lesson Highlights 7-22Practice 7-238 Configuring List AppletsObjectives 8-2List Applets 8-3List Object Definition 8-5List Column Object Definitions 8-6Control Object Definitions 8-7List Applet Web Templates 8-8List Applet Modes 8-9Base and Edit Modes 8-10Applet Web Layout Editor 8-11Show in List Property 8-12Number of Rows Displayed 8-13Show More Button 8-14Creating a List Applet 8-15List Applet Wizard Inputs 8-16List Applet Wizard 8-17Web Layout Editor 8-18Applet Web Template 8-19List Column Definitions 8-20Summary of Object Types 8-21Lesson Highlights 8-22Practice 8-239 Configuring ViewsObjectives 9-2View 9-3View Web Templates 9-4Applets in View Web Templates 9-5Identifying the View Web Template 9-6Identifying Applets Assigned to a View 9-7 Web Layout Editor 9-8Preview Mode 9-9Creating a View 9-10Inputs for the View Wizard 9-11View Wizard 9-12Web Layout Editor 9-13Adjust the Applet Mode 9-14Additional Steps After Configuring a New View 9-15 Administering a New View in the Client 9-161. Register the View 9-172. Assign the View to a Responsibility 9-18Summary of Object Types 9-19Lesson Highlights 9-20Practice 9-2110 Configuring Applications and ScreensObjectives 10-2Application 10-3The Container Page 10-4Acknowledgement Web Page/View 10-5Additional Web Pages 10-6Application-Level Menus 10-7Toolbars 10-8Toolbars for an Application 10-9Screen Tabs 10-10Site Map Links 10-11Screens and Views 10-12Views for a Screen 10-13Screen View Types and Categories 10-14Aggregate Category 10-15Aggregate View 10-16Detail Category 10-17Detail View 10-18Assigning a View to a Screen 10-19Specifying the Default View for a Screen 10-20Summary of Object Types 10-21Lesson Highlights 10-22Practices 10-2311 Business Components and JoinsObjectives 11-2Business Components 11-3Business Component (BC) 11-4Business Component Properties 11-5Base Table 11-6SVFs That Map to a Base Table 11-7Mapping a Field to a Column in a Base Table 11-8Type Property for Fields 11-9Default Single Value Fields 11-10Joined Tables 11-11Joining Data from Related Tables 11-12Explicit Join 11-13Join Definition 11-14Outer Join Flag 11-15Outer Join Example 11-16Join Specification 11-17Fields That Map to a Joined Table 11-18Mapping a Field to a Column in a Joined Table 11-191. Determine if a Join Definition Already Exists 11-202. Create a Join 11-213. Create the Single Value Field 11-221:1 Extension Table 11-23Implicit Joins 11-25SVFs That Map to an Extension Table 11-26Creating a New Business Component 11-27Business Component Wizard Inputs 11-28Business Component Wizard 11-29Configuring a New Business Component 11-30Summary of Object Types 11-31Lesson Highlights 11-32Practice 11-3312 Party Business ComponentsObjectives 12-2Party Data 12-3Party Business Components 12-4S_PARTY 12-5Benefits of the Party Data Model 12-6Commonly Used Party Business Components 12-7S_PARTY and Its Extension Tables 12-8Person-Related Party Business Components 12-9Organization-Related Party Business Components 12-11 Party Business Components for Access Control 12-13Groupings for Access Control 12-14S_PARTY_PER 12-15Role of Joins in Party Data 12-16Mapping Fields in Party Business Components 12-17Joining Party Data Into a Business Component 12-18Explicit Join Definition 12-19Joining Party Data into a Party Business Component 12-20 Explicit Join Definition 12-21Mapping a Field to a Column in a Party Table 12-22Creating a Join to a Party Table 12-23Create the Single-Value Field 12-24Key Considerations for Party Joins 12-25Lesson Highlights 12-26Practice 12-2713 Business Components and FieldsObjectives 13-2Business Component Properties 13-3Business Component Editing Properties 13-4Applet Editing Properties 13-5Owner Delete Property 13-6Search Specification Property 13-7Search Specification Considerations 13-8Sort Specification Property 13-9Expression Builder 13-10Business Component Field Properties 13-11Required and Read Only Properties 13-12Force Case Property 13-13Validation Property 13-14Validation Message 13-15Displaying A Validation Message 13-16Predefault Value Property 13-17Post Default Value Property 13-18Calculated Field 13-19Calculated Value Property 13-20Restrictions on Calculated Fields 13-21Lesson Highlights 13-22Practice 13-2314 Business Objects and LinksObjectives 14-2Business Objects (BOs) 14-3Business Object Definition 14-5Business Object Component 14-6Link Definition 14-71:M Link Definition 14-8Cascade Delete Property 14-9M:M Link Definition 14-11Child Deletion for M:M Links 14-12Grandchild Business Components 14-13Links for Grandchild Data 14-14Summary of Object Types 14-15Lesson Highlights 14-16Practice 14-1715 Creating a New Business Component Using a Standard 1:M Extension TableObjectives 15-2Business Challenge 15-3Solution: Create New Business Components 15-4Review: 1:M Extension Table 15-5Create a New Business Component 15-7New 1:M Business Component 15-8Multiple Business Components 15-9Set Values for Type 15-10Steps to Use the New BC 15-111. Create a Link 15-122. Add BC to a Business Object 15-133. Create a List Applet 15-144. Assign the Applet to a View 15-15Lesson Highlights 15-16Practices 15-1716 Extending the Siebel DatabaseObjectives 16-2Incorporating Additional Data 16-3Adding New Fields 16-4Extending the Siebel Database 16-5Creating a Custom Extension Column 16-6Creating a Stand-Alone Table 16-7Table Wizard 16-8Creating a 1:1 Extension Table 16-9Creating a 1:M Extension Table 16-11Creating an Intersection Table 16-13Creating Foreign Keys 16-15Propagating Database Changes to Other Developers 16-161. Apply Changes to the Local Database 16-172. Propagate Changes to Server Database 16-183. Propagate Changes to Other Developers 16-19Lesson Highlights 16-20Practices 16-2117 Additional Data Layer ConfigurationObjectives 17-2Additional Considerations 17-3Custom Indexes 17-4Creating a Custom Index 17-5Enterprise Integration Manager (EIM) 17-6EIM Mappings 17-7Dock Objects 17-8Types of Dock Objects 17-9Dock Object Visibility Rules 17-10Modifying Dock Objects 17-11Extending a Table to Support Case Insensitive Queries 17-12Creating CIAI 17-13CIAI Wizard 17-14Lesson Highlights 17-15Practices 17-1618 Configuring Drilldowns and Applet TogglesObjectives 18-2Navigation Using Drilldown 18-3Static Drilldown: Same Business Component 18-4Configuring Drilldown Within the Same Business Component 18-5 Static Drilldown: Different Business Component 18-6Configuring Drilldown to a Different Business Component 18-7Dynamic Drilldown 18-8Determining the Target View 18-9Configuring Dynamic Drilldown 18-10Specifying the Conditions 18-11Thread Bar 18-12Configuring the Thread Bar 18-13Applet Toggles 18-14Configuring Applet Toggles 18-15Togglebar Tag 18-16Dynamic Applet Toggling 18-17Configuring Dynamic Applet Toggling 18-19Lesson Highlights 18-20Practice 18-2119 Configuring PicklistsObjectives 19-2Picklists 19-3Static Picklist 19-4Static PickList Values 19-5Administering Static Picklists 19-6Administering Static Picklists Using Siebel Tools 19-7 Dynamic Picklist 19-8Picklist Terms 19-9PickList Generic Business Component 19-10Object Definitions for PickLists 19-11PickList Object Definition 19-12Single Value Field and SVF Pick Map 19-13SVF Pick Maps 19-14Pick Applet 19-15Control and List Column 19-16Creating a Picklist 19-17Pick List Wizard Inputs for Static Picklists 19-18Defining the Static Picklist 19-19Pick List Wizard 19-20Pick List Wizard Inputs for Dynamic Picklists 19-21Defining the Dynamic Picklist 19-22Defining the Pick Maps 19-23Pick List Wizard 19-24Constrained Picklist 19-25Constraining a Picklist 19-26Hierarchical Picklists 19-27LOVs for Hierarchical Picklists 19-28Configuring a Hierarchical Picklist 19-29Configuring the SVF Pick Maps 19-30Summary of Object Types 19-31Lesson Highlights 19-32Practice 19-3320 Configuring Multi-Value GroupsObjectives 20-2Multi-Value Group (MVG) 20-3Shuttle Applet 20-4Multi-Value Group Display 20-5MVG Advantages 20-6MVG Concepts 20-7Multi Value Field (MVF) 20-8Multi Value Link 20-9Multi Value Fields and Multi Value Links 20-10Multi-Value Group Applet 20-11Association Applet 20-12Invoking the MVG Applet 20-13Primaries 20-14Primaries and Performance 20-15Primary Foreign Key 20-17Finding the Primary Foreign Key 20-18Enabling a Primary for a MVG 20-19The Auto Primary Property 20-20Setting the Primary Record 20-21Creating a Multi-Value Group 20-22MVG Wizard Inputs 20-23MVG Wizard 20-24Summary of Object Types 20-25Lesson Highlights 20-26Practice 20-2721 Configuring Access ControlObjectives 21-2Access Control: Review 21-3Business Components and Record-Level Access Control 21-4 Visibility Views 21-5View Modes 21-6Configuring Visibility Views 21-7BusComp View Mode Definition 21-8Personal View 21-9My View 21-10Retrieving My View Records 21-11My Team’s (Manager) View 21-12Retrieving My Team's Records 21-13All View 21-14Retrieving Records for an All View 21-15Across All Organizations View 21-16Administration View 21-17Group View 21-18Private Flag 21-19View Web Template Item Applet Visibility 21-20Visibility For Picklists 21-21Picklist Visibility 21-22Visibility for an Individual Picklist 21-23Lesson Highlights 21-24Practice 21-2522 Configuring User PropertiesObjectives 22-2User Properties 22-3Object Definitions with User Properties 22-4User Properties 22-5Editing User Properties 22-6Expression Editor 22-7Multiple Instances of a User Property 22-8Examples of Applet User Properties 22-9DefaultFocus_New 22-10NoDataHide 22-11EnableDragAndDropInList 22-12Examples of Business Component User Properties 22-14 All Mode Sort 22-15BC Read Only Field 22-16On Field Update Set 22-17Parent Read Only Field 22-18Field Read Only Field 22-19Disable Automatic Trailing Wildcard Field List 22-20Required (Field User Property) 22-21Lesson Highlights 22-22Practice 22-2323 Migrating Repository ChangesObjectives 23-2Multiple Enterprises 23-3Migrating Between Enterprises 23-4Items to Be Migrated 23-5Repository Object Definitions 23-6Name of the Repository 23-7References to the Name of the Repository 23-8Files 23-9Customized Data 23-10Overview of the Migration Process 23-11Benefits of the Process 23-12Prepare the Development Enterprise 23-13Prepare the Target Enterprise 23-14Migrate the Repository to the Target Enterprise 23-15 If Necessary, Rename the Repositories 23-16Migrate Files and Customized User Data 23-17Repository Customizations 23-18Siebel Enterprise Parameters 23-19Lesson Highlights 23-20Practice: 23-2124 TroubleshootingObjectives 24-2Common Mistakes 24-3Tools Mistakes 24-4Compilation Mistakes 24-5Administration Mistakes 24-6Testing Mistakes 24-7Common Configuration Problems 24-8User Interface Layer 24-9Business Layer 24-11Data Layer 24-13Diagnosing Problems 24-14Create a File to Capture SQL 24-15Turn on SQL Spooling 24-16Have a Fallback 24-18Do Not Configure on the Server 24-19Lesson Highlights 24-20Practice 24-21。

ORACLE数据库部署手册1.Oracle简介Oracle Database，又名Oracle RDBMS，或简称Oracle。

是甲骨文公司的一款关系数据库管理系统。

它是在数据库领域一直处于领先地位的产品。

可以说Oracle数据库系统是目前世界上流行的关系数据库管理系统，系统可移植性好、使用方便、功能强，适用于各类大、中、小、微机环境。

它是一种高效率、可靠性好的适应高吞吐量的数据库解决方案。

2.Oracle安装医院部署数据库要求使用Oracle 11G R2（64Bit）正版数据库，建议使用医院采购的正版oracle11g数据库软件。

本文档详细介绍Oracle11gR2的安装步骤、常用服务、日常使用等。

本文档主要介绍Oracle11gR2数据库的安装步骤，关于不同应用程序的具体数据库配置，则在对应的应用程序的产品手册中详细描述。

2.1.安装环境的要求2.2.安装步骤1)运行安装文件打开安装包后，双击setup.exe文件;稍等片刻后，出现如下所示的安装界面；如下图1所示：图 12)配置安全更新等oracle安装程序启动以后，第二步就进入了【配置安全更新】环节，这一步可将自己的电子信息填写进去点击“下一步”；如下图2所示：图 23)选择安装选项安装选项有三种选择：新部署数据库时选择“创建和配置数据库”，点击下一步；当安装完毕数据库管理软件后，系统会自动创建一个数据库实例，点击“下一步”；如下图3所示：图 34)系统类选项设置进入“系统类选项设置”，系统类选项设置分为桌面类和服务器类两种；如下图4所示：桌面类：使用桌面类系统安装。

使用WINDOWS系统则使用此类典型安装。

服务器类：适合linux服务器环境下的高级安装。

图 45)典型安装配置选择桌面类之后，默认为典型安装，填写完成后，点击“下一步”继续；如下图5所示：Oracle基目录：目录路径不要含有中文或其它的特殊字符软件位置：也即是实例存储的目录数据库文件位置：放置数据库文件的位置数据库版本：这里选择使用企业版字符集：选择默认值ZHS16GBK字符集（此处字符集一定要选择这个）全局数据库名称（即实例名称）和口令：全局数据库名（数据库名称）：orcl，管理口令（密码）：根据需要设置注：此处实例名称和口令十分重要（相当于SQL数据库的登录名和密码），请单独记录保存。

Siebel实用工具软件用户手册汉得信息技术股份有限公司版本号：V1.0 Beta版序言Siebel实用小工具是基于基于Microsoft .NET Framework开发的一个小软件,目的在于提高日常项目实施中的工作效率,避免一些重复性的劳动.其主要功能有：对文本的各种简单处理，最常用的有，对数据进行OR连接，可以方便的实现在siebel应用的查询，对数据进行sql中in字句的连接，可以方便的将数据插入到sql的语句中。

对文本进行按照给定数据的拆分，以及替换，使用非常方便快捷。

对文本进行查重、去重、对比等各种功能。

对剪贴板进行监控，可以方便的获取数据，方便的生成ldap的ldif文件、db的sql脚本等可以按照模板发送邮件等，可以用在期初上线发送用户名以及密码给客户。

可以获取数据库中的eScript脚本第一章软件安装与初始化Siebel实用小工具是一个免安装工具，双击运行目录下的Siebel实用工具.exe即可运行。

但是前提是您的电脑中安装有Microsoft .NET Framework，否则程序无法打开启动页面，可能会报如下错误：/downloads/zh-cn/details.aspx?FamilyID=39C8B6 3B-F64B-4B68-A774-B64ED0C32AE7可通过以上地址下载安装Microsoft .NET Framework。

若可以成功打开，则能看到如下界面：第二章操作说明2.1 期初配置2.2 功能说明2.2.1 文本操作2.2.2 其它操作2.1 参数配置文件在软件的目录下面有文件夹config下面对每个参数做一个简单的讲解：●emailLAddressform：用与发送邮件的时候使用，可不填写！●emailLAddressto：用与发送邮件的时候使用，可不填写！●emailLAddresspassword：用与发送邮件的时候使用，可不填写！●emailLAddresssmtp：用与发送邮件的时候使用，可不填写！●REG_HOT_KEY：用户判断是否开启注册SHIFT+X按键的热键●DEVPODBCDCN：配置一个开发环境的odbc信息，用户获取脚本时使用，可不填写●DEVPODBCDataBase配置一个开发环境的odbc信息，用户获取脚本时使用，可不填写●DEVPODBCUID配置一个开发环境的odbc信息，用户获取脚本时使用，可不填写●DEVPODBCPWD配置一个开发环境的odbc信息，用户获取脚本时使用，可不填写2.2.1 文本功能操作如图所示，在图中上方的框中随便输入一段信息，点击【使用OR连接】,可以得到以OR连接的方便siebel查询的字符串。