Search Results igs_fi_inv_int_all




Overview
Explore in AI Chat

Overview

The IGS_FI_INV_INT_ALL table is a critical interface table within the Oracle E-Business Suite Student System (IGS) module, specifically for financial management. Its primary role is to serve as a staging area for invoice data generated by the system's invoice processing engine. As an interface table, it acts as an intermediary data store, holding transactional information that is typically processed further by other concurrent programs or application logic before being transferred to base transaction tables. This design facilitates data validation, error handling, and batch processing workflows. The table is multi-org enabled, as indicated by the '_ALL' suffix, meaning it stores data for multiple operating units with an ORG_ID column controlling data access and security.

Key Information Stored

The table's structure is designed to capture the core attributes of an invoice during its generation. The primary key is the INVOICE_ID, a unique system-generated identifier for each invoice record. Essential foreign key columns link the invoice to other central entities in the student financial ecosystem. The PERSON_ID column references HZ_PARTIES, connecting the invoice to the student or customer. The BILL_ID links to IGS_FI_BILL_ALL, associating the invoice with a specific bill or statement. The SUBACCOUNT_ID references IGS_FI_SUBACCTS_ALL, tying the invoice to a specific financial sub-account. Additional columns, such as FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER, provide context on the academic calendar period for the charges, while WAIVER_NAME can link to applicable fee waivers.

Common Use Cases and Queries

This table is central to troubleshooting and reporting on the invoice generation process. Common operational scenarios include identifying invoices pending further processing, reconciling data between the interface and base tables, and extracting raw invoice data for audit purposes. A typical query would join to the Parties and Bills tables to create a comprehensive invoice listing for a specific operating unit or person.

  • Sample Query for Invoice Interface Review:
    SELECT inv_int.invoice_id, inv_int.person_id, party.party_name, inv_int.bill_id, inv_int.creation_date
    FROM igs_fi_inv_int_all inv_int, hz_parties party
    WHERE inv_int.person_id = party.party_id
    AND inv_int.org_id = 123
    AND inv_int.creation_date > TRUNC(SYSDATE-1);
  • Data validation scripts often compare counts and amounts between IGS_FI_INV_INT_ALL and related transaction tables like IGS_FI_CREDITS_ALL to ensure processing completeness.
  • Support personnel query this table to investigate errors when downstream processes, such as credit creation or refund application, fail due to missing or invalid invoice source data.

Related Objects

The IGS_FI_INV_INT_ALL table has extensive relationships within the IGS Financials schema, acting as a source for numerous transactional entities. Based on the provided foreign key metadata, key relationships include:

These relationships demonstrate that the invoice record in this interface table is the progenitor for financial applications, waiver details, bill transactions, credit memos, payment plan attributes, special fees, other charges, refunds, and assessment orders, underscoring its foundational role in the student financial data model.

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

  • Table: IGS_AS_ORDER_HDR 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_ORDER_HDR,  object_name:IGS_AS_ORDER_HDR,  status:VALID,  product: IGS - Student System ,  description: Order Header Table ,  implementation_dba_data: IGS.IGS_AS_ORDER_HDR , 

  • Table: IGS_FI_INV_WAV_DET 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_INV_WAV_DET,  object_name:IGS_FI_INV_WAV_DET,  status:VALID,  product: IGS - Student System ,  description: Stores the waiver details of the charges present in the charges table ,  implementation_dba_data: IGS.IGS_FI_INV_WAV_DET , 

  • Table: IGS_FI_PP_STD_ATTRS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_PP_STD_ATTRS,  object_name:IGS_FI_PP_STD_ATTRS,  status:VALID,  product: IGS - Student System ,  description: This table stores attributes of Student Payment Plans ,  implementation_dba_data: IGS.IGS_FI_PP_STD_ATTRS , 

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

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_SPECIAL_FEES,  object_name:IGS_FI_SPECIAL_FEES,  status:VALID,  product: IGS - Student System ,  description: Stores Student Special Fees transactions ,  implementation_dba_data: IGS.IGS_FI_SPECIAL_FEES , 

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

  • 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_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: IGSBV_PARTY_REFUNDS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PARTY_REFUNDS,  object_name:IGSBV_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.IGSBV_PARTY_REFUNDS , 

  • View: IGSBV_PARTY_CHARGES 12.1.1

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

  • View: IGS_FI_EXT_CHGS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_EXT_CHGS_V,  object_name:IGS_FI_EXT_CHGS_V,  status:VALID,  product: IGS - Student System ,  description: Retrieves all the External Charges incurred by the student. ,  implementation_dba_data: APPS.IGS_FI_EXT_CHGS_V , 

  • View: IGSFV_AS_DOCUMENT_ORDERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_AS_DOCUMENT_ORDERS,  object_name:IGSFV_AS_DOCUMENT_ORDERS,  status:VALID,  product: IGS - Student System ,  description: Shows the Orders placed for Transcripts and Enrollment Certificates. ,  implementation_dba_data: APPS.IGSFV_AS_DOCUMENT_ORDERS , 

  • View: IGS_FI_INV_INT 12.1.1

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

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

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