Search Results igs_fi_er_ord_dtls_u1

Overview

The IGS_FI_ER_ORD_DTLS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the now-obsolete IGS (Student System) product family. Its primary role is to manage the detailed ordering sequence for attributes defined within an Element Range Order. This functionality is critical for organizing and sequencing financial or administrative elements, such as fee components or assessment items, based on specific attributes like unit level or type. The table acts as a child entity, storing the individual sequenced items that belong to a parent order definition.

Key Information Stored

The table stores the granular details that define the sequence of an element range. Key columns include the primary identifier ORDER_ID and the ORDER_NUM, which explicitly defines the positional sequence for an entry. The ELM_RNG_ORDER_NAME column is a foreign key that links the detail record to its parent order definition in the IGS_FI_ELM_RNG_ORDS table. The ORDER_ATTR_VALUE column holds the specific attribute value (e.g., a particular unit level code) that is being sequenced, which is itself a foreign key to the IGS_PS_UNIT_TYPE_LVL table. The presence of unique keys on (ORDER_NUM, ELM_RNG_ORDER_NAME) and (ELM_RNG_ORDER_NAME, ORDER_ATTR_VALUE) ensures sequence uniqueness and prevents duplicate attribute values within a single order.

Common Use Cases and Queries

A primary use case is generating ordered lists for reporting or procedural processing, such as applying fees in a specific sequence based on academic level. A common query would retrieve all sequenced attributes for a given order, sorted correctly. For example, to audit the sequence for an order named 'FEE_ORDER_2024', one might use:

SELECT order_num, order_attr_value
FROM igs_fi_er_ord_dtls
WHERE elm_rng_order_name = 'FEE_ORDER_2024'
ORDER BY order_num;

Another critical scenario involves validating data integrity by checking for orphaned detail records or ensuring attribute values exist in the referenced IGS_PS_UNIT_TYPE_LVL table. Given the user's search for "elm_rng_order_name", a typical troubleshooting query would investigate all detail records associated with a specific, problematic parent order name.

Related Objects

The IGS_FI_ER_ORD_DTLS table has defined relationships with two key parent tables, as per the provided metadata:

• IGS_FI_ELM_RNG_ORDS: This is the parent table for the order definition. The foreign key from IGS_FI_ER_ORD_DTLS.ELM_RNG_ORDER_NAME references this table, establishing that every detail record must belong to a valid master order.
• IGS_PS_UNIT_TYPE_LVL: This table validates the attribute value being sequenced. The foreign key from IGS_FI_ER_ORD_DTLS.ORDER_ATTR_VALUE references this table, ensuring the sequenced value is a legitimate unit type or level within the academic catalog.

It is important to note that the ETRM metadata explicitly states this table is "Not implemented in this database," indicating it may exist in the data dictionary but is not actively used in standard deployments, a common characteristic of obsolete modules.