Search Results igf_db_disb_holds




Overview
Explore in AI Chat

Overview

IGF_DB_DISB_HOLDS is a reporting view within the Oracle E-Business Suite Financial Aid (IGF) module. In the Oracle EBS 12.1.1 and 12.2.2 releases, the IGF product line is classified as obsolete, and the ETRM documentation for this object explicitly states "Not implemented in this database." This designation reflects the fact that the underlying base table, IGF_DB_DISB_HOLDS_ALL, is not seeded or created during a standard installation of the current application schema. The view therefore exists as metadata only: a definition that would surface disbursement hold records if the Financial Aid schema components were present.

Functionally, the view presents disbursement-level holds placed against award disbursements. A hold prevents or defers the release of funds associated with a specific disbursement number on a specific award. The view is a non-multi-org-style filtered variant of the _ALL table (despite carrying dual "DB" and "ALL" naming), applying an organization security predicate against the CLIENT_INFO session value.

Underlying Base Objects

The view is defined over a single documented base object: IGF_DB_DISB_HOLDS_ALL. No other base tables, synonyms, or views are documented as referenced objects in the ETRM metadata. The relationship is a straightforward projection with a WHERE clause. All columns in the view are passed through directly from the base table by column name; no joins, aggregations, or computed columns are present in the view text, aside from the exposed ROWID. The org filter compares NVL(ORG_ID, …) on the base table to a value derived from USERENV('CLIENT_INFO'), using a DECODE that treats a leading space as NULL and otherwise extracts the first ten bytes as the organization identifier, defaulting to -99. Because the base table itself is absent from current releases, any query against this view against a live 12.1.1 or 12.2.2 instance will fail with an invalid object reference unless a custom or migrated schema recreates the base table.

Key Columns

  • ROW_ID — The physical row identifier of the base record, exposed as HOLD.ROWID.
  • HOLD_ID — Primary identifier for the hold record.
  • AWARD_ID — Foreign key linking the hold to the award against which it was applied.
  • DISB_NUM — The disbursement number within the award that the hold restricts.
  • HOLD — The hold indicator or hold name associated with the record.
  • HOLD_TYPE — Classification of the hold, used to distinguish hold categories for reporting and release logic.
  • HOLD_DATE — Date the hold was placed.
  • RELEASE_FLAG — Flag indicating whether the hold has been released.
  • RELEASE_DATE — Date the hold was released, where applicable.
  • RELEASE_REASON — Free-text reason recorded at release time.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and last modified the record and when.

Common Use Cases and Queries

Because the object is obsolete, primary use cases are historical reconciliation, migration validation, and data-model documentation rather than active reporting. Analysts migrating or auditing legacy Financial Aid data may query it to determine which disbursements were held and whether holds were released before conversion.

To identify open (unreleased) disbursement holds for a given award:

  • SELECT hold_id, award_id, disb_num, hold_type, hold_date FROM igf_db_disb_holds WHERE award_id = :award_id AND NVL(release_flag,'N') = 'N';

To produce a hold-to-release audit trail:

  • SELECT award_id, disb_num, hold_type, hold_date, release_date, release_reason FROM igf_db_disb_holds WHERE release_date IS NOT NULL ORDER BY award_id, disb_num, hold_date;

In current 12.1.1 and 12.2.2 environments, such queries should be expected to raise ORA-00942 unless the obsolete IGF schema has been deliberately restored. Where IGF functionality is still required, it is typically delivered through successor or custom objects rather than this view.