Search Results duns_lender_id




Overview
Explore in AI Chat

Overview

IGF_SL_LENDER_V is a reporting view in the Oracle E-Business Suite IGF (Financial Aid) product family. In the ETRM documentation for Release 12.1.1 and 12.2.2, this object is catalogued under the module designation "IGF - Financial Aid (Obsolete)," and its implementation status is recorded as "Not implemented in this database." The view exposes lender records held in the Student Loan lender table, joined to an institutional organization base view, so that consumers see the lender identifier and description alongside the associated trading party and organization name. Its practical role is to provide a denormalized read interface over lender data for financial aid reporting, integration extracts, and downstream student loan processing that must resolve a lender to its party and institution context without duplicating the join logic.

Underlying Base Objects

The documented view text defines IGF_SL_LENDER_V over two referenced objects. The driving object is the base table IGF_SL_LENDER, aliased LND, which supplies the lender identifier, description, party identifier, enabled flag, and the standard Oracle EBS WHO columns. The second object is IGS_OR_INST_ORG_BASE_V, aliased ORG, a base view of institution organizations that supplies PARTY_NUMBER and PARTY_NAME. The join is an outer join on LND.PARTY_ID = ORG.PARTY_ID, meaning lender rows are preserved even when no matching institution organization party exists. The ETRM metadata records no documented base objects in the 12.2.2 object registry and states the implementation is not present in the documented database, so the view text itself is the authoritative definition. Both underlying objects reside in the IGF/IGS Financial Aid schema family.

Key Columns

  • ROW_ID — the ROWID of the underlying IGF_SL_LENDER row, usable as a surrogate key for tooling and updates.
  • LENDER_ID — the lender business identifier from the base table.
  • DESCRIPTION — the lender description or name.
  • DUNS_LENDER_ID — a hard-coded NULL in the view text; this column is the object of the "duns_lender_id" search, and the definition supplies no DUNS data. Any consumer expecting a D-U-N-S number will receive NULL.
  • PARTY_ID — the trading community party identifier linking the lender to its party record.
  • ENABLED — flag indicating whether the lender is active.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit (WHO) columns.
  • PARTY_NUMBER and PARTY_NAME — party attributes sourced from IGS_OR_INST_ORG_BASE_V.

Note that the documented column list also names INSTITUTION_CD and INSTITUTION_CD_DESC, while the published view text exposes PARTY_NUMBER and PARTY_NAME; consumers should verify the deployed definition in their environment.

Common Use Cases and Queries

Typical usage retrieves active lenders with their organization context for financial aid reports and extracts.

  • List enabled lenders: SELECT lender_id, description, party_name FROM igf_sl_lender_v WHERE enabled = 'Y';
  • Resolve a lender to its party: SELECT lender_id, party_id, party_number FROM igf_sl_lender_v WHERE party_id = :party_id;
  • Audit recently changed lender records: SELECT lender_id, description, last_updated_by, last_update_date FROM igf_sl_lender_v WHERE last_update_date >= :since;
  • Check DUNS availability: SELECT lender_id, duns_lender_id FROM igf_sl_lender_v; — this returns NULL for every row by definition.

Because the module is marked obsolete and the view is documented as not implemented, confirm availability against the target instance before relying on it in custom code.