Results for “cs_csz_srch_result_cols”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_CSZ_SRCH_RESULT_COLS is a Service (CS) module table in the Oracle E-Business Suite database, owned by the CS schema. It stores the metadata describing the result columns returned by a Saved Search definition. In the Service application, saved searches allow users to define reusable query criteria and to control which attributes are displayed in the results grid. Each row of CS_CSZ_SRCH_RESULT_COLS represents one displayable attribute participating in a given saved search, together with its sequence position and the identifier of the attribute group to which it belongs. The table is therefore a configuration and presentation-layer object rather than a transactional one.

From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification. The table carries a composite key anchored to its parent search definition, holds descriptive and ordering attributes, and does not itself reference other business entities beyond its parent. It is best understood as an attribute satellite hanging off the saved search hub.

Key Information Stored

The table is documented with eleven columns. The primary key constraint, CS_CSZ_SRCH_RESULT_COLS_PK, is defined over SEARCH_ID and ATTR_SEQ, a composite key combining the parent search identifier with the ordinal position of the column within the result layout. A unique index, CS_CSZ_SRCH_RESULT_COLS_U1, covers the same column pair (SEARCH_ID, ATTR_SEQ), confirming the business key.

• SEARCH_ID — Foreign key to CS_CSZ_SEARCHES; identifies the parent saved search whose result columns are being configured.
• ATTR_SEQ — Sequence number establishing the display order of the column within the result set; part of the composite primary key.
• ATTR_ID — Identifier of the attribute (field or entity attribute) selected as a result column.
• ATTR_GROUP_ID — Identifier of the attribute group to which the selected attribute belongs, used to organize result columns by logical grouping.
• ATTR_TYPE — Classifies the nature of the attribute, allowing the search framework to interpret and render the column correctly.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework to detect concurrent updates.
• CREATION_DATE / CREATED_BY — Audit columns recording when and by whom the result-column definition was created.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Audit columns capturing the most recent modification and the login session responsible for it.

The audit and versioning columns follow standard EBS conventions and are populated automatically by the framework rather than by user action.

Common Use Cases and Queries

Typical usage centers on reviewing or troubleshooting saved search configurations, particularly when a user reports that a field is missing from, or appears in the wrong position within, a search result grid. A representative query retrieves the ordered column layout for a specific search:

• SELECT SEARCH_ID, ATTR_SEQ, ATTR_ID, ATTR_GROUP_ID, ATTR_TYPE FROM CS_CSZ_SRCH_RESULT_COLS WHERE SEARCH_ID = :p_search_id ORDER BY ATTR_SEQ;
• Joining to CS_CSZ_SEARCHES to list the search name alongside its configured result columns for administrative reporting.
• Aggregating counts by ATTR_GROUP_ID to verify that each attribute group contributes the expected number of columns.
• Auditing rows by CREATED_BY or LAST_UPDATED_BY to determine who altered a shared or public saved search definition.

Because the table is configuration data, reporting is generally read-only; changes are normally made through the Service application's saved search maintenance screens rather than by direct DML.

Related Objects

The relationships are anchored on the SEARCH_ID foreign key and the surrogate composite key.

• CS_CSZ_SEARCHES — Parent table; joined on CS_CSZ_SRCH_RESULT_COLS.SEARCH_ID = CS_CSZ_SEARCHES.SEARCH_ID. It holds the saved search header and is the primary dependency for this object.
• CS_CSZ_SRCH_RESULT_COLS_PK — Primary key constraint on (SEARCH_ID, ATTR_SEQ).
• CS_CSZ_SRCH_RESULT_COLS_U1 — Unique index on (SEARCH_ID, ATTR_SEQ), enforcing the business key.
• Attribute-definition and attribute-group tables within the CS schema are referenced logically through ATTR_ID and ATTR_GROUP_ID, though no enforced foreign keys to them are documented in the ETRM metadata.

Together with the parent search header, CS_CSZ_SRCH_RESULT_COLS completes the definition of a saved search's output shape in the Oracle Service module.