Search Results sy_purg_def




Overview
Explore in AI Chat

Overview

The SY_PURG_DEF table is a core data definition table within the Oracle Process Manufacturing (OPM) module of Oracle E-Business Suite (EBS), specifically under the GMA (Process Manufacturing Systems) product family. Its primary role is to serve as the master repository for purge and archive definitions. In the context of OPM, purge and archive processes are critical for managing database growth and performance by systematically removing or relocating historical transactional data based on configurable business rules. This table stores the metadata that defines these rules, acting as the control center for data lifecycle management operations within the manufacturing module.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the structure and relationships indicate the nature of the data stored. The table's primary key is the column PURGE_TYPE, which uniquely identifies each purge or archive definition. A foreign key relationship to the SY_TEXT_HDR table via a TEXT_CODE column suggests that descriptive names and detailed instructions for each purge definition are stored in a separate multi-language text table. The existence of related tables like SY_PURG_DEF_ACT (likely for actions) and SY_PURG_DEF_CRIT (likely for criteria) implies that SY_PURG_DEF holds the top-level definition, which is then further detailed by child records specifying the exact tables, conditions, and steps for the data purge or archive job.

Common Use Cases and Queries

The primary use case involves the administration and execution of data purge processes in OPM. Database administrators and functional consultants use definitions in this table to manage historical data from modules like Inventory, Costing, and Production. A common operational query would be to list all configured purge definitions for review or troubleshooting.

  • Listing All Purge Definitions: SELECT PURGE_TYPE, TEXT_CODE FROM GMA.SY_PURG_DEF ORDER BY PURGE_TYPE;
  • Finding a Specific Definition: Definitions are often referenced during the setup or analysis of a purge run. Queries typically join with SY_TEXT_HDR to get the description: SELECT d.PURGE_TYPE, t.TEXT FROM GMA.SY_PURG_DEF d, GMA.SY_TEXT_HDR t WHERE d.TEXT_CODE = t.TEXT_CODE AND t.LANG_CODE = 'US' AND d.PURGE_TYPE = '&PURGE_TYPE';

Related Objects

As per the foreign key metadata, SY_PURG_DEF is central to the purge architecture and is referenced by several key child tables:

  • SY_PURG_DEF_ACT: Likely stores the specific actions (e.g., delete, archive) and target tables for a given PURGE_TYPE.
  • SY_PURG_DEF_CRIT: Presumably holds the detailed selection criteria and parameters used to identify records for purging.
  • SY_PURG_MST: Probably tracks the master record or execution history of purge runs initiated for a definition.
  • SY_TEXT_HDR: Contains the translatable description and name for the purge definition, linked via TEXT_CODE.

Direct manipulation of this table is not standard practice; configurations are typically managed through the OPM Purge and Archive functional screens, which maintain the integrity of these relationships.