Search Results igi_itr_charge_ranges_pk

Overview

The IGI_ITR_CHARGE_RANGES table is a core configuration object within the IGI – Public Sector Financials International product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores user-defined accounting ranges that are applied during the indirect cost allocation and charge generation processes performed by the Interagency Transaction (ITR) modules. Each row in the table defines a bounded segment range across the Accounting Flexfield, allowing the application to map transactions, expenditures, or charge lines to a specific charge center and authorising employee. This configuration-driven design enables public sector organisations to model complex cost-recovery arrangements without hard-coding accounting logic.

In Data Vault modelling terms, the metadata's heuristic classification places this object as satellite-leaning. This is consistent with its structure: the table captures descriptive, change-tracked attributes (segment ranges, active flag, authoriser) attached to a parent business key. It does not itself act as a pure hub or a link between two hubs, although it references both a charge center and an employee. Where a warehouse is built over EBS, IGI_ITR_CHARGE_RANGES is best treated as a satellite joined to the charge center hub, with effective dating handled by the standard WHO columns.

Key Information Stored

The table is defined in the IGI schema and contains 70 columns. The most significant ones are:

• CHARGE_RANGE_ID – surrogate primary key, enforced by IGI_ITR_CHARGE_RANGES_PK and also supported by unique index IGI_ITR_CHARGE_RANGES_U1. It is the primary business-key candidate referenced by child tables.
• CHARGE_CENTER_ID – foreign key to IGI_ITR_CHARGE_CENTER, identifying the charge center to which the range belongs.
• EMPLOYEE_ID – foreign key to PSB_EMPLOYEES, identifying the employee associated with the range.
• SEGMENT1_LOW … SEGMENT30_HIGH – sixty columns expressing low and high bounds for up to thirty Accounting Flexfield segments. They define the accounting range for which the charge rule applies.
• AUTHORISER_ID – the individual who authorised the charge range.
• ACTIVE_FLAG – indicates whether the range is currently enabled for use during charge processing.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – standard Oracle WHO audit columns.

Common Use Cases and Queries

Typical reporting requirements include listing active ranges for a given charge center or verifying which accounting ranges an employee is authorised to raise charges against. A representative query is:

• SELECT r.charge_range_id, r.charge_center_id, r.employee_id, r.segment1_low, r.segment1_high, r.active_flag FROM igi_itr_charge_ranges r WHERE r.charge_center_id = :charge_center_id AND r.active_flag = 'Y';
• Joining to parent and child objects: SELECT c.charge_center_name, r.segment1_low, r.segment1_high FROM igi_itr_charge_center c, igi_itr_charge_ranges r WHERE c.charge_center_id = r.charge_center_id;
• Detecting overlapping ranges for a charge center to prevent duplicate configuration before enabling ACTIVEE ranges.

These queries support audit, setup validation, and cost-recovery reconciliation reporting.

Related Objects

The principal dependent and referenced objects are:

• IGI_ITR_CHARGE_CENTER – parent table; joined on CHARGE_CENTER_ID.
• PSB_EMPLOYEES – joined on EMPLOYEE_ID.
• IGI_ITR_CHARGE_LINES – references CHARGE_RANGE_ID; holds generated charge lines.
• IGI_ITR_CHARGE_LINES_TMP – staging table referencing CHARGE_RANGE_ID.
• IGI_ITR_CHARGE_RANGES_TMP – temporary working table referencing the same key.

Together these objects form the configuration and processing backbone of the IGI charge generation flow.