Search Results igs_ad_ent_org_units_uk




Overview
Explore in AI Chat

Overview

The table IGS_AD_ENT_ORG_UNITS is a data object within the Oracle E-Business Suite, specifically belonging to the IGS (Student System) product family. As explicitly noted in the ETRM metadata, this table is designated as "Obsolete." Its core function was to store associations between organization units (represented as parties) and specific inquiry entry statuses. This linkage was likely used to model organizational responsibility or workflow routing for student inquiries based on their status within the admissions process. However, its operational role in EBS versions 12.1.1 and 12.2.2 is nullified by the metadata stating "Not implemented in this database," indicating it is a legacy artifact with no active data or functionality in a standard implementation.

Key Information Stored

The table's structure centers on a unique identifier and two key foreign key columns that define the relationship. The primary technical identifier is the ENT_ORG_UNIT_ID column. The primary business data is held in the INQ_ENTRY_STAT_ID and PARTY_ID columns, which together form a unique key (IGS_AD_ENT_ORG_UNITS_UK). The INQ_ENTRY_STAT_ID references a specific status in the inquiry entry workflow, while the PARTY_ID references an organization unit from the Trading Community Architecture (TCA) model. This design allowed for a many-to-many relationship where a status could be associated with multiple organizational units and vice versa.

Common Use Cases and Queries

Given its obsolete and unimplemented status, there are no active use cases for this table in a standard Oracle EBS 12.1.1/12.2.2 environment. Historically, if implemented, it would have supported queries to determine responsible organizational units for action based on an inquiry's status. A sample historical query pattern might have been:

  • SELECT hp.party_name, hp.party_number FROM igs_ad_ent_org_units eou, hz_parties hp WHERE eou.party_id = hp.party_id AND eou.inq_entry_stat_id = :p_status_id;

This would retrieve the list of organizations linked to a given inquiry status. Any reporting or process automation relying on this data would have been migrated to alternative, supported tables or mechanisms upon the object's obsolescence.

Related Objects

The ETRM documentation specifies two clear foreign key relationships for this table, linking it to core entities in the system.

  • IGS_AD_I_ENTRY_STATS: The INQ_ENTRY_STAT_ID column in IGS_AD_ENT_ORG_UNITS references the primary key of this table, which manages the valid list of inquiry entry statuses.
  • HZ_PARTIES: The PARTY_ID column in IGS_AD_ENT_ORG_UNITS references the primary key of this foundational Trading Community Architecture table, thereby linking an inquiry status to a specific organization unit defined as a party.

These relationships underscore the table's intended role as a junction table between admission inquiry statuses and organizational entities.