Results for “okc_section_contents_h”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_SECTION_CONTENTS_H is the history (audit) table for OKC_SECTION_CONTENTS within the OKC – Contracts Core module of Oracle E-Business Suite. In Oracle EBS 12.1.1 and 12.2.2, contract authoring relies on OKE/OKC structures in which a contract is decomposed into sections, and each section is populated by one or more content rows. OKC_SECTION_CONTENTS holds the current state of those content rows — the clauses, variables, text fragments and other elements attached to a contract section — while OKC_SECTION_CONTENTS_H retains the prior and alternate versions of the same records, keyed by a major version number. The table therefore supports version tracking, audit reconstruction, and the comparison of contract text across revisions. The object is owned by the OKC schema and is reported as VALID.
From a heuristic Data Vault modeling perspective, the mined foreign-key structure classifies this object as standalone, with no downward dependent references. In practice it behaves as a versioned satellite carrying descriptive content attributes, with the combination of ID and MAJOR_VERSION acting as the effective key of each historical row rather than the two-part primary key of the base table alone.
Key Information Stored
The table contains 31 documented columns. The most significant are:
- ID – Surrogate identifier of the section content row, inherited from OKC_SECTION_CONTENTS.
- MAJOR_VERSION – Version discriminator that distinguishes successive historical states of the same content row. ID and MAJOR_VERSION together form the primary key OKC_SECTION_CONTENTS_H_PK.
- SCN_ID – Identifier of the parent contract section to which the content belongs; combined with MAJOR_VERSION and CONTENT_SEQUENCE it forms unique index OKC_SECTION_CONTENTS_H_U2, a documented business-key candidate.
- CONTENT_SEQUENCE – Ordering sequence of the content entry within the section, relevant for rendering contract text in the correct order.
- LABEL – Display label of the content element.
- CAT_ID – Foreign key to BEN_TCS_CAT, indicating the content catalog/category classification.
- CLE_ID – Reference to the clause library element associated with the content.
- SAE_ID – Reference to the standard/ad hoc element that supplies the underlying text or variable definition.
- OBJECT_VERSION_NUMBER – Optimistic locking column used by the OAF/BC4J framework to detect concurrent updates.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 – The standard Oracle EBS descriptive flexfield (DFF) segment set, available for customer-defined content attributes.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns.
- SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or operating-unit security partitioning.
The primary key OKC_SECTION_CONTENTS_H_PK (ID, MAJOR_VERSION) is the surrogate key, while OKC_SECTION_CONTENTS_H_U1 (ID, MAJOR_VERSION) and OKC_SECTION_CONTENTS_H_U2 (SCN_ID, MAJOR_VERSION, CONTENT_SEQUENCE) are the documented unique indexes that serve as business-key candidates.
Common Use Cases and Queries
Typical uses include reconstructing the text of a contract section as of a given revision, auditing which clause or catalog element was present at a specific version, and reporting on the evolution of contract content over time. A common pattern joins the history table to its base table and to the parent section:
- Retrieve all versions of a section's content:
SELECT * FROM okc_section_contents_h WHERE scn_id = :section_id ORDER BY major_version, content_sequence; - Locate the version active at a point in time by comparing LAST_UPDATE_DATE or MAJOR_VERSION.
- Diff two versions of the same content row by selecting both rows for a given ID and comparing LABEL, CAT_ID, CLE_ID and SAE_ID.
- Report clause usage across contracts by joining CLE_ID to the clause library and CAT_ID to BEN_TCS_CAT.
- Filter by SECURITY_GROUP_ID when the deployment relies on operating-unit security.
Related Objects
- OKC_SECTION_CONTENTS – The base table whose historical images this table stores; join on ID (and version logic).
- OKC_SECTIONS (SCN_ID) – Parent contract section; join via SCN_ID.
- BEN_TCS_CAT – Referenced through CAT_ID, providing the content category.
- FND_SECURITY_GROUPS – Referenced through SECURITY_GROUP_ID for security partitioning.
- OKC_CLAUSE_LIBRARY / clause library elements – Referenced through CLE_ID.
- Standard/ad hoc element definitions – Referenced through SAE_ID.
- OKC_CONTRACTS and OKC_SECTION_DEFINITIONS – Ancillary parent objects reached through SCN_ID.
-
History table for OKC_SECTION_CONTENTS
-
History table for OKC_SECTION_CONTENTS
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - OKC Tables and Views 12.1.1
Intersection entity between templates and rules.
-
eTRM - OKC Tables and Views 12.2.2
Intersection entity between rules and templates
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - OKC Tables and Views 12.2.2
Intersection entity between rules and templates
-
eTRM - OKC Tables and Views 12.1.1
Intersection entity between templates and rules.