Search Results fv_cust_vend_xrefs




Overview
Explore in AI Chat

Overview

FV_CUST_VEND_XREFS is a base table in the Federal Financials (FV) product of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores the AR/AP Netting Customer-Vendor Cross Reference definitions maintained through the AR/AP Netting Customer Vendor Cross Reference form. The table establishes the mapping between a Receivables customer and a Payables vendor, scoped by ledger, so that netting transactions can be generated and reconciled between the two subledgers. Because the mapping is defined at the set of books (ledger) level, the same customer and vendor combination can theoretically be cross-referenced differently across distinct ledgers.

From a data modeling perspective, the metadata suggests a satellite-leaning classification under a Data Vault heuristic. The table is anchored by a surrogate primary key and carries a business key composed of its ledger, customer, and vendor identifiers, which is characteristic of a satellite or a link-satellite rather than a standalone hub. This classification is a modeling suggestion derived from the key and foreign key structure rather than a prescribed Oracle design.

Key Information Stored

The table comprises 25 documented columns. The most significant include:

Two unique indexes act as business-key candidates: FV_CUST_VEND_XREFS_U2 on CUST_VEND_XREF_ID and FV_CUST_VEND_XREFS_U3 on the composite of SET_OF_BOOKS_ID, CUSTOMER_ID, and VENDOR_ID. The U3 index enforces that a given customer-vendor pairing is unique per ledger. The surrogate key, by contrast, is a system-generated identifier that carries no business meaning.

Common Use Cases and Queries

Typical usage centers on confirming or reporting netting relationships. A common query resolves a customer to its netting vendor within a ledger:

  • Join FV_CUST_VEND_XREFS to PO_VENDORS on VENDOR_ID to obtain vendor name and site details for a given CUSTOMER_ID and SET_OF_BOOKS_ID.
  • Detect duplicate or missing cross-references by grouping on SET_OF_BOOKS_ID, CUSTOMER_ID, and VENDOR_ID and comparing against the unique index expectations.
  • Reconcile netting activity by extracting all cross-references for a ledger and matching them against AR and AP transactions for the same customer and vendor.
  • Audit changes by filtering on LAST_UPDATE_DATE to identify recently maintained cross-references.

Flexfield attributes should be selected only when the installation has configured ATTRIBUTE_CATEGORY and the corresponding ATTRIBUTE segments.

Related Objects

The most significant related objects include:

  • PO_VENDORS — Referenced through the foreign key FV_CUST_VEND_XREFS.VENDOR_ID, providing vendor master information.
  • HZ_CUST_ACCOUNTS / RA_CUSTOMERS — Source of the CUSTOMER_ID value used for the Receivables side of the netting relationship.
  • GL_SETS_OF_BOOKS (FND_SETID_SETS) — Provides the ledger definition corresponding to SET_OF_BOOKS_ID.
  • FV_AR_AP_NETTING and related netting tables — Consume these cross-references when generating netting transactions.
  • The AR/AP Netting Customer Vendor Cross Reference form — The maintenance interface that inserts, updates, and deletes rows in this table.

Together these objects support the end-to-end federal netting workflow that this table underpins.