Search Results refund_cr_account_cd




Overview
Explore in AI Chat

Overview

The APPS.IGS_FI_CONTROL view is a critical data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Financials (IGS) module. It serves as the primary interface to the underlying IGS_FI_CONTROL_ALL table, enforcing a security model based on the operating unit (ORG_ID) derived from the user's session context via the CLIENT_INFO function. This view centralizes the storage of global and operating-unit-specific control parameters and default values that govern the behavior of the financial system, particularly for transactions, accounting, and refund processing. Its role is to provide a secure, filtered access point to these system-wide financial settings.

Key Information Stored

The view contains a comprehensive set of control columns. Key fields include REC_INSTALLED (the primary key), SET_OF_BOOKS_ID for the default ledger, and various identifiers for default transaction types (CUST_TRX_TYPE_ID), payment terms (TERM_ID), and batch sources (BATCH_SOURCE_ID). Crucially for the user's search context, it stores the default accounting flexfields for refund transactions: REFUND_DR_GL_CCID, REFUND_CR_GL_CCID, REFUND_DR_ACCOUNT_CD, and REFUND_CR_ACCOUNT_CD. Other significant columns manage accounting method (ACCOUNTING_METHOD), next invoice number (NEXT_INVOICE_NUMBER), lockbox settings, and flags for processes like PLANNED_CREDITS_IND and POST_WAIVER_GL_FLAG.

Common Use Cases and Queries

This view is primarily referenced for configuration validation, troubleshooting, and reporting on system defaults. A common use case is verifying the default General Ledger accounts configured for student or customer refunds. The following query pattern retrieves the refund accounting codes for a specific operating unit context:

  • SELECT refund_dr_account_cd, refund_cr_account_cd, refund_dr_gl_ccid, refund_cr_gl_ccid FROM apps.igs_fi_control WHERE rec_installed = 'Y';

It is also queried to audit system-wide financial parameters, such as the default set of books or the status of conversion processes (CONV_PROCESS_RUN_IND). Integration and interface programs may read from this view to determine default values when creating financial transactions programmatically.

Related Objects

The view's structure and primary key indicate its central relationship within the financial schema. The primary key constraint IGS_FI_CONTROL_PK on REC_INSTALLED suggests this table is designed to hold a single control record per installation or a keyed set of records. The view is built directly upon the base table IGS_FI_CONTROL_ALL, filtering by ORG_ID. While specific foreign key relationships are not detailed in the provided metadata, columns such as SET_OF_BOOKS_ID, CUST_TRX_TYPE_ID, TERM_ID, and BATCH_SOURCE_ID imply relationships to GL_SETS_OF_BOOKS, RA_CUST_TRX_TYPES, RA_TERMS, and RA_BATCH_SOURCES tables, respectively. The AR_INT_ORG_ID and AP_ORG_ID columns also suggest integration points with the Receivables and Payables modules.