Search Results sy_purg_mst




Overview
Explore in AI Chat

Overview

The SY_PURG_MST table is a core data repository within the Oracle Process Manufacturing (OPM) module of Oracle E-Business Suite (EBS), specifically under the GMA (Process Manufacturing Systems) product family. It serves as the master audit and control table for the OPM archival and purge processes. When data is archived or purged from operational tables in OPM—a critical activity for managing database size and performance—a master record of each execution is created in SY_PURG_MST. This table provides a historical log and reference point for all such data management operations, enabling traceability and auditability.

Key Information Stored

The table's primary purpose is to store metadata about each purge or archive run. Its structure is centered on a unique identifier for each execution. The most critical column is PURGE_ID, which serves as the primary key (SY_PURG_MST_PK) and uniquely identifies a specific purge session. Other significant columns, as indicated by the foreign key relationships, include PURGE_TYPE, which links to the SY_PURG_DEF table to define the kind of purge performed, and TEXT_CODE, which links to the SY_TEXT_HDR table, likely storing descriptive notes or a name for the purge run. Collectively, these columns store essential execution details such as the purge definition used, start and completion timestamps, status, and the user who initiated the process.

Common Use Cases and Queries

This table is primarily used for administrative reporting and troubleshooting. Database administrators and functional consultants query SY_PURG_MST to audit purge history, verify successful completions, and investigate failed jobs. A common query involves joining with related log and error tables to get a full picture of a purge execution. For example, to review recent purge activities, one might use a query pattern such as:

  • SELECT p.purge_id, p.creation_date, d.purge_name, p.status FROM gma.sy_purg_mst p, gma.sy_purg_def d WHERE p.purge_type = d.purge_type ORDER BY p.creation_date DESC;

Another critical use case is diagnosing purge failures by linking the master record in SY_PURG_MST to detailed error messages in the SY_PURG_ERR table using the PURGE_ID foreign key.

Related Objects

SY_PURG_MST is the central node in a network of related purge control tables. It has a direct foreign key relationship with SY_PURG_DEF (via PURGE_TYPE) and SY_TEXT_HDR (via TEXT_CODE). Furthermore, several detail tables reference it via the PURGE_ID column, forming a master-detail relationship. These include:

  • SY_PURG_ERR: Stores specific error records generated during a purge session.
  • SY_PURG_LOG: Contains detailed procedural log entries for a purge session.
  • SY_PURG_MST_CRIT: Likely stores the specific runtime criteria or parameters used for a particular purge execution.

This structure ensures that all data related to a single archival or purge operation is systematically linked back to its master control record in SY_PURG_MST.