Results for “okc_subclass_top_line”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_SUBCLASS_TOP_LINE is a reference table in the OKC (Contracts Core) schema of Oracle E-Business Suite, present and valid in releases 12.1.1 and 12.2.2. Its documented purpose is to associate a subclass with a top line in a line style hierarchy. In practical terms, the table records which top-level line style (LSE_ID from OKC_LINE_STYLES_B) is permitted or expected for a given contract subclass (SCS_CODE from OKC_SUBCLASSES_B). This mapping drives the behavior of the Contract Terms and Renewals Management (formerly the Oracle Contracts) line generation framework, where subclasses such as warranty, subscription, or service lines inherit structural rules from a designated top line style.
The ETRM metadata classifies this object heuristically as a link table in Data Vault terms. That classification is consistent with its structure: the composite primary key is composed entirely of foreign keys pointing to two distinct hubs (subclasses and line styles), and the table carries descriptive and auditing attributes but no independent natural business identity of its own.
Key Information Stored
The documented physical schema in 12.2.2 contains 13 columns. The most significant are:
- SCS_CODE — the subclass code, joining to OKC_SUBCLASSES_B. Part of the composite primary key.
- LSE_ID — the line style identifier, joining to OKC_LINE_STYLES_B. The other component of the primary key.
- START_DATE and END_DATE — effective dating that governs when a subclass-to-top-line association is active.
- OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF-based contracts UI to detect concurrent updates.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit who-columns populated by the framework.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org or data-security partitioning.
- ACCESS_LEVEL — controls visibility for restricted-access reference data.
- ZD_EDITION_NAME — a presence-edition column associated with Oracle's edition-based redefinition strategy in 12.2.x.
The surrogate primary key is OKC_SUBCLASS_TOP_LINE_PK, defined over (SCS_CODE, LSE_ID). The unique index OKC_SUBCLASS_TOP_LINE_U1 extends this to (SCS_CODE, LSE_ID, ZD_EDITION_NAME), confirming the business-key candidate and accommodating editioning.
Common Use Cases and Queries
Typical usage centers on validating and reporting line style hierarchies. A common query joins the mapping table to its parent tables to produce a readable lineage:
- Resolve top lines for a subclass:
SELECT lst.* FROM okc_line_styles_b lst JOIN okc_subclass_top_line t ON lst.lse_id = t.lse_id WHERE t.scs_code = :subclass AND SYSDATE BETWEEN t.start_date AND NVL(t.end_date, SYSDATE); - Audit active mappings: filter on
START_DATE/END_DATEto identify associations currently in force versus historical ones. - Diagnostic reporting: identify subclasses lacking a mapped top line, which can explain line generation failures during contract authoring.
- Migration and data cleanup: comparing
SECURITY_GROUP_IDvalues helps reconcile reference data after multi-org or instance migrations.
Related Objects
The principal related objects derive from the documented foreign keys and primary key relationships:
- OKC_LINE_STYLES_B — parent of the
LSE_IDforeign key; defines line styles. - OKC_SUBCLASSES_B — parent of the
SCS_CODEforeign key; defines contract subclasses. - FND_SECURITY_GROUPS — referenced by
SECURITY_GROUP_IDfor data partitioning. - OKC_LINE_STYLES_TL and OKC_SUBCLASSES_TL — translation tables used to render descriptive names in reports.
- OKC_TERMS_LINES — contract line instances whose top line style is ultimately seeded from this mapping.
- OKC_CONTRACTS / OKC_CONTRACT_LINES — contract headers and lines consuming subclass-driven line rules.
Because the table is a pure mapping construct, most integration occurs via joins rather than direct DML; changes are typically made through setup configuration or the contracts administration UI.
-
Associates a subclass with a top line in a line style hierarchy.
-
Associates a subclass with a top line in a line style hierarchy.
-
View for table OKC_SUB_CLASS_TOP_LINE
APPS.OKC_SUBCLASS_TOP_LINE_V·↳ OKC_SUBCLASS_TOP_LINE·Explore OKC module →
-
View for table OKC_SUB_CLASS_TOP_LINE
APPS.OKC_SUBCLASS_TOP_LINE_V·↳ OKC_SUBCLASS_TOP_LINE·Explore OKC module →