Search Results gr_dispatch_histories_pk




Overview
Explore in AI Chat

Overview

The GR_DISPATCH_HISTORIES table is a core data repository within the Oracle E-Business Suite Process Manufacturing Regulatory Management (GR) module. Its primary function is to serve as a detailed audit log for the dispatch and receipt of regulated documents, most notably Material Safety Data Sheets (MSDS). This table is critical for compliance tracking, providing a verifiable history of what information was sent, to which recipient, and at what specific time. It enables organizations to demonstrate adherence to regulatory requirements by maintaining a permanent record of document distribution activities, which is essential in industries governed by health, safety, and environmental regulations.

Key Information Stored

The table's structure is designed to link key regulatory entities through foreign key relationships. The primary columns, which also form the composite primary key (GR_DISPATCH_HISTORIES_PK), are DOCUMENT_CODE, DOCUMENT_TEXT_ID, ITEM_CODE, and RECIPIENT_CODE. These fields respectively identify the type of document dispatched, the specific instance or version of that document, the regulated item or material involved, and the entity that received the document. A crucial audit column is DATE_MSDS_SENT, which records the precise timestamp when the document was dispatched. Together, these columns create an immutable record of each unique dispatch transaction.

Common Use Cases and Queries

A primary use case is generating compliance reports for internal audits or regulatory inspections. Organizations frequently need to prove that MSDS for hazardous materials were provided to customers or downstream facilities upon shipment. Common queries include listing all dispatches for a specific item within a date range, identifying all recipients of a particular document version, or verifying the dispatch history for a specific customer. A typical reporting query would be:

  • SELECT d.recipient_code, r.recipient_name, d.item_code, d.date_msds_sent FROM gr_dispatch_histories d, gr_recipient_info r WHERE d.recipient_code = r.recipient_code AND d.item_code = '&ITEM' AND d.date_msds_sent BETWEEN :p_start_date AND :p_end_date ORDER BY d.date_msds_sent DESC;

This table is also integral to processes that re-print or re-send historical documents, as it holds the definitive record of what was originally communicated.

Related Objects

GR_DISPATCH_HISTORIES is centrally linked to several master tables in the GR schema, as defined by its foreign key constraints. The DOCUMENT_CODE column references GR_DOCUMENT_CODES, which classifies document types. DOCUMENT_TEXT_ID links to GR_DOCUMENT_PRINT, which stores the actual printable text or content of the document. ITEM_CODE references GR_ITEM_GENERAL, the master table of regulated items or materials. Finally, RECIPIENT_CODE references GR_RECIPIENT_INFO, the master table for entities like customers or sites that receive regulated documents. This network of relationships ensures data integrity and provides a complete context for each dispatch record.