Results for “location_ovn”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IBY_F_LENDERS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IBY (Payments) product family. It exposes the master list of lender records configured in Oracle Payments, drawing on the external payment system / bank endpoint provider (IBY_BEPINFO) infrastructure. The view presents each lender together with its associated language configuration, default-provider flag, and primary billing address details sourced from the Oracle Trading Community Architecture (TCA) registry.

In EBS 12.1.1 and 12.2.2, the view serves as a denormalized, read-only representation of lenders suitable for reporting, extracts, and integration. Because lender data is assembled from multiple base tables at query time, the view removes the need for callers to reconstruct the many-to-many joins between payment providers, languages, and TCA party records. It is commonly referenced in payment reconciliation reports, vendor onboarding interfaces, and third-party payment integrations that require a lender name and remittance address.

Underlying Base Objects

The view is defined over seven documented objects, all referenced through APPS synonyms:

• IBY_BEPINFO — the primary source of lending provider records, filtered by BEP_TYPE = 'LENDER'.
• IBY_BEPLANGS — language and preference configuration, joined with an outer join (+).
• IBY_DEFAULT_BEP — identifies the default provider; an outer join here drives the DEFAULT_BEP_FLAG.
• HZ_PARTIES — supplies PARTY_ID and the derived LENDER_NAME.
• HZ_PARTY_SITES and HZ_PARTY_SITE_USES — filter to the identifying address and the BILL_TO site use marked as primary.
• HZ_LOCATIONS — provides the postal address components.

Note that several joins are outer joins, so lenders without a matching language, default provider, or TCA party record may still be returned.

Key Columns

• LENDER_NAME — the party name from HZ_PARTIES, the most frequently queried attribute.
• BEPID, BEP_TYPE, ACTIVESTATUS — provider identity, type, and status.
• DEFAULT_BEP_FLAG — 'Y' when the lender is the default provider; derived via DECODE.
• BEPLANG, PREFERRED — language and preference from IBY_BEPLANGS.
• BASEURL, SUFFIX, ADMINURL, LOGINURL, BEPUSERNAME — connectivity attributes.
• PARTY_ID, LOCATION_ID, ADDRESS1, ADDRESS2, CITY, STATE, POSTAL_CODE, COUNTRY — TCA identifiers and remittance address.

Common Use Cases and Queries

Typical scenarios include looking up a lender by name, listing active lenders with remittance addresses, and identifying the default provider for payment processing.

SELECT lender_name, city, state, country
FROM   apps.iby_f_lenders_v
WHERE  lender_name LIKE 'BANK%'
AND    activestatus = 'Y';

SELECT lender_name, default_bep_flag, beplang, preferred
FROM   apps.iby_f_lenders_v
WHERE  default_bep_flag = 'Y';

Because the view is not a table, no DML should be issued against it; always query it read-only.