Search Results igs_fi_acc_all




Overview
Explore in AI Chat

Overview

The IGS_FI_ACC_ALL table is a core financial data structure within the Oracle E-Business Suite Student System (IGS). It serves as the master repository for General Ledger (GL) accounts that are specific to a defined financial reporting period, known as a financial period calendar instance. This table enables the association of accounting flexfields with specific timeframes, which is critical for accurate period-based financial reporting, revenue recognition, and transaction posting in an academic environment. Its role is foundational to the financial modules of the Student System, acting as a central reference point for debit, credit, revenue, receipt, and cash accounts used across various student financial processes.

Key Information Stored

The primary identifier for a record in this table is the ACCOUNT_CD column, which forms the primary key (IGS_FI_ACC_PK). While the full column list is not detailed in the provided metadata, the extensive foreign key relationships imply the table stores the unique account code and its descriptive attributes. Crucially, each account record is linked to a specific financial calendar instance, allowing for account definitions to be valid only within certain date ranges. This design supports fiscal year changes and period-specific accounting rules. The table is an "ALL" table, indicating it is a multi-organization structure that can store data for multiple operating units, a standard pattern in Oracle EBS.

Common Use Cases and Queries

This table is primarily referenced for configuring and validating the GL accounts used in student financial transactions. Common operational and reporting scenarios include validating the account codes used in fee assessments, refunds, and credit memos; generating period-end financial reports for student receivables; and troubleshooting transaction posting errors to the general ledger. A typical query would join this table to transaction headers or control tables to retrieve the account description for a given code.

  • Sample Query to Validate Account Code:
    SELECT account_cd, description FROM igs_fi_acc_all WHERE account_cd = :p_account_cd AND org_id = :p_org_id;
  • Use Case: Identifying all transaction types configured to use a specific revenue account for audit purposes.

Related Objects

The IGS_FI_ACC_ALL table is a central hub with numerous foreign key dependencies, as documented. Key related objects include:

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

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_CONTROL_ALL,  object_name:IGS_FI_CONTROL_ALL,  status:VALID,  product: IGS - Student System ,  description: This table stores a flag to indicate if Oracle Accounts Receivables is installed or not. ,  implementation_dba_data: IGS.IGS_FI_CONTROL_ALL , 

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

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_F_TYP_CA_INST_ALL,  object_name:IGS_FI_F_TYP_CA_INST_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the periods of fee assessment fee calendar instances applicable to a fee type. ,  implementation_dba_data: IGS.IGS_FI_F_TYP_CA_INST_ALL , 

  • Table: IGS_FI_EXT_INT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_EXT_INT_ALL,  object_name:IGS_FI_EXT_INT_ALL,  status:VALID,  product: IGS - Student System ,  description: This table is used as a source for the entry of all external charges from any third party. ,  implementation_dba_data: IGS.IGS_FI_EXT_INT_ALL , 

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

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_APP_REQ,  object_name:IGS_AD_APP_REQ,  status:VALID,  product: IGS - Student System ,  description: Holds applicant's application requirements ,  implementation_dba_data: IGS.IGS_AD_APP_REQ , 

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

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_REFUNDS,  object_name:IGS_FI_REFUNDS,  status:VALID,  product: IGS - Student System ,  description: Stores all refund transactions which have been created due to excess unapplied credits. ,  implementation_dba_data: IGS.IGS_FI_REFUNDS , 

  • View: IGSFV_PARTY_REFUNDS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PARTY_REFUNDS,  object_name:IGSFV_PARTY_REFUNDS,  status:VALID,  product: IGS - Student System ,  description: Stores all refund transactions, which have been created due to excess unapplied credits. ,  implementation_dba_data: APPS.IGSFV_PARTY_REFUNDS , 

  • Table: IGS_OR_UNIT_ACCT_CD_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_OR_UNIT_ACCT_CD_ALL,  object_name:IGS_OR_UNIT_ACCT_CD_ALL,  status:VALID,  product: IGS - Student System ,  description: This table contains revenue account string information for an organization unit ,  implementation_dba_data: IGS.IGS_OR_UNIT_ACCT_CD_ALL , 

  • Table: IGS_FI_FTCI_ACCTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FTCI_ACCTS,  object_name:IGS_FI_FTCI_ACCTS,  status:VALID,  product: IGS - Student System ,  description: For a Fee Type Calendar Instance, Revenue Account Code or the Natural Account Segment for the combination of attributes will be stored in this table. ,  implementation_dba_data: IGS.IGS_FI_FTCI_ACCTS , 

  • View: IGSFV_PARTY_CHARGES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PARTY_CHARGES,  object_name:IGSFV_PARTY_CHARGES,  status:VALID,  product: IGS - Student System ,  description: Contains details of charges for a person ,  implementation_dba_data: APPS.IGSFV_PARTY_CHARGES , 

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

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_LOCATIONS,  object_name:IGSFV_LOCATIONS,  status:VALID,  product: IGS - Student System ,  description: This entity describes available physical locations ,  implementation_dba_data: APPS.IGSFV_LOCATIONS , 

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

  • View: IGS_FI_ACC 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_ACC,  object_name:IGS_FI_ACC,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_FI_ACC , 

  • Table: IGS_AD_LOCATION_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_LOCATION_ALL,  object_name:IGS_AD_LOCATION_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes available geographic locations at which programs and units may be offered or taught ,  implementation_dba_data: IGS.IGS_AD_LOCATION_ALL , 

  • View: IGSFV_HIGH_ED_PROG_VERSIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_HIGH_ED_PROG_VERSIONS,  object_name:IGSFV_HIGH_ED_PROG_VERSIONS,  status:VALID,  product: IGS - Student System ,  description: This entity describes Program Versions including information about the intermission, financial aid, supplemental exams , minimum and maximum credit points. ,  implementation_dba_data: APPS.IGSFV_HIGH_ED_PROG_VERSIONS , 

  • View: IGSFV_UNIT_OFFERING_OPTIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_UNIT_OFFERING_OPTIONS,  object_name:IGSFV_UNIT_OFFERING_OPTIONS,  status:VALID,  product: IGS - Student System ,  description: This entity describes the Unit offering options with details about the unit section, grading schema details, attendance requirements, special permission and grading indicators. ,  implementation_dba_data: APPS.IGSFV_UNIT_OFFERING_OPTIONS , 

  • Table: IGS_PS_UNIT_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_VER_ALL,  object_name:IGS_PS_UNIT_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a version of a unit, which is offered by the university. ,  implementation_dba_data: IGS.IGS_PS_UNIT_VER_ALL , 

  • Table: IGS_PS_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_VER_ALL,  object_name:IGS_PS_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the versions of programs which are offered by the university, covering both award and non-award programs. ,  implementation_dba_data: IGS.IGS_PS_VER_ALL , 

  • Table: IGS_PS_UNIT_OFR_OPT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_OFR_OPT_ALL,  object_name:IGS_PS_UNIT_OFR_OPT_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the available options for each unit offering. ,  implementation_dba_data: IGS.IGS_PS_UNIT_OFR_OPT_ALL , 

  • View: IGSFV_HIGH_ED_UNIT_VERSIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_HIGH_ED_UNIT_VERSIONS,  object_name:IGSFV_HIGH_ED_UNIT_VERSIONS,  status:VALID,  product: IGS - Student System ,  description: This entity describes the Unit version details with title information, important dates, maximum/minimum/increment points, details regarding enrolment with enrolment/offered load calendar types and sequence numbers. ,  implementation_dba_data: APPS.IGSFV_HIGH_ED_UNIT_VERSIONS ,