Integration Overview
This section covers basic integration overview about the Vendor Locations integration. It includes the following:
Oracle Fusion Procurement Cloud (Vendor and Vendor Location) is the central repository of Vendor records. The key attributes will be captured from Oracle Fusion Procurement Cloud and synchronized with Oracle Utilities Work and Asset Management using the following two modes:
This seamless integration between Oracle Fusion Procurement Cloud and Oracle Utilities Work and Asset Management helps to have the same Vendor definition across both platforms.
The implementation details are available at: https://docs.oracle.com/en/cloud/saas/procurement/22d/oaprc/index.html
Design Details
This section focuses on the following:
Bulk (Initial Upload)
Bulk Upload will be the initial upload from Oracle Fusion Procurement Cloud to Oracle Utilities Work and Asset Management where all the Vendor and Vendor Location definitions are exported to UCM in the CSV format through BICC (an inbuilt functionality of Oracle Cloud). The selection of the Vendor in the Procurement module is done using BICC filters. The business may choose to import records based on the filter as per business requirement. Only active Vendors in the system are part of this integration.
Examples of attributes that are passed to Oracle Utilities Work and Asset Management in this integration are Vendor Name, Legal Entity, Business Unit, Location Details, Supplier End Dates, Supplier Site Status, Supplier Site Code, Supplierid, Suppliersiteid, etc. The Oracle Fusion Procurement Cloud schema needs a mapping with Oracle Utilities Work and Asset Management, and each field attribute is mapped to the corresponding value in Oracle Integration Cloud. These values will have a DVM for mapping between Oracle Utilities Work and Asset Management and Oracle Fusion Procurement Cloud.
Job Name: FPRC_VENDORS_LOCATIONS_BULK_WACS
Filter Conditions:
__DATASTORE__.BUShortCode='US1 Business Unit'
AND (__DATASTORE__.SupplierEndDateActive IS NULL
OR __DATASTORE__.SupplierEndDateActive>CURRENT_DATE)
AND __DATASTORE__.SupplierSiteStatus='ACTIVE'
AND ( __DATASTORE__.SupplierSitePurchasingSiteFlag='Y' OR __DATASTORE__.SupplierSitePaySiteFlag='Y')
 
Filtering Criteria:
Business Unit Name: Update the business unit name as per the implementation requirement/setup.
SupplierEndDateActive IS NULL: Active Supplier data
SupplierEndDateActive> Current Date: All future end dated Supplier data
SupplierSitePurchasingSiteFlag='Y' OR SupplierSitePaySiteFlag='Y': Bulk extract would filter enabled records of purchasing the Site flag OR Supplier Site Pay Site flag.
Incremental Update
Incremental Update will be an initial upload from Oracle Fusion Procurement Cloud to Oracle Utilities Work and Asset Management, where all the Vendor and Vendor Location definitions are exported to UCM in the CSV format through BICC (an inbuilt functionality of Oracle Cloud). The selection of the Vendor in the Procurement module is done using the BICC filters. The business may choose to import records based on the filter as per the business requirement. Active and inactive Vendors in the system are part of this integration.
Job Name: FPRC_VENDORS_LOCATIONS_INCR_WACS
Filter Conditions:
__DATASTORE__.BUShortCode='US1 Business Unit'
AND (__DATASTORE__.SupplierSitePurchasingSiteFlag='Y' OR __DATASTORE__.SupplierSitePaySiteFlag='Y')
AND (__DATASTORE__.SupplierEndDateActive IS NULL
OR __DATASTORE__.SupplierEndDateActive>=CURRENT_DATE)
 
Filtering Criteria:
Business Unit Name: Update the business unit name as per the implementation requirement/setup
SupplierEndDateActive IS NULL: Active Supplier data
SupplierEndDateActive>= Current Date: All future and current end dated supplier data
SupplierSitePurchasingSiteFlag='Y' OR SupplierSitePaySiteFlag='Y': Incremental extract would filter enabled records of purchasing site flag OR supplier site pay site flag.