Search Results rh_dord_imp




Overview
Explore in AI Chat

Overview

The RH_DORD_IMP table is a technical data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. Its defined purpose is to function as a staging table for the import of demand order details into the system. As explicitly noted in the official ETRM documentation, this table is currently not used in standard EBS 12.1.1 and 12.2.2 implementations. This status indicates that while the table structure exists within the GMP schema, the associated data import functionality or interface it was designed to support is inactive or has been superseded by alternative mechanisms. Its role, therefore, is largely historical or reserved for potential future use, serving as a defined but unimplemented point of integration for external demand order data.

Key Information Stored

The table is designed to store transactional metadata necessary for processing imported demand orders. Its primary key is a composite of IMPORT_ID, DOC_TYPE, and LINE_ID, ensuring uniqueness for each imported line. Key columns include IMPORT_ID, which links to the master import control record; DOC_TYPE and LINE_ID, which identify the original source document; and LINE_NO for the sequence. The NEW_DOC_TYPE and NEW_DOC_ID columns are intended to store the corresponding document identifiers generated within Oracle EBS after successful import processing. The ACTION_TYPE column would typically dictate the operation (e.g., CREATE, UPDATE) to be performed on the target demand order based on the imported record.

Common Use Cases and Queries

Given its documented "Currently Not Used" status, there are no active standard use cases for this table in production environments. Its primary utility would be for technical analysis, such as investigating legacy data or understanding the application's data model. Database administrators or technical consultants might query it to confirm its emptiness or structure. A sample query to examine any residual data or the column structure would be:

  • SELECT COUNT(*) FROM GMP.RH_DORD_IMP;
  • SELECT column_name, data_type FROM all_tab_columns WHERE table_name = 'RH_DORD_IMP' AND owner = 'GMP';

Any operational data loading or interface development for demand orders would utilize other, active tables and public APIs within the GMP or related Order Management modules.

Related Objects

Based on the provided foreign key metadata, RH_DORD_IMP has a defined relationship with one other table, which governs its import context:

  • RH_IMPT_MST: This is the master import control table. The foreign key from RH_DORD_IMP.IMPORT_ID references RH_IMPT_MST. This relationship suggests that records in RH_DORD_IMP would be logically grouped under a single master import transaction record, which likely tracks overall job status, source, and date.

The existence of this foreign key, despite the table being unused, reinforces its intended design as a child staging table within a broader data import framework for Process Manufacturing demand planning.