Search Results op_audt_mst




Overview
Explore in AI Chat

Overview

The OP_AUDT_MST table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It functions as a master audit header table, specifically designed to track and manage changes made to sales order detail lines. Its primary role is to establish a centralized audit trail by serving as a parent record that links together all individual change transactions (detailed in the related OP_AUDT_DTL table) for a given modification event. This structure is critical for maintaining data integrity, supporting compliance requirements, and enabling historical analysis of order line modifications throughout the order lifecycle in a process manufacturing environment.

Key Information Stored

The table's structure is centered on uniquely identifying a change order event and linking it to the original sales order. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its essential data elements. The CHANGEORDER_ID column serves as the primary key, uniquely identifying each audit header record. The ORDER_ID column is a foreign key that links the change order back to its source sales order in the OP_ORDR_HDR table. This establishes the foundational relationship between an audit trail and the business document it tracks. Additional columns likely store metadata about the change event, such as creation date, the user who initiated the change, and a status or description of the overall modification.

Common Use Cases and Queries

A primary use case is generating a complete audit report for changes to a specific sales order line. This involves joining the master header to the detail lines to present a chronological log. Another common scenario is analyzing the frequency and nature of order modifications for process improvement or compliance audits. A typical query pattern retrieves all change orders for a given sales order:

  • SELECT mst.CHANGEORDER_ID, mst.ORDER_ID, dtl.* FROM GML.OP_AUDT_MST mst JOIN GML.OP_AUDT_DTL dtl ON mst.CHANGEORDER_ID = dtl.CHANGEORDER_ID WHERE mst.ORDER_ID = <order_number> ORDER BY dtl.CREATION_DATE;

Database administrators may also query the table to monitor its growth or as part of data archival strategies for historical audit information.

Related Objects

The OP_AUDT_MST table is integral to the GML audit framework, with defined relationships to other key tables. The following documented foreign key relationships are central to its function:

  • OP_ORDR_HDR: The OP_AUDT_MST.ORDER_ID column references this table, linking each change order header to its parent sales order header.
  • OP_AUDT_DTL: This detail table holds the individual change records. Its CHANGEORDER_ID column is a foreign key referencing OP_AUDT_MST.CHANGEORDER_ID, creating a one-to-many relationship where one master header record can have many associated detail lines documenting specific field-level changes.

These relationships ensure that every tracked modification is correctly associated with both the original sales order and its comprehensive set of detailed transactional changes.