Search Results igs_fi_acc_pk

Overview

The IGS_FI_ACC_ALL table is a core financial data structure within the Oracle E-Business Suite Student System (IGS). It serves as the master repository for General Ledger (GL) accounts that are specific to a defined financial reporting period, known as a financial period calendar instance. This table enables the association of accounting flexfields with specific timeframes, which is critical for accurate period-based financial reporting, revenue recognition, and transaction posting in an academic environment. Its role is foundational to the financial modules of the Student System, acting as a central reference point for debit, credit, revenue, receipt, and cash accounts used across various student financial processes.

Key Information Stored

The primary identifier for a record in this table is the ACCOUNT_CD column, which forms the primary key (IGS_FI_ACC_PK). While the full column list is not detailed in the provided metadata, the extensive foreign key relationships imply the table stores the unique account code and its descriptive attributes. Crucially, each account record is linked to a specific financial calendar instance, allowing for account definitions to be valid only within certain date ranges. This design supports fiscal year changes and period-specific accounting rules. The table is an "ALL" table, indicating it is a multi-organization structure that can store data for multiple operating units, a standard pattern in Oracle EBS.

Common Use Cases and Queries

This table is primarily referenced for configuring and validating the GL accounts used in student financial transactions. Common operational and reporting scenarios include validating the account codes used in fee assessments, refunds, and credit memos; generating period-end financial reports for student receivables; and troubleshooting transaction posting errors to the general ledger. A typical query would join this table to transaction headers or control tables to retrieve the account description for a given code.

• Sample Query to Validate Account Code:
  SELECT account_cd, description FROM igs_fi_acc_all WHERE account_cd = :p_account_cd AND org_id = :p_org_id;
• Use Case: Identifying all transaction types configured to use a specific revenue account for audit purposes.

Related Objects

The IGS_FI_ACC_ALL table is a central hub with numerous foreign key dependencies, as documented. Key related objects include:

• IGS_FI_F_TYP_CA_INST_ALL: Links fee types and calendar instances to specific REV, REC, and RET accounts (ACCOUNT_CD, REV_ACCOUNT_CD, REC_ACCOUNT_CD, RET_ACCOUNT_CD).
• IGS_FI_CONTROL_ALL: References accounts for system-wide control settings like REC_ACCOUNT_CD, REV_ACCOUNT_CD, CASH_ACCOUNT_CD, and refund accounts (REFUND_DR_ACCOUNT_CD, REFUND_CR_ACCOUNT_CD).
• IGS_FI_CR_TYPES_ALL: Uses accounts for defining credit types (DR_ACCOUNT_CD, CR_ACCOUNT_CD, FORFEITURE_ACCOUNT_CD).
• IGS_FI_APPLICATIONS & IGS_FI_CR_ACTIVITIES: Reference debit and credit accounts (DR_ACCOUNT_CD, CR_ACCOUNT_CD) for applying payments and credit activities.
• IGS_PS_VER_ALL & IGS_AD_APP_REQ: Link program versions and admission application requirements to specific revenue and cash accounts (REV_ACCOUNT_CD, CASH_ACCOUNT_CD).