Search Results fv_tpp_assignments_all

Overview

The FV_TPP_ASSIGNMENTS_ALL table is a core data object within the Oracle E-Business Suite Federal Financials (FV) module. As indicated by its description, it serves as the primary repository for defining and storing third-party payment assignments. In the context of U.S. federal financial management, a third-party assignment is a critical configuration that links a payment transaction to an external payee who is not the primary vendor or employee, a common requirement for specific disbursement types like grants, contracts, and certain benefit payments. This table is central to the Third Party Payment (TPP) functionality, enabling compliant payment processing and accurate financial reporting for federal agencies. Its role is to establish and maintain the necessary relationships between internal transaction data and external payee entities.

Key Information Stored

While the provided metadata does not list specific columns, the table's foreign key relationship and functional purpose define its critical data elements. The table's structure is designed to capture assignment metadata. A pivotal column is EXT_PAYEE_ID, which is a foreign key to the IBY_EXTERNAL_PAYEES_ALL table. This links the assignment to the master record of the external party (payee). Other essential columns typically include identifiers for the source transaction (such as an invoice or payment request ID), assignment amounts, status flags (e.g., active, canceled), and effective date ranges. The table also contains standard Oracle EBS audit columns like CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE, alongside the ORG_ID column to support multi-organization architecture.

Common Use Cases and Queries

This table is primarily accessed for payment processing validation, disbursement reporting, and audit inquiries. Common operational scenarios include verifying that a payment request has a valid third-party assignment before funds disbursement and generating reports detailing all third-party payments for a given period or program. A typical query would join this table to payee and transaction source tables to create a comprehensive payment register.

• Sample Query to List Active Assignments: SELECT tppa.assignment_id, tppa.ext_payee_id, ep.party_id FROM fv_tpp_assignments_all tppa, iby_external_payees_all ep WHERE tppa.ext_payee_id = ep.ext_payee_id AND tppa.org_id = :org_id AND SYSDATE BETWEEN tppa.start_date AND NVL(tppa.end_date, SYSDATE);
• Audit Trail: Queries against the audit columns (CREATED_BY, LAST_UPDATED_BY) are frequent during internal or external audits to trace the history of assignment setup and modifications.

Related Objects

The table has a direct and essential relationship with the Oracle Payments module. As documented, its primary foreign key references the IBY_EXTERNAL_PAYEES_ALL table, which is the master table for all external payee information within Oracle EBS. This relationship is fundamental, as the assignment is meaningless without the linked payee details. The FV_TPP_ASSIGNMENTS_ALL table itself is likely referenced by various Federal Financials forms, concurrent programs, and interfaces that manage the third-party payment lifecycle. It may also be joined to transaction source tables from the Payables (AP) or other feeder modules to provide a complete end-to-end view of the payment obligation and its assigned third-party recipient.