Search Results payee_ext_bank_acct_id

Overview

FV_TPP_ASSIGNMENTS_V is a PL/SQL view owned by the APPS schema within the Federal Financials (FV) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It exposes third-party payment (TPP) assignment data maintained by Federal Financials so that Oracle Payables can pass beneficiary and payee information to Oracle Payments (IBY) during payment processing and document creation.

The view resolves the relationship between a beneficiary supplier and the third-party payee who is actually paid on that supplier's behalf — a common federal scenario such as a payroll agent, a shared service provider, or a designated payment agent. Because it joins AP supplier and supplier-site data against IBY external payee records, it serves as the bridge that lets Payables emit the correct payee attributes to the IBY payment engine. Its name follows the FV_TPP_ASSIGNMENTS family of objects, and its defining query is gated by two Federal conditions: the FV install flag (FV_INSTALL.ENABLED_YN = 'Y') and the FV_THIRD_PARTY_PAYMENT profile option set to 'Y'. The view also includes an effective-dating predicate (SYSDATE between START_DATE and the NVL of END_DATE to SYSDATE), so only currently active assignments are returned.

Although frequently discovered indirectly — users often reach it while investigating ap_supplier_sites_all, one of its primary base tables — the view is a supporting integration object rather than a general-purpose AP reporting view.

Underlying Base Objects

The documented base objects referenced by the view are:

• FV_TPP_ASSIGNMENTS_ALL (synonym) — the driving table, holding the third-party payment assignment rows, including ORIGINAL_SUPPLIER_ID, ORIGINAL_SUPPLIER_SITE_ID, EXT_PAYEE_ID, EXT_BANK_ACCOUNT_ID, START_DATE and END_DATE.
• AP_SUPPLIERS (synonym) — supplies the beneficiary party identifier (PARTY_ID).
• AP_SUPPLIER_SITES_ALL (synonym) — joined twice: once for the beneficiary supplier site (ASSA) and, in an outer join, for the payee supplier site (ASSA2).
• IBY_EXTERNAL_PAYEES_ALL (synonym) — supplies external payee attributes such as PAYEE_PARTY_ID, PARTY_SITE_ID, ORG_TYPE, PAYMENT_FUNCTION and SUPPLIER_SITE_ID.
• FV_INSTALL, FV_CCR_GRP and FND_PROFILE (packages) — used to enforce the Federal installation flag and the FV_THIRD_PARTY_PAYMENT profile condition.

The presence of AP_SUPPLIER_SITES_ALL as a double-joined base object is the reason a search for ap_supplier_sites_all surfaces this view; it is a dependency, not the subject, of the definition.

Key Columns

• BENEFICIARY_SUPPLIER_ID / BENEFICIARY_PARTY_ID — the supplier and party identifiers of the beneficiary (from FV_TPP_ASSIGNMENTS_ALL.ORIGINAL_SUPPLIER_ID and AP_SUPPLIERS.PARTY_ID).
• BENEFICIARY_SUPPLIER_SITE_ID / BENEFICIARY_PARTY_SITE_ID — the beneficiary supplier site and its associated party site.
• EXT_PAYEE_ID — the third-party payee key linking to IBY_EXTERNAL_PAYEES_ALL.
• PAYEE_PARTY_ID / PAYEE_PARTY_SITE_ID — HZ party identifiers for the person or organization that receives payment.
• PAYEE_SUPPLIER_ID / PAYEE_SUPPLIER_SITE_ID — the supplier record corresponding to the external payee.
• PAYEE_ORG_TYPE and PAYEE_PAYMENT_FUNCTION — IBY classification of the payee organization and its payment role, which drive payment routing and formatting.
• PAYEE_EXT_BANK_ACCT_ID — the external bank account used for disbursement, taken from the assignment row.

Common Use Cases and Queries

Typical uses include reconciling beneficiary-to-payee pairings for a period, verifying that an assignment is active before payment, and diagnosing why IBY received an unexpected payee. To list active assignments for a given supplier:

SELECT beneficiary_supplier_id,
       beneficiary_supplier_site_id,
       ext_payee_id,
       payee_supplier_id,
       payee_supplier_site_id,
       payee_payment_function
  FROM fv_tpp_assignments_v
 WHERE beneficiary_supplier_id = :p_vendor_id;

To trace the relationship back to the AP supplier site records referenced in the definition:

SELECT a.vendor_site_id,
       a.vendor_id,
       a.party_site_id,
       v.payee_supplier_id
  FROM ap_supplier_sites_all a,
       fv_tpp_assignments_v v
 WHERE a.vendor_site_id = v.beneficiary_supplier_site_id;

Because the view is filtered by SYSDATE and the profile-driven Federal conditions, queries will return no rows when FV_THIRD_PARTY_PAYMENT is not enabled, when the assignment has expired, or when FV installation is incomplete — a frequent source of confusion during troubleshooting.