Search Results duns_recip_id




Overview
Explore in AI Chat

Overview

IGF_SL_RECIPIENT_ALL_V is a consolidated Oracle EBS view owned by the APPS schema and defined within the Oracle Financials for the United States (IGF) product family — specifically the Student Loan (SL) module. It presents a uniform, denormalized list of all payment or disbursement recipients known to the Student Loan subsystem: lenders, guarantors, and servicers. Rather than forcing a reporting layer to query three separate master tables, the view unions them into a single result set with a consistent column profile, distinguished by the RECIPIENT_TYPE discriminator column.

The name is descriptive: "SL" denotes Student Loan, and "RECIPIENT_ALL" denotes a union of every recipient category. In EBS 12.1.1 and 12.2.2 the view is typically consumed by reports, extracts, and integration interfaces that need to enumerate or validate recipient records across all entity types — for example, to build a picklist of valid lenders, guarantors, and servicers, or to reconcile recipient configuration before loan processing runs. Because it is a view rather than a table, it holds no data of its own and always reflects the current state of its base tables.

Underlying Base Objects

The view is a UNION ALL of three legs over five base tables:

Notably, the guarantor leg exposes only the GUARANTOR_ID column (aliased as the shared identifier) and supplies empty literals for the branch columns. The outer joins ensure that a lender, servicer, or branch-less entity still appears even when no BRC (branch) row exists.

Key Columns

  • LENDER_ID / GUARANTOR_ID / SERVICER_ID — the first column of the union, aliased consistently across legs. This is the primary identifier for the recipient. For guarantors, this is the column the user's search term "guarantor_id" refers to.
  • RECIPIENT_TYPE — a literal discriminator: 'LND' for lender, 'GUARN' for guarantor, 'SRVC' for servicer.
  • Description columns (LEND_DESCRIPTION, DESCRIPTION, SRVC_DESCRIPTION) — the human-readable recipient name.
  • DUNS identifiers (DUNS_LENDER_ID, DUNS_GUARNT_ID, DUNS_SERVICER_ID) — external D-U-N-S numbers used for party identification and interfaces.
  • Enabled flags (LEND_ENABLED, ENABLED, SRVC_ENABLED) — whether the recipient is active and selectable.
  • BRC columns (LEND_NON_ED_BRC_ID, BRC_DESCRIPTION, BRC_ENABLED) — branch-specific data, populated for lenders and servicers and blank for guarantors.

Common Use Cases and Queries

The view supports recipient lookup and downstream interface population. A typical reporting query filters by type:

  • Enumerate all guarantors: SELECT GUARANTOR_ID, DESCRIPTION FROM APPS.IGF_SL_RECIPIENT_ALL_V WHERE RECIPIENT_TYPE = 'GUARN';
  • List every active recipient across categories: SELECT RECIPIENT_TYPE, LENDER_ID, DESCRIPTION, ENABLED FROM APPS.IGF_SL_RECIPIENT_ALL_V WHERE ENABLED = 'Y';
  • Resolve a recipient by DUNS number: SELECT RECIPIENT_TYPE, DESCRIPTION FROM APPS.IGF_SL_RECIPIENT_ALL_V WHERE DUNS_LENDER_ID = :duns OR DUNS_GUARNT_ID = :duns OR DUNS_SERVICER_ID = :duns;

Because the view performs UNION ALL without DISTINCT filtering, duplicate recipients can appear if a base entity is repeated. Queries should apply RECIPIENT_TYPE and ENABLED predicates to restrict results, and joins should use the unified ID column appropriate to the type.