Search Results igs_or_unit_ac

Overview

The IGS_OR_UNIT_AC table is a core entity within the Oracle E-Business Suite Student System (IGS). It serves as a master repository for mapping financial accounts to specific organizational units within an educational institution. Its primary role is to define the accounts where funds are held for a nominated organizational unit, establishing a critical link between the institution's financial structure and its operational departments. This table is essential for financial tracking, budgeting, and disbursement processes specific to the academic and administrative units managed by the Student System.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique record for each specific combination of organizational unit and account classification. The key columns are ACCOUNT_CD, ORG_UNIT_CD, OU_START_DT, and CLASSIFICATION_CD. The ACCOUNT_CD identifies the specific financial account. The ORG_UNIT_CD and OU_START_DT together uniquely identify the organizational unit (e.g., a department or school) and its effective period. The CLASSIFICATION_CD references a code from the IGS_FI_ACC_CLASS table, categorizing the type of account. This classification is crucial for grouping accounts for reporting and financial control purposes.

Common Use Cases and Queries

A primary use case is validating and retrieving valid account codes for a given organizational unit during financial transaction entry, such as creating a disbursement or journal. For instance, a report listing all active accounts for a specific department would join IGS_OR_UNIT_AC with IGS_FI_ACC_CLASS to include the classification description. A typical validation query for an interface or form might be:

SELECT account_cd
FROM igs_or_unit_ac
WHERE org_unit_cd = :p_org_unit
  AND ou_start_dt = :p_ou_start_dt
  AND classification_cd = :p_class_cd;

Another critical use case is supporting detailed financial reporting and reconciliation by providing the authoritative source for which accounts are associated with which cost centers (org units).

Related Objects

The IGS_OR_UNIT_AC table maintains defined relationships with other key financial tables in the IGS module:

• Referenced Foreign Key (Parent Table): The CLASSIFICATION_CD column references the IGS_FI_ACC_CLASS table. This enforces that every account classification used in IGS_OR_UNIT_AC must be a valid, predefined classification code.
• Referencing Foreign Key (Child Table): The IGS_FI_DSB_SPSHT_DTL (likely Disbursement Spreadsheet Detail) table references IGS_OR_UNIT_AC via its composite key (ACCOUNT_CD, ORG_UNIT_CD, OU_START_DT, CLASSIFICATION_CD). This ensures that any financial disbursement detail line is posted to a valid and authorized organizational unit account combination.