Search Results fv_ccr_orgs

Overview

FV_CCR_ORGS is a table in the FV (Federal Financials) product/schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores information about the operating units that have access to each DUNS/DUNS+4 number. In effect, it functions as an access-control and association bridge between a CCR (Central Contractor Registration) supplier record and the operating units (ORG_ID) permitted to transact against that supplier's DUNS number. Each row represents one operating unit's authorization for one CCR vendor record.

The table carries 14 documented columns and is owned by the FV schema. Its unique key, FV_CCR_ORGS_UK (also documented as FV_CCR_ORGS_U1), is the composite of CCR_ID and ORG_ID, establishing the business-key grain as one row per CCR/organization pairing. Heuristically, based on the foreign-key structure mined from the metadata, this object is best modeled as a link table — a junction resolving a many-to-many relationship between CCR vendor records and operating units, carrying descriptive attributes. It is not a pure hub (its key is composite) and not a pure satellite (it holds its own FK references and status data).

Key Information Stored

The most important columns documented in the ETRM metadata include:

CCR_ID — Identifier of the parent CCR vendor record; part of the composite unique key and a foreign key to FV_CCR_VENDORS.
ORG_ID — The operating unit identifier; the second component of the composite unique key, defining which organization is granted access.
DUNS and PLUS_FOUR — The nine-digit DUNS number and its four-digit suffix that identify the supplier entity.
PAY_SITE_ID and MAIN_ADDRESS_SITE_ID — Foreign keys to PO_VENDOR_SITES_ALL identifying the supplier's payment site and main address site.
MAIN_ADDRESS_SITE_FLAG — Indicator of whether the referenced site is the main address site.
BANK_ACCOUNT_ID — Foreign key to AP_BANK_ACCOUNTS_ALL, associating a bank account with the CCR/organization row.
CONC_REQUEST_STATUS — Status of the concurrent request associated with processing the CCR organization record.
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns tracking who created and last modified each row.

No single-column surrogate primary key is documented; the business key is the CCR_ID/ORG_ID pair.

Common Use Cases and Queries

Typical usage centers on determining which operating units may transact with a given supplier DUNS, and on reconciling CCR vendor data to pay sites and bank accounts.

List operating units authorized for a CCR vendor: SELECT org_id FROM fv_ccr_orgs WHERE ccr_id = :ccr_id;
Join to CCR vendor records to retrieve supplier identity for a DUNS: SELECT o.org_id, v.* FROM fv_ccr_orgs o, fv_ccr_vendors v WHERE o.ccr_id = v.ccr_id AND o.duns = :duns;
Reconcile pay sites and bank accounts per organization: join PAY_SITE_ID and BANK_ACCOUNT_ID to PO_VENDOR_SITES_ALL and AP_BANK_ACCOUNTS_ALL.
Reporting on concurrent request status via CONC_REQUEST_STATUS for CCR synchronization jobs.

Related Objects

FV_CCR_VENDORS — parent CCR vendor table, joined on CCR_ID.
PO_VENDOR_SITES_ALL — referenced via MAIN_ADDRESS_SITE_ID and PAY_SITE_ID.
AP_BANK_ACCOUNTS_ALL — referenced via BANK_ACCOUNT_ID.
ORG_ID / HR operating unit definitions — resolve ORG_ID to an operating unit name.
Federal Financials CCR processing concurrent programs that populate and maintain this access table.

Table: FV_CCR_ORGS 12.1.1
owner:FV, object_type:TABLE, fnd_design_data:FV.FV_CCR_ORGS, object_name:FV_CCR_ORGS, status:VALID, product: FV - Federal Financials , description: This table stores information about the operating units with access to each DUNS/DUNS+4 number , implementation_dba_data: FV.FV_CCR_ORGS ,
Table: FV_CCR_ORGS 12.2.2
owner:FV, object_type:TABLE, fnd_design_data:FV.FV_CCR_ORGS, object_name:FV_CCR_ORGS, status:VALID, product: FV - Federal Financials , description: This table stores information about the operating units with access to each DUNS/DUNS+4 number , implementation_dba_data: FV.FV_CCR_ORGS ,
APPS.FV_CCR_GRP SQL Statements 12.1.1
APPS.FV_CCR_GRP SQL Statements 12.2.2
VIEW: FV.FV_CCR_ORGS# 12.2.2
owner:FV, object_type:VIEW, object_name:FV_CCR_ORGS#, status:VALID,
SYNONYM: APPS.FV_CCR_ORGS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:FV_CCR_ORGS, status:VALID,
SYNONYM: APPS.FV_CCR_ORGS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FV_CCR_ORGS, status:VALID,
VIEW: FV.FV_CCR_ORGS# 12.2.2
Table: PO_VENDOR_SITES_ALL 12.1.1
product: PO - Purchasing , description: Supplier sites , implementation_dba_data: Not implemented in this database ,
Table: PO_VENDOR_SITES_ALL 12.2.2
product: PO - Purchasing , description: Supplier sites , implementation_dba_data: Not implemented in this database ,
PACKAGE BODY: APPS.FV_CCR_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FV_CCR_GRP, status:VALID,
Table: FV_CCR_VENDORS 12.2.2
owner:FV, object_type:TABLE, fnd_design_data:FV.FV_CCR_VENDORS, object_name:FV_CCR_VENDORS, status:VALID, product: FV - Federal Financials , description: The FV_CCR_VENDORS table stores all the data from CCR that does not have a logical place in the Payables data model. It also stores a supplier reference, and its primary key is the internal identifier CCR_ID , implementation_dba_data: FV.FV_CCR_VENDORS ,
TABLE: FV.FV_CCR_ORGS 12.2.2
owner:FV, object_type:TABLE, fnd_design_data:FV.FV_CCR_ORGS, object_name:FV_CCR_ORGS, status:VALID,
TABLE: FV.FV_CCR_ORGS 12.1.1
owner:FV, object_type:TABLE, fnd_design_data:FV.FV_CCR_ORGS, object_name:FV_CCR_ORGS, status:VALID,
Table: FV_CCR_VENDORS 12.1.1
owner:FV, object_type:TABLE, fnd_design_data:FV.FV_CCR_VENDORS, object_name:FV_CCR_VENDORS, status:VALID, product: FV - Federal Financials , description: The FV_CCR_VENDORS table stores all the data from CCR that does not have a logical place in the Payables data model. It also stores a supplier reference, and its primary key is the internal identifier CCR_ID , implementation_dba_data: FV.FV_CCR_VENDORS ,
PACKAGE BODY: APPS.FV_CCR_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FV_CCR_GRP, status:VALID,
PACKAGE BODY: APPS.FV_CCR_DATA_LOAD_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FV_CCR_DATA_LOAD_PKG, status:VALID,
PACKAGE BODY: APPS.FV_CCR_DATA_LOAD_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FV_CCR_DATA_LOAD_PKG, status:VALID,
PACKAGE BODY: APPS.FV_CCR_GRP 12.2.2
PACKAGE BODY: APPS.FV_CCR_UTIL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FV_CCR_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.FV_CCR_UTIL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FV_CCR_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.FV_CCR_GRP 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.FV_CCR_UTIL_PVT SQL Statements 12.1.1
APPS.FV_CCR_UTIL_PVT SQL Statements 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 FND Design Data 12.1.1
12.2.2 DBA Data 12.2.2
Table: AP_BANK_ACCOUNTS_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_BANK_ACCOUNTS_ALL, object_name:AP_BANK_ACCOUNTS_ALL, status:VALID, product: AP - Payables , implementation_dba_data: AP.AP_BANK_ACCOUNTS_ALL ,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
Table: AP_BANK_ACCOUNTS_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_BANK_ACCOUNTS_ALL, object_name:AP_BANK_ACCOUNTS_ALL, status:VALID, product: AP - Payables , implementation_dba_data: AP.AP_BANK_ACCOUNTS_ALL ,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.FV_CCR_GRP dependencies on FV_CCR_ORGS 12.1.1
APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_ORGS 12.2.2
APPS.FV_CCR_UTIL_PVT dependencies on FV_CCR_ORGS 12.1.1
APPS.FV_CCR_UTIL_PVT dependencies on FV_CCR_ORGS 12.2.2
APPS.FV_CCR_GRP dependencies on FV_CCR_ORGS 12.2.2
APPS.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_ORGS 12.1.1
PACKAGE BODY: APPS.FV_CCR_UTIL_PVT 12.2.2
PACKAGE BODY: APPS.FV_CCR_UTIL_PVT 12.1.1
APPS.FV_CCR_UTIL_PVT dependencies on HR_ORGANIZATION_UNITS 12.2.2
APPS.FV_CCR_UTIL_PVT dependencies on HR_ORGANIZATION_UNITS 12.1.1
APPS.FV_CCR_UTIL_PVT dependencies on PO_VENDOR_SITES_ALL 12.2.2
APPS.FV_CCR_GRP dependencies on FV_CCR_VENDORS 12.2.2
APPS.FV_CCR_GRP dependencies on FV_CCR_VENDORS 12.1.1
APPS.FV_CCR_DATA_LOAD_PKG SQL Statements 12.2.2