Search Results igs_fi_applications




Overview
Explore in AI Chat

Overview

The IGS_FI_APPLICATIONS table is a core transactional data object within the Oracle E-Business Suite Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for recording the application of financial credits against charges or invoices. This table is fundamental to the accounts receivable and financial accounting processes within the student lifecycle, enabling the tracking of payments, waivers, and other credit types as they are applied to specific student fee liabilities. Its existence ensures a clear audit trail between a charge (debit) and its corresponding settlement (credit), which is critical for accurate account balancing, financial reporting, and student account statement generation.

Key Information Stored

The table stores the essential linkage details for each application transaction. The primary identifier is the APPLICATION_ID. Crucially, it holds foreign key references to both the credit and debit sides of a transaction. This includes the CREDIT_ID linking to the source credit in IGS_FI_CREDITS_ALL and the INVOICE_ID or APPLIED_INVOICE_LINES_ID linking to the charge in IGS_FI_INV_INT_ALL or IGS_FI_INVLN_INT_ALL. The DR_ACCOUNT_CD and CR_ACCOUNT_CD columns define the accounting flexfields for the debit and credit legs of the application, linking to IGS_FI_ACC_ALL. Other significant columns include the POSTING_ID, which ties the application to a general ledger posting batch in IGS_FI_POSTING_INT_ALL, and the APPL_HIERARCHY_ID, which may reference a specific financial hierarchy rule from IGS_FI_A_HIERARCHIES used for the application logic.

Common Use Cases and Queries

This table is central to reconciling student accounts and investigating payment applications. Common operational and reporting scenarios include generating detailed student account statements, auditing the application of a specific payment or waiver, and reconciling transactions posted to the general ledger. A typical query would join IGS_FI_APPLICATIONS to both credit and invoice tables to provide a complete view of applied transactions for a student or within a date range.

  • Sample Query: To list all applications for a specific invoice: SELECT app.* FROM igs.igs_fi_applications app WHERE app.invoice_id = <INVOICE_VALUE>;
  • Reporting Use Case: A reconciliation report between the Student System and General Ledger often uses the POSTING_ID to trace applied transactions from IGS_FI_APPLICATIONS to the corresponding entries in the GL interface tables.
  • Support Scenario: When a student questions a payment on their account, support personnel query this table using the CREDIT_ID or person identifier (via joins) to see exactly which charges were paid.

Related Objects

The IGS_FI_APPLICATIONS table has defined foreign key relationships with several key transactional and setup tables, as documented in the ETRM metadata. These relationships are critical for data integrity and query construction.

  • IGS_FI_CREDITS_ALL via CREDIT_ID: The source credit (payment, waiver, etc.) being applied.
  • IGS_FI_INV_INT_ALL via INVOICE_ID: The header-level invoice or charge being paid.
  • IGS_FI_INVLN_INT_ALL via APPLIED_INVOICE_LINES_ID: The specific line item of an invoice being paid.
  • IGS_FI_POSTING_INT_ALL via POSTING_ID: The batch record for transactions sent to the General Ledger.
  • IGS_FI_ACC_ALL via DR_ACCOUNT_CD and CR_ACCOUNT_CD: The accounting flexfield codes for the debit and credit accounts.
  • IGS_FI_A_HIERARCHIES via APPL_HIERARCHY_ID: The accounting hierarchy rule potentially governing the application.
  • IGS_FI_CR_ACTIVITIES via CREDIT_ACTIVITY_ID: Links to the activity that generated the credit.
  • Table: IGS_FI_APPLICATIONS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_APPLICATIONS,  object_name:IGS_FI_APPLICATIONS,  status:VALID,  product: IGS - Student System ,  description: Contains application information about credits and charges transaction that are applied. ,  implementation_dba_data: IGS.IGS_FI_APPLICATIONS , 

  • Table: IGS_FI_POSTING_INT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_POSTING_INT_ALL,  object_name:IGS_FI_POSTING_INT_ALL,  status:VALID,  product: IGS - Student System ,  description: This table contains transactions information collated from three source transaction tables - IGS_FI_CR_ACTIVITIES, IGS_FI_INVLN_INT_ALL and IGS_FI_APPLICATIONS for posting purposes. The information captured here is an interim step to create ,  implementation_dba_data: IGS.IGS_FI_POSTING_INT_ALL , 

  • Table: IGS_FI_ACC_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_ACC_ALL,  object_name:IGS_FI_ACC_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a Finance General Ledger account specific to a financial reporting period (financial period calendar instance). ,  implementation_dba_data: IGS.IGS_FI_ACC_ALL , 

  • View: IGS_AS_ORDER_PAYMENT_INFO_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AS_ORDER_PAYMENT_INFO_V,  object_name:IGS_AS_ORDER_PAYMENT_INFO_V,  status:VALID,  product: IGS - Student System ,  description: This view is used to get the payment related information corresponding to the order for document placed by the user. ,  implementation_dba_data: APPS.IGS_AS_ORDER_PAYMENT_INFO_V , 

  • View: IGS_FI_UNPOSTED_TRANSACTIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_UNPOSTED_TRANSACTIONS,  object_name:IGS_FI_UNPOSTED_TRANSACTIONS,  status:VALID,  product: IGS - Student System ,  description: Displays the un-posted transactions in Student Finance. ,  implementation_dba_data: APPS.IGS_FI_UNPOSTED_TRANSACTIONS , 

  • Table: IGS_FI_A_HIERARCHIES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_A_HIERARCHIES,  object_name:IGS_FI_A_HIERARCHIES,  status:VALID,  product: IGS - Student System ,  description: Captures application hierarchies setup information from the Define Application Hierarchy form along with information about the credit type associated with this hierarchy. ,  implementation_dba_data: IGS.IGS_FI_A_HIERARCHIES , 

  • Table: IGS_FI_INVLN_INT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_INVLN_INT_ALL,  object_name:IGS_FI_INVLN_INT_ALL,  status:VALID,  product: IGS - Student System ,  description: This interface table stores invoice lines data generated by invoice process. ,  implementation_dba_data: IGS.IGS_FI_INVLN_INT_ALL , 

  • Table: IGS_FI_CREDITS_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_CREDITS_ALL,  object_name:IGS_FI_CREDITS_ALL,  status:VALID,  product: IGS - Student System ,  description: This table contains information about all credit or payment transactions and is the central repository for all credits and payments related information in Student Finance. ,  implementation_dba_data: IGS.IGS_FI_CREDITS_ALL , 

  • Table: IGS_FI_CR_ACTIVITIES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_CR_ACTIVITIES,  object_name:IGS_FI_CR_ACTIVITIES,  status:VALID,  product: IGS - Student System ,  description: Contains steps for the life cycle of credit transactions. This captures one record in this table when a new credit transaction is created in IGS_FI_CREDITS_ALL table with STATUS 'CLEARED'. ,  implementation_dba_data: IGS.IGS_FI_CR_ACTIVITIES , 

  • Table: IGS_FI_INV_INT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_INV_INT_ALL,  object_name:IGS_FI_INV_INT_ALL,  status:VALID,  product: IGS - Student System ,  description: This interface table stores invoice data generated by invoice process. ,  implementation_dba_data: IGS.IGS_FI_INV_INT_ALL , 

  • View: IGS_FI_APPLICATIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_APPLICATIONS_V,  object_name:IGS_FI_APPLICATIONS_V,  status:VALID,  product: IGS - Student System ,  description: No Longer Used ,  implementation_dba_data: APPS.IGS_FI_APPLICATIONS_V ,