Search Results res_dt_alias

Overview

The IGS_FI_CONTROL view is a critical configuration object within the Oracle E-Business Suite Student System (IGS), which is now marked as obsolete. This view serves as the primary interface for accessing the central financial control parameters that govern the behavior of the student financials module. Its primary role is to store and present institution-level defaults and control settings for key financial processes, including accounting method selection, transaction numbering, and, most importantly, the mapping of General Ledger (GL) accounts for revenue, cash, receivables, and unapplied payments. The view is built upon the underlying IGS_FI_CONTROL_ALL table, applying a security filter based on the ORG_ID (Operating Unit) from the user's session context to ensure data access is restricted to the appropriate organizational unit.

Key Information Stored

The view contains numerous columns that define the financial setup. Key columns directly relevant to the user's search for "cash_account_cd" and other core accounting mappings include:

• CASH_ACCOUNT_CD and CASH_GL_CCID: Store the natural account segment value and the full GL Code Combination ID (CCID), respectively, for the default cash account.
• REC_ACCOUNT_CD and REC_GL_CCID: Define the receivable account for student charges.
• REV_ACCOUNT_CD: Holds the natural account for the default revenue account.
• UNAPP_ACCOUNT_CD and UNAPP_GL_CCID: Define the account for unapplied cash payments.
• SET_OF_BOOKS_ID: Identifies the primary ledger for the operating unit.
• ACCOUNTING_METHOD: Determines the accounting rule (e.g., Accrual, Cash) for transactions.
• ORG_ID: The Operating Unit identifier, enabling multi-org architecture support.
• NEXT_INVOICE_NUMBER, CUST_TRX_TYPE_ID, BATCH_SOURCE_ID: Control the numbering and sourcing of AR invoices generated from student transactions.

Common Use Cases and Queries

This view is primarily queried for configuration validation, troubleshooting, and reporting on the financial setup. A common use case is verifying the GL accounts mapped for cash and receivables to ensure proper posting. For example, to retrieve the core accounting defaults for a specific operating unit, a query would be:

SELECT org_id,
cash_account_cd,
rec_account_cd,
rev_account_cd,
unapp_account_cd,
set_of_books_id,
accounting_method
FROM igs_fi_control
WHERE org_id = :p_org_id;

Another critical scenario involves integration with the General Ledger. The CCID columns (e.g., CASH_GL_CCID) are used to validate that the account combinations are valid and active in GL_CODE_COMBINATIONS before transactions are posted, preventing accounting errors.

Related Objects

The IGS_FI_CONTROL view is central to the student financials data model. Its key relationships are defined by foreign keys referencing other EBS setup tables, primarily through the CCID and ID columns. Key related objects include:

• GL_CODE_COMBINATIONS: Joined via columns like CASH_GL_CCID, REC_GL_CCID, and UNAPP_GL_CCID to obtain the full account string for transaction posting.
• GL_SETS_OF_BOOKS: Joined via SET_OF_BOOKS_ID to identify the ledger.
• RA_CUST_TRX_TYPES: Joined via CUST_TRX_TYPE_ID to determine the invoice type defaults.
• RA_BATCH_SOURCES: Joined via BATCH_SOURCE_ID for the transaction source.
• AP_SUPPLIER_SITES_ALL: Related via DFLT_SUPPLIER_SITE_NAME and AP_ORG_ID for refund processing to suppliers.
• The underlying table IGS_FI_CONTROL_ALL is the base table for this view.