Search Results igs_fi_credits_all




Overview
Explore in AI Chat

Overview

The IGS_FI_CREDITS_ALL table is a core data repository within the Oracle E-Business Suite's now-obsolete Student System (IGS) module, specifically for Student Finance. It serves as the central ledger for recording all credit and payment transactions applied to student accounts. This includes payments, refunds, waivers, and other credit adjustments. As an "ALL" table, it is multi-org enabled, storing data partitioned by operating unit (ORG_ID). Its primary role is to maintain a complete, auditable history of all financial credits, which is essential for account reconciliation, financial reporting, and managing student financial holds.

Key Information Stored

The table's structure is designed to capture the essential attributes of a credit transaction. The primary identifier is the system-generated CREDIT_ID. Key transactional data includes CREDIT_NUMBER, PARTY_ID (linking to the student/customer in HZ_PARTIES), and the CREDIT_TYPE_ID (linking to IGS_FI_CR_TYPES_ALL for categorization). Financial details such as the credit amount and date are stored, along with the SUBACCOUNT_ID for accounting purposes. The table also tracks the source of the credit through columns like SOURCE_INVOICE_ID (linking to IGS_FI_INV_INT_ALL for invoice-based credits) and RECEIPT_LOCKBOX_NUMBER (for batch payments). For credits related to specific fees or waivers, it references FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and WAIVER_NAME.

Common Use Cases and Queries

This table is central to financial inquiries and reconciliation processes. Common operational and reporting use cases include generating student account statements, reconciling daily payment batches from lockboxes, auditing waiver applications, and identifying credits that released financial holds. A typical query might join to party and invoice tables to analyze payment history for a student or a cohort.

  • Sample Query: Retrieve Credits for a Student
    SELECT c.credit_number, c.credit_date, c.amount, ct.type_code, i.invoice_number
    FROM igs_fi_credits_all c,
    igs_fi_cr_types_all ct,
    igs_fi_inv_int_all i
    WHERE c.party_id = 12345
    AND c.org_id = 101
    AND c.credit_type_id = ct.credit_type_id
    AND c.source_invoice_id = i.invoice_id(+)
    ORDER BY c.credit_date DESC;

Related Objects

The IGS_FI_CREDITS_ALL table has extensive relationships with other Student Finance entities, as shown by its foreign key constraints. It is a parent table to several key transactional tables, including IGS_FI_APPLICATIONS (for applying credits to charges), IGS_FI_CR_ACTIVITIES (for tracking actions on the credit), and IGS_FI_PP_INS_APPLS (for payment plan installments). It is also referenced by IGS_FI_PERSON_HOLDS as a credit that may release a financial hold. Crucially, it draws reference data from master tables: HZ_PARTIES for the student/customer, IGS_FI_CR_TYPES_ALL for the credit type, IGS_FI_SUBACCTS_ALL for the accounting sub-account, and IGS_FI_INV_INT_ALL for the source invoice.

  • 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_PP_INS_APPLS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_PP_INS_APPLS,  object_name:IGS_FI_PP_INS_APPLS,  status:VALID,  product: IGS - Student System ,  description: This table stores credit information for a particular installment. ,  implementation_dba_data: IGS.IGS_FI_PP_INS_APPLS , 

  • View: IGS_FI_CREDITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_CREDITS,  object_name:IGS_FI_CREDITS,  status:VALID,  product: IGS - Student System ,  description: This view is a multi-org filter flat view based on table IGS_FI_CREDITS_ALL. ,  implementation_dba_data: APPS.IGS_FI_CREDITS , 

  • 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_OTC_CHARGES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_OTC_CHARGES,  object_name:IGS_FI_OTC_CHARGES,  status:VALID,  product: IGS - Student System ,  description: Contains information on the charges (of type external) that are created at the time of receipt creation. Provides a repository of all charges that are tied to the receipt, if any, that were created when the student pays over the counter. ,  implementation_dba_data: IGS.IGS_FI_OTC_CHARGES , 

  • Table: IGS_FI_LOCKBOXES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LOCKBOXES,  object_name:IGS_FI_LOCKBOXES,  status:VALID,  product: IGS - Student System ,  description: Table for storing the attributes of a user defined Lockbox Name. ,  implementation_dba_data: IGS.IGS_FI_LOCKBOXES , 

  • Table: IGS_FI_PERSON_HOLDS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_PERSON_HOLDS,  object_name:IGS_FI_PERSON_HOLDS,  status:VALID,  product: IGS - Student System ,  description: This table acts as an intermediate table that will be used by the release hold process to find out the holds placed on a person by student finance. The Apply Hold Process populates data into this table. ,  implementation_dba_data: IGS.IGS_FI_PERSON_HOLDS , 

  • Table: IGS_FI_CR_TYPES_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_CR_TYPES_ALL,  object_name:IGS_FI_CR_TYPES_ALL,  status:VALID,  product: IGS - Student System ,  description: Stores information about the 'credit type' of a credit transaction. The credit type provides the debit and credit account information to a credit transaction along with some other information like credit class etc. ,  implementation_dba_data: IGS.IGS_FI_CR_TYPES_ALL , 

  • Table: IGS_FI_SUBACCTS_ALL 12.1.1

    product: IGS - Student System ,  description: Stores information about each defined sub account. Each row contains information for a specific sub account, including name, description, receivables, revenue, cash and unapplied account details and receipt lockbox numbers that are assigned ,  implementation_dba_data: Not implemented in this database , 

  • 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: IGSBV_PERSON_DEPOSITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PERSON_DEPOSITS,  object_name:IGSBV_PERSON_DEPOSITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Student Deposits in Student Finance ,  implementation_dba_data: APPS.IGSBV_PERSON_DEPOSITS , 

  • View: IGSBV_PARTY_CREDITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PARTY_CREDITS,  object_name:IGSBV_PARTY_CREDITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Party Credits in Student Finance ,  implementation_dba_data: APPS.IGSBV_PARTY_CREDITS , 

  • 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: IGSFV_PERSON_DEPOSITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PERSON_DEPOSITS,  object_name:IGSFV_PERSON_DEPOSITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Student Deposits in Student Finance ,  implementation_dba_data: APPS.IGSFV_PERSON_DEPOSITS , 

  • View: IGSFV_PARTY_CREDITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PARTY_CREDITS,  object_name:IGSFV_PARTY_CREDITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Party Credits in Student Finance ,  implementation_dba_data: APPS.IGSFV_PARTY_CREDITS ,