Results for “external_fee_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_EXT_INT is an Oracle E-Business Suite (EBS) view owned by the APPS schema and delivered as part of the IGS – Student System product family. In EBS 12.1.1 and 12.2.2 it serves as the multi-organization reporting and interface layer for the external fee interface staging area used by the Student System's financial integration. The view exposes a filtered, business-facing projection of the underlying IGS_FI_EXT_INT_ALL table, presenting records that describe external fees awaiting import, validation, or posting to Oracle Receivables or the General Ledger.

Because the view is defined over an _ALL table, it participates in the standard EBS multi-org (Operating Unit) model, surfacing ORG_ID so that only organization-relevant rows are retrieved. It also adds a ROW_ID pseudo-column derived from ROWID, which is commonly used by Oracle Forms-based or OAF-based maintenance pages to uniquely identify a row for update and delete operations.

Underlying Base Objects

The view is defined as a straightforward projection of a single base object:

• IGS_FI_EXT_INT_ALL — the multi-org external fee interface table that physically stores the staged records, including application-owned WHO columns and the organization identifier.

No joins, unions, or additional tables are documented in the view text. Consequently, IGS_FI_EXT_INT should be treated as a convenience/security layer rather than a transformation layer: every column present in the _ALL table is exposed verbatim, with the sole addition of ROW_ID mapped from ROWID. Because the base table is the _ALL variant, the view inherits its DML and multi-org behavior, and any insert, update, or delete performed through the view ultimately affects the singular base row in IGS_FI_EXT_INT_ALL.

Key Columns

The columns returned by the view fall into several functional groups:

• Primary identifiers: ROW_ID (ROWID alias), EXTERNAL_FEE_ID, PERSON_ID.
• Fee definition: STATUS, FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, COURSE_CD, and CRS_VERSION_NUMBER.
• Transaction detail: TRANSACTION_DT, TRANSACTION_TYPE, TRANSACTION_AMOUNT, CURRENCY_CD, EXCHANGE_RATE, CHG_RATE, CHG_ELEMENTS, EFFECTIVE_DT, and GL_DATE.
• Accounting overrides: OVERRIDE_DR_REC_ACCOUNT_CD, OVERRIDE_DR_REC_CCID, OVERRIDE_CR_REV_ACCOUNT_CD, and OVERRIDE_CR_REV_CCID.
• Descriptive flexfields: ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20, COMMENTS.
• Lifecycle and audit: LOGICAL_DELETE_DT, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
• Concurrent program and multi-org context: REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID.
• Error handling: ERROR_MSG, which captures validation or posting failures for a staged record.

Common Use Cases and Queries

Typical scenarios include trouble-shooting failed interface rows, reconciling staged fees before posting, and reporting by course version. Sample queries:

• Locate records by course version:
  SELECT external_fee_id, person_id, status, course_cd, crs_version_number, transaction_amount, currency_cd FROM igs_fi_ext_int WHERE crs_version_number = :p_version AND org_id = :p_org_id;
• Identify errored interface rows:
  SELECT external_fee_id, status, error_msg, request_id FROM igs_fi_ext_int WHERE error_msg IS NOT NULL AND nvl(logical_delete_dt, sysdate+1) > sysdate;
• Trace a concurrent run:
  SELECT request_id, program_id, program_application_id, program_update_date, count(*) FROM igs_fi_ext_int GROUP BY request_id, program_id, program_application_id, program_update_date;

As crs_version_number is a first-class column, the view is particularly useful for validating that staged external fees are associated with the correct student course enrollment version prior to accounting entry generation.