Search Results srvc_non_ed_brc_id




Overview
Explore in AI Chat

Overview

APPS.IGF_SL_SERVICER_BRC_V is a reporting view within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, belonging to the Financials/Student Systems family of objects under the IGF and IGS schemas. The view exposes servicer records in which the party associated with a given servicer is flagged as a non-electronic ("non-ed") borrower relationship code, represented by the column SRVC_NON_ED_BRC_ID. Rather than storing data itself, the view consolidates servicer master data with institutional organization attributes to present a denormalized result set suitable for concurrent programs, Oracle Forms LOVs, BI Publisher reports, and inbound/outbound integration extracts.

Its primary role is to serve as a read-only presentation layer over the base servicer table, enriching each row with party number and party name derived from the institution organization view. This allows downstream consumers to resolve a raw numeric party identifier into a human-readable description without embedding additional joins in their own SQL.

Underlying Base Objects

Per the ETRM metadata, the view is defined with an outer-join relationship over two objects: IGF_SL_SERVICER_BRC (aliased SRVB) and IGS_OR_INST_ORG_BASE_V (aliased ORG). The join condition is SRVB.PARTY_ID = ORG.PARTY_ID(+), an Oracle-style outer join that preserves every servicer row even when no matching institution organization record exists. In such cases, the PARTY_NUMBER and PARTY_NAME columns return NULL.

The metadata lists no further documented base tables, indicating that IGS_OR_INST_ORG_BASE_V is itself a view supplying the party number and party name attributes. The ROWID of IGF_SL_SERVICER_BRC is exposed as ROW_ID, providing each servicer row with a unique physical locator that can be used for direct row-level access or updates where permitted.

Key Columns

  • ROW_ID — ROWID of the underlying IGF_SL_SERVICER_BRC row.
  • SERVICER_ID — Primary key identifying the servicer record.
  • SRVC_NON_ED_BRC_ID — The non-electronic borrower relationship code identifier requested in the user search; the identifying attribute that distinguishes this servicer configuration.
  • DESCRIPTION — Free-text description of the servicer or relationship code.
  • PARTY_ID — Foreign key to the trading party / organization associated with the servicer.
  • ENABLED — Flag indicating whether the servicer record is active.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit (WHO) columns.
  • PARTY_NUMBER, PARTY_NAME — Resolved from IGS_OR_INST_ORG_BASE_V for display and reporting.

Common Use Cases and Queries

Typical consumption includes reporting on active non-electronic servicer relationships, validating that servicer parties exist in the institution organization hierarchy, and populating descriptive fields in Oracle Forms and OAF pages. A representative query retrieves all enabled servicers with resolved party details:

  • SELECT servicer_id, srvc_non_ed_brc_id, description, party_number, party_name FROM apps.igf_sl_servicer_brc_v WHERE enabled = 'Y';
  • Filtering by the searched identifier: SELECT * FROM apps.igf_sl_servicer_brc_v WHERE srvc_non_ed_brc_id = :p_id;
  • Detecting orphaned servicers lacking organization data: SELECT servicer_id, party_id FROM apps.igf_sl_servicer_brc_v WHERE party_name IS NULL;

Because the view applies an outer join, LEFT JOIN semantics are guaranteed, and consumers should expect NULL party attributes for servicers whose PARTY_ID has no counterpart in IGS_OR_INST_ORG_BASE_V.