Results for “okc_lse_rule_groups”

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

Overview

OKC_LSE_RULE_GROUPS is a Contracts Core (OKC) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that maps rule groups to contract line styles. It answers a fundamental question in the Contracts authoring model: given a particular line style (for example, a service line, an item line, or a warranty line), which sets of business rules must be applied to a contract line that uses that style? Each row establishes an association between a line style, identified by LSE_ID, and a subclass rule group definition, identified by SRD_ID. The table therefore acts as the junction that binds the Contracts rule engine to the line style setup used by the Contract Terms Library.

From a Data Vault modeling perspective, the FK structure suggests this object is satellite-leaning: it is a dependent, descriptive structure keyed by the parent line style and rule group references rather than a standalone hub. The presence of the ZD_EDITION_NAME column and the OKC_LSE_RULE_GROUPS_U1 unique index (LSE_ID, SRD_ID, ZD_EDITION_NAME) indicates support for the editioning model introduced in later 12.2.x releases.

Key Information Stored

• LSE_ID — Foreign key to OKC_LINE_STYLES_B; identifies the contract line style to which the rule group applies. Part of the composite primary key OKC_LSE_RULE_GROUPS_PK.
• SRD_ID — Foreign key to OKC_SUBCLASS_RG_DEFS; identifies the subclass rule group definition. The second component of the primary key.
• ZD_EDITION_NAME — Edition discriminator supporting edition-enabled (ZD) objects in 12.2.x; combined with LSE_ID and SRD_ID it forms the business-key unique index OKC_LSE_RULE_GROUPS_U1.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications Framework (OAF) to detect concurrent updates.
• CREATED_BY / CREATION_DATE and LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard WHO audit columns recording row creation and last modification.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used for multi-org / data security partitioning.
• ACCESS_LEVEL — Reserved access control column maintained by the framework.

The surrogate primary key is the two-column composite OKC_LSE_RULE_GROUPS_PK (LSE_ID, SRD_ID); the editioning column extends the natural business key in 12.2.x. Rows carry no significant descriptive payload of their own—they are purely relationship records.

Common Use Cases and Queries

The principal use case is diagnosing which rule groups are associated with a line style, either during setup validation or when troubleshooting why certain terms and rules do not appear on a contract line. The following query lists all rule groups for a given line style:

• SELECT rg.lse_id, rg.srd_id, ls.name line_style, srd.name rule_group FROM okc_lse_rule_groups rg, okc_line_styles_b ls, okc_subclass_rg_defs srd WHERE rg.lse_id = ls.lse_id AND rg.srd_id = srd.srd_id AND rg.lse_id = :lse_id;
• A reverse lookup identifies every line style that uses a particular rule group, useful when a rule group change has broad impact: filter on srd_id.
• Reporting queries joining to OKL_OPT_RULES on (LRG_LSE_ID, LRG_SRD_ID) reveal which option rules are governed by a given line-style / rule-group combination.
• Data migration or setup comparison scripts count rows per LSE_ID across environments, or compare ZD_EDITION_NAME values between 12.1.1 (where the column may be absent) and 12.2.2.

Related Objects

• OKC_LINE_STYLES_B — parent table; joined on LSE_ID.
• OKC_SUBCLASS_RG_DEFS — parent table; joined on SRD_ID.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for data security.
• OKL_OPT_RULES — the only documented child, referencing this table via LRG_LSE_ID and LRG_SRD_ID; relevant for lease/option rule configuration.
• Contract Terms Library rule engine components and the OAF-based Line Styles setup UI consume this table indirectly when rendering available rule groups per line style.