Results for “igi_int_descriptrs”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGI_INT_DESCRIPTRS is a configuration table owned by the IGI schema, the Public Sector Financials International product within Oracle E-Business Suite. As documented in the ETRM repository for release 12.2.2, the table "contains descriptor details" and is registered as a VALID object in the EBS data dictionary. Its functional purpose is to define the descriptor structure associated with an interface journal source, allowing an implementation to control how journal entry interfaces present, validate, and secure the descriptor fields that accompany imported accounting lines.

The table is a narrow, low-volume reference object with fifteen documented columns and a single unique index, IGI_INT_DESCRIPTRS_PK, built on JE_SOURCE_NAME. The ETRM relationship mining classifies this object heuristically as standalone, with no foreign key dependencies recorded to other tables. In Data Vault terms, this object is best modeled as a satellite or reference table: it carries descriptive and control attributes that qualify a journal source, rather than acting as a hub of independent business entities or a link resolving many-to-many relationships. The absence of outgoing foreign keys means the JE_SOURCE_NAME value is treated as the natural business key rather than as a surrogate reference to a parent hub.

Key Information Stored

The primary key of the table is JE_SOURCE_NAME, which also constitutes the sole documented unique index and therefore the business-key candidate. This column identifies the journal entry source to which the descriptor configuration applies, and it is the column used in every join or lookup against the table.

• JE_SOURCE_NAME — The business key and primary key. Names the interface journal source governed by the descriptor row.
• SECURE_SOURCE_FLAG — Controls whether the source's descriptor values are treated as secured, typically gating access or display for restricted data.
• DATE_PICTURE — Stores the date format mask applied to date-oriented descriptor fields during import and display.
• DESCRIPTOR_NAME1 through DESCRIPTOR_NAME7 — Seven descriptor label columns that define the configurable descriptor slots available for the source. Each holds the name or label that identifies the corresponding descriptor position on the interface.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last maintained the configuration row and when.

The seven descriptor-name columns constitute the substantive payload of the table; the remaining columns are either the business key, a security control, a formatting attribute, or audit metadata.

Common Use Cases and Queries

Typical usage centers on validating interface loads and confirming descriptor setup prior to running journal import. A configuration or support query might retrieve the descriptor layout for a given source:

• SELECT JE_SOURCE_NAME, SECURE_SOURCE_FLAG, DATE_PICTURE, DESCRIPTOR_NAME1, DESCRIPTOR_NAME2 FROM IGI.IGI_INT_DESCRIPTRS WHERE JE_SOURCE_NAME = :source;
• SELECT JE_SOURCE_NAME, DESCRIPTOR_NAME1 FROM IGI.IGI_INT_DESCRIPTRS ORDER BY JE_SOURCE_NAME; — used to inventory all configured sources.
• Reporting on secure sources: SELECT COUNT(*) FROM IGI.IGI_INT_DESCRIPTRS WHERE SECURE_SOURCE_FLAG = 'Y';
• Audit or change tracking: query CREATED_BY and LAST_UPDATED_BY to identify recent configuration changes affecting import behavior.

Because the table is standalone, diagnostic work is generally limited to confirming that a descriptor definition exists for the source being imported and that the descriptor slots are populated as expected.

Related Objects

The ETRM metadata records no foreign key relationships for IGI_INT_DESCRIPTRS, so related objects are identified functionally through the JE_SOURCE_NAME business key rather than through documented constraints. The most significant associated objects include the IGI interface journal import and descriptor tables that consume the same journal source, GL_JE_SOURCES and its interface counterpart used by the Journal Import program, and the IGI public sector financials interface staging tables that carry descriptor values on import lines. The IGI_INT_DESCRIPTRS_PK unique index and the table's audit columns are integral to any retrieval. Because the documented relationship data is limited, implementers should verify actual runtime dependencies in their instance before assuming join paths beyond JE_SOURCE_NAME.