Search Results gr_document_headings




Overview
Explore in AI Chat

Overview

The GR_DOCUMENT_HEADINGS table is a core data object within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as a central junction table that defines the structural hierarchy of regulatory documents. Its primary role is to manage the association between a specific regulatory document and the standardized headings and subheadings that constitute its formal structure. This table is essential for enforcing consistent document formatting and content organization, which is a critical requirement for compliance with regulatory standards in process manufacturing industries such as pharmaceuticals, food, and chemicals.

Key Information Stored

The table's primary key is a system-generated sequence number (DOCUMENT_HEADINGS_SEQNO) that uniquely identifies each heading association record. The table stores three critical foreign key references that define the relationship. The DOCUMENT_CODE column links to the GR_DOCUMENT_CODES table, identifying the specific regulatory document. The MAIN_HEADING_CODE and SUB_HEADING_CODE columns link to the GR_MAIN_HEADINGS_B and GR_SUB_HEADINGS_B tables, respectively. These columns store the codes for the primary section and the nested subsection, thereby establishing the document's outline. The combination of these keys allows the system to define a complete, ordered structure for any given document.

Common Use Cases and Queries

A primary use case is generating a document's table of contents or validating its structure against a regulatory template. For instance, to retrieve the full hierarchical structure of a specific document for a compliance report, a typical query would join through this table. Another common operational use is during document authoring, where the application uses this table to present the user with the correct headings under which to enter content. A sample query to list all headings for a document might be:

  • SELECT mh.heading_name, sh.heading_name FROM gr_document_headings dhd JOIN gr_main_headings_b mh ON dhd.main_heading_code = mh.main_heading_code LEFT JOIN gr_sub_headings_b sh ON dhd.sub_heading_code = sh.sub_heading_code WHERE dhd.document_code = '&DOC_CODE' ORDER BY dhd.document_headings_seqno;

This table is also critical for reporting on which documents contain specific regulated headings, aiding in gap analysis during audit preparations.

Related Objects

The GR_DOCUMENT_HEADINGS table sits at the center of a key data model, with defined foreign key relationships to several foundational tables. It references the following objects:

  • GR_DOCUMENT_CODES via DOCUMENT_CODE: This links the heading structure to the master definition of the regulatory document itself.
  • GR_MAIN_HEADINGS_B via MAIN_HEADING_CODE: This links to the library of allowable primary headings.
  • GR_SUB_HEADINGS_B via SUB_HEADING_CODE: This links to the library of allowable child sub-headings.

Furthermore, this table is referenced by another structure table:

  • GR_DOCUMENT_STRUCTURES references GR_DOCUMENT_HEADINGS via DOCUMENT_HEADINGS_SEQNO. This indicates that the defined heading associations are further utilized or detailed within broader document structure records.