Search Results fv_tpp_pay_flag

Overview

FV_TPP_ASSIGNMENTS_V is an APPS-owned reporting view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that exposes active third-party payment (TPP) assignments configured for suppliers and supplier sites. The view is central to the EBS functionality commonly searched under the term fv_third_party_payment, which addresses scenarios in which an invoice is entered against a beneficiary supplier but the actual disbursement is issued to a different payee. This arrangement supports procurement models such as drop-shipment, factored or assigned receivables, agent/principal relationships, and centralized or decentralized payment processing.

The view consolidates the assignment record held in FV_TPP_ASSIGNMENTS_ALL with the associated supplier, supplier site, and external payee definitions, and it derives additional attributes through the FV_CCR_GRP package. It functions as the principal read interface for reporting on and validating third-party payment configuration, and it is typically consumed by payment formatting, reporting, and integration components that need to resolve beneficiary and payee relationships at a given point in time.

Underlying Base Objects

The view is defined over the following documented base objects:

• FV_TPP_ASSIGNMENTS_ALL (synonym) — the primary assignment table, supplying the beneficiary supplier ID, beneficiary supplier site ID, external bank account ID, and the effective start and end dates of the assignment.
• AP_SUPPLIERS (synonym) — supplies the beneficiary party ID for the originating supplier.
• AP_SUPPLIER_SITES_ALL (synonym) — joined twice: once (ASSA) to obtain the beneficiary party site ID for the original supplier site, and once (ASSA2, outer-joined) to derive the payee supplier ID associated with the external payee's supplier site.
• IBY_EXTERNAL_PAYEES_ALL (synonym) — supplies the external payee, payee party, payee party site, payee supplier site, organization type, and payment function.
• FV_CCR_GRP (package) — invoked through SELECT_BANK_ACCOUNT and SELECT_THIRD_PARTY to resolve the payee's external bank account and to determine the third-party payment flag.
• FV_INSTALL (package) and FND_PROFILE (package) — used in the WHERE clause to gate the view on the installation status (FV_INSTALL.ENABLED_YN = 'Y') and the FV_THIRD_PARTY_PAYMENT profile option.

The definition enforces currency-effective filtering (SYSDATE between START_DATE and NVL(END_DATE, SYSDATE)) and joins the assignment to the payee through EXT_PAYEE_ID.

Key Columns

• BENEFICIARY_SUPPLIER_ID / BENEFICIARY_PARTY_ID — the supplier and party on whose behalf the payment is made.
• BENEFICIARY_SUPPLIER_SITE_ID / BENEFICIARY_PARTY_SITE_ID — the originating supplier site and its corresponding party site.
• EXT_PAYEE_ID, PAYEE_PARTY_ID, PAYEE_PARTY_SITE_ID — the external payee definition and its party-level identifiers.
• PAYEE_SUPPLIER_ID, PAYEE_SUPPLIER_SITE_ID — the supplier and supplier site acting as the actual payee.
• PAYEE_ORG_TYPE, PAYEE_PAYMENT_FUNCTION — the organization type and payment function characterizing the payee.
• PAYEE_EXT_BANK_ACCT_ID — resolved through FV_CCR_GRP.SELECT_BANK_ACCOUNT, returning the external bank account used for disbursement.
• FV_TPP_PAY_FLAG — derived via NVL(FV_CCR_GRP.SELECT_THIRD_PARTY(...), 'Y'), indicating whether third-party payment applies to the payee site.

Common Use Cases and Queries

Typical usage includes auditing active third-party payment assignments, reconciling beneficiary and payee relationships, validating bank account resolution for a payee site, and feeding downstream payment or reporting processes.

• List all active assignments:

  SELECT beneficiary_supplier_id, beneficiary_supplier_site_id,
         payee_supplier_id, payee_supplier_site_id, fv_tpp_pay_flag
  FROM   apps.fv_tpp_assignments_v;

• Retrieve the payee and bank account for a specific beneficiary:

  SELECT payee_supplier_id, payee_supplier_site_id,
         payee_ext_bank_acct_id, payee_payment_function
  FROM   apps.fv_tpp_assignments_v
  WHERE  beneficiary_supplier_id = :p_vendor_id;

• Identify assignments flagged for TPP payment:

  SELECT beneficiary_supplier_id, payee_supplier_id
  FROM   apps.fv_tpp_assignments_v
  WHERE  fv_tpp_pay_flag = 'Y';

Because the view is gated by the FV_THIRD_PAYMENT profile option and installation status, queries return rows only when third-party payment functionality is enabled for the environment.