Search Results import_id




Overview
Explore in AI Chat

Overview

The RH_IMPT_MST table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMP) Process Planning module. It functions as the master or header table for import transactions, specifically those related to process planning data. Its primary role is to serve as a control and tracking entity for bulk data import operations, providing a unique identifier and overarching metadata for a set of imported records. This structure allows for the logical grouping of detailed import lines, enabling batch processing, error handling, and auditability for data migration or integration activities within the manufacturing planning lifecycle.

Key Information Stored

While the provided ETRM excerpt does not list specific columns beyond the primary key, the table's designation as an "Import master" and its relationships imply it stores critical control attributes for an import batch. The definitive column is IMPORT_ID, which serves as the primary key and uniquely identifies each import batch or job. Typical columns in such a master table would likely include status flags (e.g., PENDING, PROCESSED, ERROR), a timestamp for the import request, the name or identifier of the source system or file, the user who initiated the import, and potentially a summary count of records or a high-level description of the import data. This metadata is essential for managing the data load process and tracing the origin of planning data.

Common Use Cases and Queries

The primary use case for RH_IMPT_MST is the management and investigation of data imports into the Process Planning tables. Common operational and reporting queries involve joining this master table with its detail lines to assess the volume and status of imports. For instance, a query to list all recent import batches with their status and record counts would be fundamental. Support personnel would frequently query this table to identify failed import jobs by joining RH_IMPT_MST with RH_IMPT_DTL and filtering on error status columns, facilitating troubleshooting. A typical SQL pattern retrieves header information for a specific import batch to understand its context before drilling into the detail records.

Related Objects

The RH_IMPT_MST table has defined foreign key relationships with several detail tables, as documented in the ETRM. These relationships are central to its function:

  • RH_IMPT_DTL: This is the primary detail table, linked via RH_IMPT_DTL.IMPORT_ID = RH_IMPT_MST.IMPORT_ID. It holds the individual data records for a given import batch.
  • RH_DORD_IMP: Likely a table for importing discrete order data, linked via RH_DORD_IMP.IMPORT_ID = RH_IMPT_MST.IMPORT_ID.
  • RH_MORD_IMP: Likely a table for importing master order data, linked via RH_MORD_IMP.IMPORT_ID = RH_IMPT_MST.IMPORT_ID.

These relationships demonstrate that RH_IMPT_MST provides a unified import control point for multiple types of process planning transactions, with each child table storing the specific operational data for its transaction type.