Results for “fv_ccr_vendors_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• CCR_ID — the surrogate primary key (constraint FV_CCR_VENDORS_PK), uniquely identifying each CCR registration record.
• VENDOR_ID — foreign key to PO_VENDORS, linking the CCR record to the supplier in Payables. This is the primary business linkage and a candidate for a business-key relationship.
• DUNS and PLUS_FOUR — the Dun & Bradstreet Data Universal Numbering System identifier and its location extension, the core federal vendor identifier.
• CAGE_CODE — the Commercial and Government Entity code used for federal contracting.
• LEGAL_BUS_NAME, DBA_NAME, DIVISION_NAME, DIVISION_NUMBER — legal and doing-business-as names.
• REGISTRATION_DATE and RENEWAL_DATE — dates marking CCR registration validity.
• CCR_STATUS and CCR_FLAG — registration status indicators.
• ST_ADDRESS1, CITY, STATE, POSTAL_CODE, COUNTRY — physical business address.
• TAXPAYER_ID and SOCIAL_SECURITY_NUMBER — federal tax identification.
• BUSINESS_TYPE1 through BUSINESS_TYPE10 — socio-economic business classifications.
• NAICS_CODE1–NAICS_CODE20, SIC_CODE1–SIC_CODE20, PSC_CODE and FSC_CODE series — industry and product service classifications.
• ANNUAL_REVENUE and AVG_NUM_EMPLOYEES — size and revenue metrics.
• BANK_ACCT_NUMBER, ABA_ROUTING, BANK_ACCT_TYPE, EFT_WAIVER — electronic funds transfer banking data.
• EXTRACT_CODE, LAST_IMPORT_DATE — import/processing tracking.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard EBS audit columns.

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.