Search Results cs_system_options_pk

Overview

CS_SYSTEM_OPTIONS is a Service (CS) module table in Oracle E-Business Suite that stores Service Security Setup information. It functions as the central configuration repository that determines how Service Request security is enforced across the applications, defining whether security rules are applied dynamically and restricting which service request types may be accessed by particular users or responsibilities. In the Oracle EBS 12.1.1 and 12.2.2 data model, the table resides in the CS schema and is classified as VALID, confirming it is an active, supported object within the shipped product.

From a data-modeling perspective, the ETRM metadata classifies this table as standalone using a heuristic Data Vault assessment mined from its foreign key structure. In Data Vault terms this would suggest treating CS_SYSTEM_OPTIONS as a reference or hub-style table rather than a transaction-bearing satellite, though its dependence on SECURITY_GROUP_ID means it also behaves as a lookup keyed to Foundation security groups. The single documented foreign key (SECURITY_GROUP_ID → FND_SECURITY_GROUPS) confirms that the setup rows are scoped to specific security groups, making the table a configuration anchor rather than a high-volume transactional entity.

Key Information Stored

The table contains 28 documented columns in the 12.2.2 physical schema. The most operationally significant columns are:

• SYSTEM_OPTION_ID — the surrogate primary key defined by the CS_SYSTEM_OPTIONS_PK constraint, uniquely identifying each setup row.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS that scopes each option record to a specific security group.
• SR_AGENT_SECURITY — governs whether agent-level security is enforced when an agent views or updates service requests.
• SR_SEC_DYNAMIC_POLICY — controls whether dynamic security policy evaluation is applied at runtime.
• SS_SRTYPE_RESTRICT — determines whether service request types are restricted for the associated security group.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle flexible attribute (DFF) columns reserved for client-specific extensions.
• OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent updates.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Oracle audit trail columns.
• ZD_EDITION_NAME — the editioning column used by the E-Business Suite online patching architecture in 12.2.x.

A unique index, CS_SYSTEM_OPTIONS_U1, is documented on (SYSTEM_OPTION_ID, ZD_EDITION_NAME). The combination of the surrogate key with the edition name is the business-key candidate for uniquely identifying a row in an editioned environment; the surrogate SYSTEM_OPTION_ID alone remains the conventional primary key.

Common Use Cases and Queries

The table is typically queried to audit or troubleshoot Service Request security behavior for a given responsibility or security group. A representative join against Foundation security groups retrieves the effective setup:

• SELECT cs.system_option_id, cs.security_group_id, cs.sr_agent_security, cs.sr_sec_dynamic_policy, cs.ss_srtype_restrict FROM cs_system_options cs, fnd_security_groups fsg WHERE cs.security_group_id = fsg.security_group_id;
• Reporting queries isolate rows where SR_SEC_DYNAMIC_POLICY is enabled to determine which responsibilities evaluate dynamic Service Request security at runtime.
• Migration and cloning diagnostics compare SECURITY_GROUP_ID values across environments to detect divergent security setups after a refresh.
• DFF-based reporting reads ATTRIBUTE_CATEGORY and the ATTRIBUTE1–15 columns for customer-specific security configuration.

Related Objects

CS_SYSTEM_OPTIONS sits upstream of several other setup tables that reference it through SYSTEM_OPTION_ID, and downstream of Foundation security groups:

• FND_SECURITY_GROUPS — referenced by CS_SYSTEM_OPTIONS.SECURITY_GROUP_ID; the parent security-group definition.
• WIP_PARAMETERS and WIP_ACCOUNTING_CLASSES — Work in Process setup tables that carry a SYSTEM_OPTION_ID pointer back to this table.
• GCS_SYSTEM_OPTIONS — an Oracle Grants/Financials setup table referencing CS_SYSTEM_OPTIONS.SYSTEM_OPTION_ID.
• FUN_SYSTEM_OPTIONS — a Financials setup table with the same referencing pattern.
• LNS_SYSTEM_OPTIONS_ALL — a Loans setup table referencing CS_SYSTEM_OPTIONS.SYSTEM_OPTION_ID.

These dependencies indicate that changes to a CS_SYSTEM_OPTIONS row can propagate to adjacent module setups, so setup changes should be tested across the affected modules before promotion to production.