Results for “gr_document_headings”

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

Overview

GR_DOCUMENT_HEADINGS is a table in the GR (Process Manufacturing Regulatory Management) product schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the headings and subheadings that are linked to a regulatory document, forming the structural skeleton that determines how a document's content is organized and rendered. Each row associates a document with a main heading and, optionally, a subheading, together with sequencing information that drives display order. The table therefore acts as the assembly point where document definitions meet the reusable heading and subheading catalogs maintained elsewhere in the GR schema.

The ETRM relationship metadata classifies this table as satellite-leaning under a heuristic Data Vault model. This is a modeling suggestion rather than a physical designation: the table carries descriptive attributes (display order, audit columns) attached to a parent document context, with foreign keys resolving to reference and code tables. Modelers treating GR_DOCUMENT_HEADINGS as a satellite would typically anchor it to a document hub represented by GR_DOCUMENT_CODES.

Key Information Stored

The table comprises 11 documented columns. The most significant are:

• DOCUMENT_HEADINGS_SEQNO — the surrogate primary key, enforced by the GR_DOCUMENT_HEADINGS_PK unique index. This column is also the target of the foreign key from GR_DOCUMENT_STRUCTURES, making it the principal join key for downstream structural data. Applications and queries that reference a specific heading assignment use this sequence value.
• DOCUMENT_CODE — identifies the parent document; foreign key to GR_DOCUMENT_CODES.
• MAIN_HEADING_CODE — the main heading applied to the document; foreign key to GR_MAIN_HEADINGS_B.
• MAIN_DISPLAY_ORDER — numeric ordering that positions the main heading within the document.
• SUB_HEADING_CODE — the subheading linked beneath the main heading; foreign key to GR_SUB_HEADINGS_B.
• SUB_DISPLAY_ORDER — numeric ordering for the subheading relative to its parent heading.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns recording row creation and modification metadata.

The only documented unique index is GR_DOCUMENT_HEADINGS_PK on DOCUMENT_HEADINGS_SEQNO, so the sequence number is the sole documented business-key candidate; no alternate unique constraint on the document/heading combination is documented in the available metadata.

Common Use Cases and Queries

Typical usage centers on reconstructing a document's table of contents, validating heading assignments, and joining heading structures to document content. A representative query resolves the full heading structure for a document:

• SELECT dh.DOCUMENT_HEADINGS_SEQNO, dh.DOCUMENT_CODE, mh.HEADING_NAME, dh.MAIN_DISPLAY_ORDER, sh.SUB_HEADING_NAME, dh.SUB_DISPLAY_ORDER FROM GR.GR_DOCUMENT_HEADINGS dh, GR.GR_MAIN_HEADINGS_B mh, GR.GR_SUB_HEADINGS_B sh WHERE dh.MAIN_HEADING_CODE = mh.MAIN_HEADING_CODE AND dh.SUB_HEADING_CODE = sh.SUB_HEADING_CODE AND dh.DOCUMENT_CODE = :document_code ORDER BY dh.MAIN_DISPLAY_ORDER, dh.SUB_DISPLAY_ORDER;
• Listing all heading rows joined to structures via DOCUMENT_HEADINGS_SEQNO to produce the complete document layout.
• Auditing recently changed heading assignments using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Detecting orphaned or duplicate display orders within a document by grouping on DOCUMENT_CODE and the display order columns.

Related Objects

• GR_DOCUMENT_CODES — parent document definition; joined on DOCUMENT_CODE.
• GR_MAIN_HEADINGS_B — main heading catalog; joined on MAIN_HEADING_CODE.
• GR_SUB_HEADINGS_B — subheading catalog; joined on SUB_HEADING_CODE.
• GR_DOCUMENT_STRUCTURES — child structure table referencing DOCUMENT_HEADINGS_SEQNO; joined on that column to retrieve structural detail for each heading assignment.

Together these objects form the GR document composition model, with GR_DOCUMENT_HEADINGS serving as the linking assignment between documents and the heading hierarchies that describe them.