Bookshelf Home | Contents | Index | PDF |
Configuring Siebel Business Applications > Reusing Predefined Objects > Guidelines for Reusing a Predefined Object > Guidelines for Reusing a Predefined TableIf you must create a custom business component because no predefined business component meets your requirements, then you must decide to reuse a predefined table or to create a new table. You must only reuse a predefined table that is a suitable fit. Several reasons exist for this guideline:
If you do not reuse a table appropriately, then future reuse of that table for the original purpose of the table might be difficult. For example, assume you use the S_CALL_LST table to store data that is not related to a call list. If you later implement predefined list management, then Siebel CRM displays data that is not related to the call list in the list management views. Adding a search specification to remove this data might compromise performance, and adding an index might or might not correct this problem. For more information, see Options to Filter Data That Siebel CRM Displays In an Applet. You must not modify any repository table. If the Type property of a table is Repository, then it is a repository table. For more information, see Reusing Predefined Objects. Guidelines for Overloading a TableYou might overload a table if you reuse it multiple times on different business components, and if each business component includes a search specification in a Type field. For example, if you use the S_EVT_ACT table to store regular activities, audit logs, error logs, messages, EAI logs, and so on. If you overload a table, then to prevent Siebel CRM from display data from one business component in another business component, it is often necessary to add a search specification that queries a Type field. Overloading a table can cause the following problems:
For more information, see Options to Filter Data That Siebel CRM Displays In an Applet. Oracle Designs Some Tables to Be OverloadedOracle designs some tables in the Siebel repository to be overloaded. For example, in Siebel Industry Applications, the S_ASSET table uses the TYPE_CD column to set the type for various business components. Oracle denormalizes and indexes this column onto the S_ASSET_POSTN and S_ASSET_BU intersection tables to improve performance in SalesRep and Organization visibility views. Siebel CRM designs some XM tables, such as S_ORG_EXT_XM, to be overloaded. Guidelines for Using an Extension Table as the Base Table of a Business ComponentYou must never use an Extension or Extension (Siebel) table as the base table of a business component. Siebel Enterprise Integration Manager and Siebel Remote assume that the PAR_ROW_ID and ROW_ID columns on these tables are equivalent and that the PAR_ROW_ID column references a valid parent table record. For more information, see Extension Columns of a Siebel Table. Guidelines for Creating a New One-To-One Extension TableIn most situations, you must extend the base table or reuse an ATTRIB column on a one-to-one extension table. Rare instances exist when you must create a new one-to-one table, such as to add a LONG column because you cannot add it to a base table and because Siebel CRM supports only one LONG column on a table. For more information, see Creating a LONG Column on an Extension Table. Guidelines for Creating a New XM TableIn most situations you must reuse a predefined XM table to support a one-to-many relationship from a base table. If you use an XM table, then use the following guidelines:
For more information, see How an Extension Table Stores Custom Data. Guidelines for Using a Table That Is Not an Intersection Table to Create an IntersectionYou must reuse an intersection table only where it is a true intersection between two tables. The type of table must be Data (Intersection). Do not use a table that is not an intersection table as an intersection table only because it contains a foreign key to the table. This configuration can overload the table. For more information, see Reusing Predefined Objects. Do not use a one-to-many XM table as an intersection table. Siebel CRM does not tune an XM table for this usage, and using it as an intersection table might cause poor performance. To support one side of the relationship, you must create a custom foreign key. This configuration might cause problems with Siebel Remote and Enterprise Integration Manager. If no suitable intersection table exists between two tables and one is required, then you must configure the database. For more information, see How an Extension Table Stores Custom Data. Guidelines for Using a Table That Is Not LicensedDo not reuse an unused table that is not licensed for your configuration. Guidelines for Using the S_PARTY Table to Support a Custom Party TypeUsing a custom party type compromises access control and remote visibility. For more information, see How the S_Party Table Controls Access. |
Configuring Siebel Business Applications | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |