Search Results recip_description




Overview
Explore in AI Chat

Overview

The view IGF_SL_RECIPIENT_V is a reporting and selection construct that belongs to the IGF — Financial Aid product family, which is flagged as Obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is narrow and specific: it presents the set of active recipients that may be selected by a concurrent program. In other words, it functions as a filtered lookup layer rather than a transactional or analytical object; it answers the question "which recipients are currently enabled and therefore eligible for selection?"

Because the product is obsolete, integrators and support analysts generally encounter this object only when auditing legacy Financial Aid customizations, tracing the source of a concurrent program's recipient list, or reviewing ETRM documentation. The metadata explicitly states that the view is not implemented in the database documented by ETRM, meaning the definition is retained for reference only and no live object is present in that instance.

Underlying Base Objects

The view text is documented as follows:

Two important facts follow from this definition. First, IGF_SL_RECIPIENT_V does not select directly from a base table; it selects from another view, IGF_SL_CL_RECIPIENT_V. The ETRM metadata lists no documented referenced base objects, so the chain terminates at the intermediate view as far as the published record is concerned. Second, the DISTINCT keyword and the ENABLED = 'Y' predicate together indicate that the underlying view may return duplicate recipient rows and rows for disabled recipients, and this wrapper exists to collapse duplicates and restrict output to enabled entries.

The column set exposed is limited to two attributes, confirming that this is a purpose-built selection view rather than a general-purpose recipient master view.

Key Columns

  • RECIPIENT_ID — The unique identifier for a recipient. This is the value bound to the concurrent program's selection parameter, and it is the natural join key when linking back to recipient-related tables or the underlying IGF_SL_CL_RECIPIENT_V view.
  • RECIP_DESCRIPTION — The human-readable label for the recipient, presented alongside the ID in the concurrent program's List of Values so users can identify recipients by name rather than number.

Note that ENABLED appears in the view's WHERE clause but is not projected as a column; it is a filter only.

Common Use Cases and Queries

The principal use case is supplying the List of Values for a concurrent program parameter that accepts a recipient. A typical query replicating the view logic is:

  • SELECT DISTINCT RECIPIENT_ID, RECIP_DESCRIPTION FROM IGF_SL_CL_RECIPIENT_V WHERE ENABLED = 'Y' ORDER BY RECIP_DESCRIPTION;

For validating a specific recipient before submission:

  • SELECT COUNT(*) FROM IGF_SL_RECIPIENT_V WHERE RECIPIENT_ID = :p_recipient_id;

For environments where the object is absent — as the ETRM metadata indicates for the documented instance — the equivalent query against the intermediate view (IGF_SL_CL_RECIPIENT_V) with the same ENABLED = 'Y' filter reproduces the intended behavior. Analysts reviewing legacy Financial Aid customizations should treat any dependency on IGF_SL_RECIPIENT_V as obsolete and confirm whether the concurrent program it served still exists.