Search Results elm_rng_order_name




Overview
Explore in AI Chat

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 for the Financials (IGS) modules. It functions as a configuration and sequencing table for Element Range Orders. Its primary role is to store the defined ordering sequence for attributes within a specific Element Range Order, which is a logical grouping used for organizing and processing financial data, such as fee calculations or billing elements, in a predetermined sequence. The table ensures that operations dependent on attribute order, such as hierarchical processing or rule evaluation, are executed consistently according to the configured business logic.

Key Information Stored

The table stores the sequence definition along with its metadata. The most critical columns include:

  • ELM_RNG_ORDER_NAME (VARCHAR2(30)): The foreign key that uniquely identifies the parent Element Range Order for which this sequence is defined. This is a mandatory column and a key search criterion.
  • ORDER_NUM (NUMBER(15)): Stores the numerical position in the sequence, dictating the processing order for the associated attribute value.
  • ORDER_ATTR_VALUE (VARCHAR2(150)): Holds the specific attribute value (e.g., a unit type, fee code, or level) that is being sequenced within the order.
  • ORDER_ID (NUMBER): Serves as the primary key, providing a unique technical identifier for each sequence record.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Track the audit trail for each record, capturing who created or last modified it and when.
The unique indexes, particularly IGS_FI_ER_ORD_DTLS_U1 and U2, enforce critical business rules: preventing duplicate sequence numbers within an order and ensuring the same attribute value is not sequenced multiple times within the same order, respectively.

Common Use Cases and Queries

This table is central to processes requiring ordered evaluation of financial attributes. A primary use case is retrieving the complete, ordered sequence for a specific Element Range Order to drive a procedural calculation or report generation. For example, a fee assessment engine might query this table to determine the hierarchy in which different fee components should be applied. A common reporting query involves joining to the parent order table to list all configured sequences:

SELECT ord_dtls.elm_rng_order_name, ord_dtls.order_num, ord_dtls.order_attr_value
FROM igs.igs_fi_er_ord_dtls ord_dtls
WHERE ord_dtls.elm_rng_order_name = '&ORDER_NAME'
ORDER BY ord_dtls.order_num;

Another key scenario is data validation or migration, where scripts verify that all attribute values within an order have a unique and contiguous sequence number. The table is typically accessed via seeded APIs or custom programs rather than through direct end-user interfaces.

Related Objects

IGS_FI_ER_ORD_DTLS is part of a defined relational model within the IGS schema. Its documented relationships are:

  • Parent Reference (Foreign Key): The ELM_RNG_ORDER_NAME column references a parent table, IGS_FI_ELM_RNG_ORDS. This table defines the master Element Range Order header.
  • Attribute Reference (Foreign Key): The ORDER_ATTR_VALUE column references IGS_PS_UNIT_TYPE_LVL, indicating the attribute values being sequenced are likely related to academic unit types or levels within the Product Suite (PS) module.
  • Primary Key: The ORDER_ID column is the primary key, constrained by index IGS_FI_ER_ORD_DTLS_PK.
These relationships indicate that this detail table is a child of a master configuration header (IGS_FI_ELM_RNG_ORDS) and validates its sequenced values against a domain table (IGS_PS_UNIT_TYPE_LVL).