Search Results fv_ccr_orgs_u1

Overview

The FV.FV_CCR_ORGS table is a Federal Financials (FV) schema object within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the association between Central Contractor Registration (CCR) vendor records — now maintained under the System for Award Management (SAM) — and the operating units that are authorized to transact against those records. Each row links a DUNS or DUNS+4 identifier to a specific organization (ORG_ID), thereby determining which operating units may access a given vendor registration.

From a heuristic Data Vault classification standpoint, the table exhibits the characteristics of a link entity. Its composite primary key (CCR_ID, ORG_ID) joins two business hubs — the CCR vendor registration and the operating unit — and the remaining attributes (pay site, main address site, bank account, and concurrent request status) behave as descriptive context carried on that relationship. The Data Vault classification should be regarded as a modeling suggestion rather than a documented designation.

Key Information Stored

The surrogate primary key is the composite unique index FV_CCR_ORGS_UK, implemented physically as index FV_CCR_ORGS_U1 on the columns (CCR_ID, ORG_ID) in the APPS_TS_TX_IDX tablespace. This pair is the business-key candidate that enforces one row per DUNS record per operating unit.

• CCR_ID — Internal numeric identifier for the DUNS/DUNS+4 record; foreign key to FV_CCR_VENDORS.
• ORG_ID — Operating unit identifier; the second half of the composite unique key.
• DUNS — The unique nine-digit number assigned by Dun & Bradstreet. Denormalized here for reporting convenience.
• PLUS_FOUR — The CCR-assigned suffix that differentiates multiple bank accounts held by the same vendor at the same physical location.
• PAY_SITE_ID — Supplier pay site; foreign key to PO_VENDOR_SITES_ALL.
• MAIN_ADDRESS_SITE_ID — Physical main address site; foreign key to PO_VENDOR_SITES_ALL.
• MAIN_ADDRESS_SITE_FLAG — Indicator used to designate a supplier site as the main address site.
• BANK_ACCOUNT_ID — Foreign key to AP_BANK_ACCOUNTS_ALL, identifying the associated remittance bank account.
• CONC_REQUEST_STATUS — Status of the CCR Data Processing concurrent program for this assignment; valid values are C (Completed) and E (Errored).

Standard Who columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) provide audit lineage. The table is stored in the APPS_TS_TX_DATA tablespace with PCTFREE 10.

Common Use Cases and Queries

Typical reporting scenarios include identifying which operating units have visibility to a given vendor DUNS, reconciling CCR assignments across business groups, and diagnosing failures of the CCR Data Processing concurrent program. Because CONC_REQUEST_STATUS is the only error-tracking column on the row, failure diagnostics frequently begin with a status filter.

To list all operating units assigned to a DUNS:

• SELECT o.ccr_id, o.org_id, o.duns, o.plus_four, o.conc_request_status FROM fv.fv_ccr_orgs o WHERE o.duns = :p_duns ORDER BY o.org_id;

To isolate assignments whose processing errored:

• SELECT ccr_id, org_id, duns, plus_four FROM fv.fv_ccr_orgs WHERE conc_request_status = 'E';

To resolve pay-site and bank-account context for an assignment, join PO_VENDOR_SITES_ALL on PAY_SITE_ID and AP_BANK_ACCOUNTS_ALL on BANK_ACCOUNT_ID. Because ORG_ID is a native multi-org column, queries executed under a specific operating unit should filter or be secured accordingly.

Related Objects

The following objects participate in the documented relationship graph:

• FV.FV_CCR_VENDORS — referenced via FV_CCR_ORGS.CCR_ID; holds the parent DUNS/DUNS+4 registration.
• PO.PO_VENDOR_SITES_ALL — referenced twice, through PAY_SITE_ID and MAIN_ADDRESS_SITE_ID.
• AP.AP_BANK_ACCOUNTS_ALL — referenced via BANK_ACCOUNT_ID.
• FV_CCR_ORGS_U1 — unique index enforcing the (CCR_ID, ORG_ID) business key.
• HR_OPERATING_UNITS / FND_ORG_ACCESS — conventional sources for validating ORG_ID values.
• FND_USER / FND_LOGINS — targets of the standard Who columns for audit traversal.

The FND Design Data reference FV.FV_CCR_ORGS should be used when generating flexfield- or oracle-based metadata reports.