Search Results gr_document_print




Overview
Explore in AI Chat

Overview

The GR_DOCUMENT_PRINT table is a core data object within Oracle E-Business Suite Process Manufacturing Regulatory Management (GR). It serves as the central repository for managing the print status and metadata of regulatory documents. Its primary role is to track the generation and printing of documents—such as Material Safety Data Sheets (MSDS) or product labels—that are mandated by regulatory bodies. The table uniquely identifies each printed document instance by associating it with a specific Item Code, Document Code, and Date, thereby creating a verifiable audit trail of compliance documentation produced for products.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which dictate the critical data points it stores. The primary key is DOCUMENT_TEXT_ID, a unique identifier for each printed document record. Essential foreign key columns, which define the context of the print, include ITEM_CODE (linking to the specific product in GR_ITEM_GENERAL), DOCUMENT_CODE (defining the document type from GR_DOCUMENT_CODES), and LANGUAGE (from FND_LANGUAGES). Furthermore, the table stores regulatory context through DISCLOSURE_CODE_COUNTRY and DISCLOSURE_CODE_RECIPIENT, which link to the GR_DISCLOSURES table to specify the applicable regulatory rules based on destination country and recipient type.

Common Use Cases and Queries

A primary use case is generating a compliance report of all MSDS documents printed for a specific product within a date range. Another is auditing document dispatch history to prove regulatory adherence for a shipment. Common SQL queries involve joining to related item and document tables to produce human-readable reports.

  • Print History by Item: SELECT gdp.document_text_id, gdp.print_date, ig.item_code, dc.document_name FROM gr_document_print gdp, gr_item_general ig, gr_document_codes dc WHERE gdp.item_code = ig.item_code AND gdp.document_code = dc.document_code AND ig.item_code = 'ITEM123' ORDER BY gdp.print_date DESC;
  • Document Details for a Specific Print: Queries often join to GR_DOCUMENT_DETAILS using the DOCUMENT_TEXT_ID to retrieve the full document text or formatting instructions associated with a print record.

Related Objects

The GR_DOCUMENT_PRINT table is a central hub within the Regulatory Management schema, with documented relationships to several key tables.

  • GR_DOCUMENT_CODES: Joined via GR_DOCUMENT_PRINT.DOCUMENT_CODE to define the type of document (e.g., MSDS, Label).
  • GR_ITEM_GENERAL: Joined via GR_DOCUMENT_PRINT.ITEM_CODE to identify the product for which the document was printed.
  • FND_LANGUAGES: Joined via GR_DOCUMENT_PRINT.LANGUAGE to specify the print language.
  • GR_DISCLOSURES (Two Relationships): Joined via DISCLOSURE_CODE_COUNTRY and DISCLOSURE_CODE_RECIPIENT to apply the correct regulatory disclosure rules.
  • GR_DOCUMENT_DETAILS: Has a foreign key (GR_DOCUMENT_DETAILS.DOCUMENT_TEXT_ID) referencing this table, storing the detailed content for each print record.
  • GR_DISPATCH_HISTORIES: Has a foreign key (GR_DISPATCH_HISTORIES.DOCUMENT_TEXT_ID) referencing this table, linking printed documents to specific shipment or dispatch events.