My Oracle Support Banner

After Applying Siebel Patch From 20.5 to 21.4 Lenght Of Column S_EVT_ACT.NAME Got Changed From 1500 To 250 (Doc ID 2783890.1)

Last updated on JULY 05, 2021

Applies to:

Siebel CRM - Version 21.4 and later
Information in this document applies to any platform.

Symptoms

After applying Siebel patch version from 20.5 to 21.4 varchar length size of column "S_EVT_ACT.NAME" got changed from 1500 to 250 and an error is returned in "Activity List":

For having this environment behavior the following changes were done:

- Modify out of the box size of "S_EVT_ACT.NAME" varchar length size.

- After modifying varchar size of "S_EVT_ACT.NAME" column table apply Siebel patch from 20.5 to 21.4.

- When applying a Siebel patch it will be noticed that varchar length of "S_EVT_ACT.NAME" column table will be switched to initial size.

Note: S_EVT_ACT is a vanilla table and we do not recommended to adjust this type of tables.

Also overloading a table can cause multiple issues of the environment:

"The search specification used to type the table into various business components might cause performance problems. Often, the table is not designed to be overloaded. For example, the TODO_CD column of the S_EVT_ACT table is often used for typing the table. This table is not denormalized on to the S_ACT_EMP intersection table for activities and employees. A query that uses the sales representative visibility against a business component that references the S_EVT_ACT table might result in poor performance.

There is no guarantee that adding indexes against these type columns will resolve a performance problem because adding an index might compromise performance elsewhere. The fact that the type columns are often not denormalized onto position, employee, or organization intersection tables affects queries in certain views.

Overloading a table increases the table size."

The above chapter is also reviewed in Oracle documentation:

- https://docs.oracle.com/cd/B40099_02/books/ConfigApps/ConfigApps_Reusing_Objects5.html , "Guidelines for Overloading a Table" chapter.

Changes

Siebel 21.4 monthly update was applied on top of 20.5.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.