Search Results rh_expt_mst




Overview
Explore in AI Chat

Overview

The RH_EXPT_MST table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. Functioning as the Export Master table, it serves as the primary repository for high-level metadata and control information governing export operations. Its role is to act as a parent or header record, defining an export instance or batch. This table is integral to the data export processes within GMP, which are essential for transferring manufacturing process data, such as recipes, formulas, or routings, between systems, environments, or for external reporting and integration purposes. The existence of a primary key and a documented foreign key relationship indicates its structural importance as a reference point for more granular transactional data.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the documented primary key and foreign key relationships allow for logical inference of its critical data elements. The central column is EXPORT_ID, which serves as the table's primary key (RH_EXPT_MST_PK). This unique identifier distinguishes one export master record from another. Based on standard EBS design patterns for master/header tables, other columns likely include status flags (e.g., PENDING, PROCESSING, COMPLETE, ERROR), creation and last update dates, the ID of the user who initiated the export, a description or name for the export batch, and potentially parameters that define the scope or type of data being exported (e.g., process type, organization, date range).

Common Use Cases and Queries

This table is primarily accessed for tracking and auditing export job execution within Process Manufacturing. Common operational and reporting scenarios include monitoring the status of ongoing data exports, reviewing a history of past exports, and troubleshooting failed jobs. A typical query would join RH_EXPT_MST with the related detail table to get a complete view of an export transaction.

  • Find Recent Exports: SELECT export_id, creation_date, status, description FROM gmp.rh_expt_mst WHERE creation_date > SYSDATE - 7 ORDER BY creation_date DESC;
  • Monitor Pending/Processing Jobs: SELECT export_id, status, requested_by FROM gmp.rh_expt_mst WHERE status IN ('PENDING', 'PROCESSING');
  • Get Full Export Header and Details: SELECT mst.*, dtl.* FROM gmp.rh_expt_mst mst, gmp.rh_expt_dtl dtl WHERE mst.export_id = dtl.export_id AND mst.export_id = :p_export_id;

Related Objects

The RH_EXPT_MST table has a direct parent-child relationship with at least one other key table in the GMP schema, as evidenced by the documented foreign key constraint.

  • RH_EXPT_DTL (Export Details Table): This is the primary dependent table. It holds the line-level or transactional data associated with a master export record. The tables are joined on the RH_EXPT_DTL.EXPORT_ID column, which is a foreign key referencing RH_EXPT_MST.EXPORT_ID. This relationship allows a single master export record to have multiple detail lines, each representing an individual item, recipe, or other entity being exported.