Search Results invoice_amount_due




Overview
Explore in AI Chat

Overview

The view IGS_FI_INV_INT belongs to the Oracle E-Business Suite product family IGS – Student System, a module classified as obsolete in Release 12.1.1 and 12.2.2. The object functions as an integration interface over student financial invoice data, consolidating billing, fee, and payment-processing attributes into a single denormalized projection. Its role is to expose invoice records to downstream consumers such as payment servers, receipt-processing routines, and external banking or credit-card gateways.

The view is defined with an organization-level security predicate that filters rows against the value stored in the USERENV('CLIENT_INFO') session context, restricting visibility to the currently selected operating unit. This is consistent with the multi-org architecture used throughout the Student System schema.

Where the user searches for customer_bank_account_id, the column is exposed directly by the view text and is relevant to direct-debit and ACH-style payment flows.

Underlying Base Objects

The documented view text selects exclusively from IGS_FI_INV_INT_ALL, the multi-organization base table that stores invoice-interface rows. No other base tables, synonyms, or joins are documented in the ETRM metadata; the ETRM record lists no referenced base objects, and the view is annotated as not implemented in this database.

Key Columns

Common Use Cases and Queries

Typical usage includes reviewing invoices routed through bank-account payment methods, reconciling payment-server responses, and auditing fee waiver processing.

  • Locate invoices settled against a specific customer bank account:
SELECT invoice_id, invoice_number, person_id,
       customer_bank_account_id, customer_bank_account_name,
       invoice_amount_due, payment_status
  FROM igs_fi_inv_int
 WHERE customer_bank_account_id = :p_bank_account_id
   AND org_id = :p_org_id;
  • Report payment-server errors for a processing run:
SELECT invoice_id, payment_server_order_number,
       payment_server_error_code, payment_server_error_msg
  FROM igs_fi_inv_int
 WHERE request_id = :p_request_id
   AND payment_server_error_code IS NOT NULL;
  • Reconcile direct-debit receipts against receipt methods by term and fee category.

Because the view is organization-secured, consumers must initialize CLIENT_INFO to the target operating unit; otherwise the predicate resolves to a default that may suppress rows. In Release 12.2.2 the object remains obsolete, and no base objects are documented in ETRM, so verification against the live data dictionary is advisable before relying on the view for new integrations.