Search Results fv_ccr_vendors




Overview
Explore in AI Chat

Overview

FV.FV_CCR_VENDORS is a Federal Financials (FV) module table within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores vendor registration and supplier profile data that originates from the Central Contractor Registration (CCR) system — the U.S. federal government's primary registrant database for entities doing business with the government — and that does not have a logical home in the standard Oracle Payables data model. This includes supplemental business classification, socio-economic, contact, banking, and Electronic Data Interchange (EDI) information collected during CCR registration.

The table also stores a supplier reference, allowing CCR records to be associated with the corresponding supplier definition maintained in Payables. Its primary key is the internal identifier CCR_ID. From a Data Vault modeling perspective, the FK structure suggests this object behaves as a satellite: it extends a parent supplier hub (PO_VENDORS) with descriptive, CCR-sourced attributes rather than defining the vendor's core identity. Each row is tied to a vendor and is further associated with registration organizations through the related FV_CCR_ORGS table.

Key Information Stored

The table is physically defined with 351 columns, reflecting the breadth of CCR registration data captured. The most operationally significant columns include:

Common Use Cases and Queries

Federal agencies use this table to report on and manage supplier registration data. Typical scenarios include retrieving a vendor's CCR details for verification, identifying registrations nearing renewal, and analyzing suppliers by socio-economic classification (e.g., small business, veteran-owned) for procurement reporting.

A common query pattern joins FV_CCR_VENDORS to PO_VENDORS to reconcile CCR data with the Payables supplier record:

  • SELECT c.DUNS, c.CAGE_CODE, c.LEGAL_BUS_NAME, c.REGISTRATION_DATE, c.RENEWAL_DATE, c.CCR_STATUS, p.VENDOR_NAME FROM FV_CCR_VENDORS c, PO_VENDORS p WHERE c.VENDOR_ID = p.VENDOR_ID;
  • Registrations approaching renewal: SELECT CCR_ID, DUNS, RENEWAL_DATE FROM FV_CCR_VENDORS WHERE RENEWAL_DATE BETWEEN SYSDATE AND SYSDATE+90;
  • Recent imports: SELECT CCR_ID, VENDOR_ID, LAST_IMPORT_DATE FROM FV_CCR_VENDORS WHERE LAST_IMPORT_DATE >= SYSDATE-7;
  • Socio-economic categorization: SELECT VENDOR_ID, BUSINESS_TYPE1, BUSINESS_TYPE2 FROM FV_CCR_VENDORS WHERE BUSINESS_TYPE1 IS NOT NULL;

Reporting use cases frequently aggregate by NAICS/SIC classification and by business type to support small-business utilization and diversity reports. The EXTRACT_CODE and CCR_FLAG columns support extract-processing reconciliation.

Related Objects

  • PO_VENDORS — referenced by FV_CCR_VENDORS.VENDOR_ID; the core Payables supplier definition. This is the principal FK relationship.
  • FV_CCR_ORGS — references this table via CCR_ID; holds CCR organization/registration data linked to a vendor record.
  • OKS_BILL_SUB_LINE_DTLS — references CCR_ID; part of the Service Contracts billing data model.
  • OKS_BSD_PR — references CCR_ID; Service Contracts billing detail supporting table.
  • FV_CCR_VENDORS_PK — the primary key constraint on CCR_ID.

The cluster of related objects establishes FV_CCR_VENDORS as a central supplier-registration reference within the federal procurement and contracts data flow, with downstream consumption in both Payables and Service Contracts.