Search Results ic_purg_prm




Overview
Explore in AI Chat

Overview

The IC_PURG_PRM table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Inventory (GMI) module. It serves as a configuration and control table for defining and managing inventory data purge parameters. In the context of data lifecycle management, this table stores the specific criteria and versioning rules that govern the archival or deletion of historical inventory transaction data. Its primary role is to provide a structured mechanism for system administrators to execute data purges, ensuring database performance is maintained by removing obsolete records while preserving necessary audit trails and compliance with business rules.

Key Information Stored

The table's structure is defined by its primary key, which consists of the columns CRITERIA_NO and VERSION_NO. This composite key allows for the maintenance of multiple, versioned sets of purge criteria. A critical foreign key relationship exists via the INV_CLASS column, which references the IC_INVN_CLS table. This link ties purge parameters to specific inventory classes, enabling class-specific purge rules. While the provided metadata does not list all columns, the table's purpose indicates it likely stores parameters such as cutoff dates, transaction types to purge, status flags for purge execution, and retention period definitions.

Common Use Cases and Queries

The primary use case is the execution of a controlled inventory data purge process, typically initiated from a dedicated purge form or concurrent program within the GMI module. Administrators would query this table to review or modify existing purge criteria before submission. Common SQL patterns include selecting all active parameter sets for a given inventory class or retrieving the latest version of criteria for execution. For example:

  • SELECT * FROM GMI.IC_PURG_PRM WHERE INV_CLASS = '<class_code>' ORDER BY CRITERIA_NO, VERSION_NO;
  • SELECT MAX(VERSION_NO) FROM GMI.IC_PURG_PRM WHERE CRITERIA_NO = '<criteria_number>';

Reporting use cases focus on auditing purge configurations and understanding data retention policies across different inventory classifications.

Related Objects

The most directly related object, as documented, is the IC_INVN_CLS (Inventory Class) table, which is referenced by the foreign key on the INV_CLASS column. This relationship ensures purge parameters are validated against valid inventory classes. The purge functionality itself is likely driven by a PL/SQL package or a concurrent program that reads parameters from IC_PURG_PRM and performs the actual data manipulation on core inventory transaction tables, such as those in the IC_TRANS family (e.g., IC_TRAN_CMP, IC_TRAN_PND). The table's primary key constraint, IC_PURG_PRM_PK, enforces data integrity for all parameter definitions.