Search Results igs_fi_cr_activities




Overview
Explore in AI Chat

Overview

The IGS_FI_CR_ACTIVITIES table is a core transactional entity within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as an audit trail and workflow log for the life cycle of financial credit transactions. A credit transaction, as managed in the IGS_FI_CREDITS_ALL table, represents a monetary amount applied to a student's account, such as a payment, scholarship, or waiver. This table is automatically populated with a new record whenever a credit transaction is created with an initial status of 'CLEARED'. It serves as the central point for tracking subsequent financial activities, including the application of the credit to outstanding charges, refunds, or transfers, ensuring a complete and auditable history of each credit's utilization.

Key Information Stored

The table's primary key is CREDIT_ACTIVITY_ID, which uniquely identifies each step in a credit's life cycle. Critical foreign key columns establish relationships to other major financial entities. The CREDIT_ID column links the activity back to its source transaction in IGS_FI_CREDITS_ALL. The BILL_ID and POSTING_ID columns connect the activity to specific student invoices (IGS_FI_BILL_ALL) and general ledger posting interfaces (IGS_FI_POSTING_INT_ALL), respectively. Furthermore, the DR_ACCOUNT_CD and CR_ACCOUNT_CD columns define the debit and credit accounting flexfields, linking to the IGS_FI_ACC_ALL table to capture the accounting impact of the activity. Additional columns typically track the activity amount, date, type, and sequence, providing a chronological record of the credit's disposition.

Common Use Cases and Queries

A primary use case is tracing the complete application history of a specific credit or payment. This is essential for resolving student account inquiries, performing reconciliations, and supporting audit requests. Financial reports often join this table to credits and invoices to show applied amounts versus outstanding balances. Another critical scenario involves investigating refund processes, as refund transactions often create records in this table. A sample query to retrieve the application history for a credit would be:

  • SELECT ca.*, b.bill_number FROM igs_fi_cr_activities ca JOIN igs_fi_credits_all c ON ca.credit_id = c.credit_id LEFT JOIN igs_fi_bill_all b ON ca.bill_id = b.bill_id WHERE c.credit_id = :p_credit_id ORDER BY ca.creation_date;

Analysts may also query this table to summarize all credit activities within a date range for a batch reconciliation with external payment systems or the general ledger.

Related Objects

IGS_FI_CR_ACTIVITIES is a central hub with documented relationships to several key financial tables. It is a child of IGS_FI_CREDITS_ALL via CREDIT_ID. It references IGS_FI_BILL_ALL (BILL_ID), IGS_FI_POSTING_INT_ALL (POSTING_ID), and IGS_FI_ACC_ALL twice (DR_ACCOUNT_CD, CR_ACCOUNT_CD). Importantly, it acts as a parent table for multiple transactional entities. The CREDIT_ACTIVITY_ID is referenced by IGS_FI_APPLICATIONS (linking to applied payments), IGS_FI_BILL_DPSTS (bill deposits), IGS_FI_PP_INS_APPLS (payment plan installments), and IGS_FI_BILL_TRNSCTNS (where it serves as the INVOICE_CREDITACT_ID for billing transactions). These relationships underscore its role in connecting credits to their downstream financial consequences.

  • 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_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 , 

  • 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_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_BILL_DPSTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_DPSTS,  object_name:IGS_FI_BILL_DPSTS,  status:VALID,  product: IGS - Student System ,  description: This table captures eligible deposit records for a particular bill. ,  implementation_dba_data: IGS.IGS_FI_BILL_DPSTS , 

  • 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 , 

  • View: IGS_FI_BILL_DPSTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_BILL_DPSTS_V,  object_name:IGS_FI_BILL_DPSTS_V,  status:VALID,  product: IGS - Student System ,  description: View for retrieving the records from Billing Deposits. ,  implementation_dba_data: APPS.IGS_FI_BILL_DPSTS_V , 

  • Table: IGS_FI_BILL_TRNSCTNS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_TRNSCTNS,  object_name:IGS_FI_BILL_TRNSCTNS,  status:VALID,  product: IGS - Student System ,  description: IGS_FI_TRNSCTNS is the relation where the transactions recorded against a Bill are stored. This relation has a mapping to the Bill Header table as it stores the detail information against the header records. The transaction recorded in this ,  implementation_dba_data: IGS.IGS_FI_BILL_TRNSCTNS , 

  • 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 , 

  • View: IGS_FI_CRDT_TRNSCTNS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_CRDT_TRNSCTNS,  object_name:IGS_FI_CRDT_TRNSCTNS,  status:VALID,  product: IGS - Student System ,  description: Holds Credit Transactions ,  implementation_dba_data: APPS.IGS_FI_CRDT_TRNSCTNS , 

  • Table: IGS_FI_BILL_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_ALL,  object_name:IGS_FI_BILL_ALL,  status:VALID,  product: IGS - Student System ,  description: IGS_FI_BILL_ALL is the relation where the Billing Header information is recorded. Here the Bill Numbers are generated and Bill header details such as Bill Date, Due Date, Billed Person, Sub Account and Balances are recorded. ,  implementation_dba_data: IGS.IGS_FI_BILL_ALL , 

  • View: IGS_FI_ACCT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_ACCT_V,  object_name:IGS_FI_ACCT_V,  status:VALID,  product: IGS - Student System ,  description: This view contains information from two views IGS_FI_INV_INT and IGS_FI_CREDITS_V and a table IGS_FI_CR_ACTIVITES using UNION to collate information for Account History Form. ,  implementation_dba_data: APPS.IGS_FI_ACCT_V , 

  • View: IGS_FI_CR_ACTIVITIES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_CR_ACTIVITIES_V,  object_name:IGS_FI_CR_ACTIVITIES_V,  status:VALID,  product: IGS - Student System ,  description: Retrieves the records from the Credit Activities table. ,  implementation_dba_data: APPS.IGS_FI_CR_ACTIVITIES_V , 

  • 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: 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: 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 ,