Search Results gma_audit_tmplt_dtl




Overview
Explore in AI Chat

Overview

The GMA_AUDIT_TMPLT_DTL table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMA) module. Its primary function is to define and store the associations between Industry Templates and Audit Groups. This relationship is fundamental to the audit functionality in Process Manufacturing, enabling the configuration of standardized audit criteria (defined in audit groups) to be linked to specific industry or operational templates. The table acts as a junction detail table, supporting the master-detail relationship with GMA_AUDIT_TMPLT_MST and providing the linkage to the underlying audit group definitions.

Key Information Stored

The table's structure is designed to uniquely identify the relationship between a template, an application, and an audit group. The critical columns are the composite primary key: TEMPLATE_NAME, AUDIT_GROUP_ID, and APPLICATION_ID. The TEMPLATE_NAME references the master template definition. The AUDIT_GROUP_ID is the key identifier for the specific set of audit criteria or questions being assigned. The APPLICATION_ID specifies the EBS application context (e.g., Process Manufacturing - GMA) for which this relationship is valid, ensuring modularity and proper data segregation within the multi-application suite.

Common Use Cases and Queries

A primary use case is retrieving all audit groups assigned to a specific industry template for review or reporting purposes. This is essential for quality management and compliance processes within manufacturing operations. System administrators may query this table to validate or modify template configurations. A typical SQL query would join GMA_AUDIT_TMPLT_DTL to GMA_AUDIT_TMPLT_MST to get template details and potentially to audit group description tables.

  • Find Audit Groups for a Template: SELECT AUDIT_GROUP_ID FROM GMA.GMA_AUDIT_TMPLT_DTL WHERE TEMPLATE_NAME = '&TEMPLATE_NAME' AND APPLICATION_ID = &APP_ID;
  • Validate Template-Group Assignment: Queries are used to ensure no duplicate or orphaned relationships exist before deploying template changes to production.
  • Reporting: The table serves as the source for reports detailing the audit coverage and structure configured for different manufacturing processes or product lines.

Related Objects

GMA_AUDIT_TMPLT_DTL has defined dependencies within the GMA schema. Its structure and integrity are maintained through these key relationships:

  • GMA_AUDIT_TMPLT_MST: This is the master table, referenced via a foreign key constraint on the TEMPLATE_NAME column. It holds the header information for the industry templates.
  • GMA_AUDIT_TMPLT_DTL_PK: The primary key constraint enforcing uniqueness on the combination of TEMPLATE_NAME, AUDIT_GROUP_ID, and APPLICATION_ID.
  • Audit Group Tables: While not explicitly named in the provided metadata, the AUDIT_GROUP_ID column logically references the master table defining audit groups (such as GMA_AUDIT_GROUPS_B), which contain the detailed audit questions and criteria.