|Oracle U.S. Federal Financials User Guide|
Part Number E13551-04
The Office of Management and Budget (OMB) requires agencies to use information contained in the CCR as the source for making payments to vendors, with certain exceptions. Current and potential government vendors are required to register in CCR to be awarded contracts by any federal agency. Vendors provide basic information relevant to procurement and financial transactions.
The CCR Data Transfer:
Processes the data from the extract file
Processes updates to DUNS numbers as specified by users
This process can be:
Generated as a single concurrent request
Generated as the first part of the CCR Extract File request set
Note: The CCR Data Transfer Report is always generated and contains information on the DUNS/DUNS+4 numbers imported.
The CCR Data Processing:
Processes mapping of DUNS/DUNS+4 to suppliers and supplier sites
Calls the APIs to create or update Oracle Payables including suppliers, sites, bank branches, and bank accounts associated with DUNS/DUNS+4 number
This process can be:
Generated as the second part of the CCR Extract File request set
Generated from the Payables Assignment window after mapping a DUNS/DUNS+4 number to a supplier and supplier site in Payables and designating which operating unit has access to the supplier sites.
Note: The CCR Data Processing Report is always generated and contains information on the DUNS/DUNS+4 number processed.
The CCR Extract File request set includes:
CCR Data Transfer
CCR Data Processing
The CCR Extract File request set enables users to process the daily file after it is downloaded, decompressed, declassified, and placed in the correct directory.
The CCR XML concurrent process provides XML integration with CCR. This process enables users to:
Run an immediate query against CCR
Schedule a daily recurring query
The CCR Vendors Search page enables users to do the following. These can be performed for multiple operating units.
Locate CCR vendors’ records
View CCR information for a vendor
Add a new DUNS number to the E-Business Suite
Create or update Payables assignments for a DUNS/DUNS+4 number
Delete a DUNS number that has no Payables assignments
In the CCR Vendors pages, users can view:
Goods and services
Dun and Bradstreet data (XML only)
Points of contact such as electronic business, government contacts, and ownership contacts
When users add a new vendor, a new DUNS number is entered in the Add DUNS Number page as a placeholder record until the updates arrive from CCR. The CCR XML concurrent process can be generated from this page.
Note: When CCR XML is run from the ADD DUNS Number page, the process queries CCR for all new DUNS numbers in the E-Business Suite, not the ones entered in the page.
In the Payables Assignments page, you can do the following.
Create new suppliers, supplier sites, and associated bank accounts for a new DUNS/DUNS+4 number
Assign an existing supplier site to a DUNS/DUNS+4 number
Note: Users cannot assign suppliers for DUNS+4 numbers.
Automatically run the CCR Data Processing process by clicking Apply when changes to Payables are required
The agency must have sensitive level access to CCR extracts or sensitive XML access to use this integration.
The CCR extract files must be downloaded, decompressed, declassified, and placed in an accessible directory before processing. The file name should not be changed but a .dat extension must be added.
Federal suppliers should be defined as Federal agency vendors in Payables.
The following profile options must be defined:
FV: CCR XML Server
FV: Agency Proxy Server (optional)
FV: CCR Certificate File
The following federal options must be defined for each operating unit:
FV: CCR XML Username (optional)
FV: CCR XML Password (optional)
Oracle U.S. Federal Financials Setup Steps,Oracle U.S. Federal Financials Implementation Guide
Note: The CCR Extract File request set includes the CCR Data Transfer and the CCR Data Processing processes. These processes generate two reports when the processes are run as a request set.
To process the CCR files:
Navigate to the Submit Request window.
In the Request Set field, select CCR Extract File Request Set.
Click in the Parameters field for CCR Data Transfer.
In the File Location field, select the network or file system path pointing to the directory where the extract file is stored.
In the File Name field, enter the extract file name as it appears with the .dat extension.
In the File Type field, select the agency’s security level and file type.
The Update Type field defaults to the value All.
To run the CCR XML process:
Navigate to the Submit Request window.
In the Name field, select CCR XML.
To query by DUNS/DUNS+4 number, in the Query Type field, select either All, New, or Single.
If Single is selected, enter a specific DUNS number.
To query by CAGE Code, enter a CAGE code.
To query by taxpayer number, enter a taxpayer number.
To query by social security number, enter a social security number.
Enter a start or an end date time.
Enter a registration status.
In the Insert New Records field, select Yes or No to insert any records returned by the query that do not already exist in the E-Business Suite.
To view CCR information for a vendor, navigate to the CCR Vendors Search page.
You can enter any combination of search criteria in one of these fields:
Legal Business Name
Note: To create or update the Payables assignments for a DUNS/DUNS+4 number, return to the CCR Vendors Search page and click the Update Assignments icon. In the CCR Vendors Search page, no assignments exist if the Delete icon is enabled.
The following table describes selected fields on the CCR Vendors Search page.
|Operating Unit||Operating unit associated with the vendor.|
|DUNS Number||DUNS number/ navigates to the General Information page|
|CAGE/NCAGE||Commercial and Government Entity (CAGE) Code is a five-character ID number that identifies companies that do or wish to do business with the federal government. Foreign vendors use the NCAGE Code which means NATO CAGE Code.|
|Legal Business Name||Vendor's legal business name|
|Registration Status||Indicates the vendor's registration status as defined in the CCR|
|Update Assignments||Navigates to the Payables Assignments page. An enabled icon indicates that the DUNS number can be assigned to a Payables object or is already assigned to a Payables option. A disabled icon indicates the following:|
- no information for the DUNS number has been imported from the CCR; Unknown or Unregistered status
- record is a DUNS+4 whose root DUNS is not yet assigned to a supplier
|Delete||Deletes the record. A disabled icon indicates that the Paybles assignment must be deleted in the Payables Assignments page before the record can be deleted or that the record is a root DUNS number with DUNS+4 numbers in E-Business Suite.|
The following table describes selected fields on the Payables Assignments Page.
|Supplier||Existing supplier; If blank, a new supplier will be created.|
|Operating Unit||Operating unit associated with a supplier site.|
|Main Address Site||Main address site of the CCR Vendor that can be used for tax reporting purposes. If users select Yes, this site is associated with the assigned supplier with the physical location address information from the CCR. If users select no, a main address site is not created for the physical location address information. Only a payment site, using the remittance address information is created.
Note: This option is not available for a DUNS+4 number.
|Apply||Initiates the CCR Data Processing process to create or update pay sites with CCR information.|
Copyright © 1999, 2010, Oracle and/or its affiliates. All rights reserved.