OUTL-BRT- WACS_FPRC_ConfigProps

Maps PropertyName column to the respective Value column. Do not change the value in the PropertyName column.

OUTL-BRT-WACS_FPRC_Country

Maps Country values between Oracle Fusion Procurement Cloud and Oracle Utilities Work and Asset Cloud Service

 

Get WACS values from Admin > [C or General] > Country > Search

 

Get FPRC values from Manage > Geography Lookup

OUTL-BRT- WACS_FPRC_CurrencyCode

Maps Currency code between Oracle Fusion Procurement Cloud and Oracle Utilities Work and Asset Cloud Service

 

Get WACS values from Admin > [C or General] > Currency

 

Get FPRC values from Define Currency and Currency Rate > Manage Currency

OUTL-BRT- WACS_FPRC_DeliverToLocation

Maps between Oracle Fusion Procurement Cloud Deliver To Location Code and Oracle Utilities Work and Asset Cloud Service Ship To Location Code. In Oracle Utilities Work and Asset Cloud Service, Ship To Location is a storeroom.

 

Get WACS values from Admin > [S or Inventory] > Storeroom > Search

 

Get FPRC values from Procurement > Manage Location

OUTL-BRT-WACS_FPRC_Email_ID

Maps from and to recipient values to the mentioned email IDs. Configure multiple emails using a comma to separate the email IDs.

OUTL-BRT-WACS_FPRC_FOB

Maps FOB values between Oracle Fusion Procurement Cloud and Oracle Utilities Work and Asset Cloud Service

 

Get WACS values from Admin > [F or Purchasing] > Free On Board > Search

 

Get FPRC values from Manage > Freight Terms Lookup

OUTL-BRT-WACS_FPRC_InvoiceLineType

Maps Invoice Line Type Code between Oracle Fusion Procurement Cloud and Oracle Utilities Work and Asset Cloud.

 

Get WACS values from Admin > L or Database > Lookup > Search > Search for INVOICE_ITEM_TYPE_FLG

 

Get FPRC values from Manage > Setup and Maintenance > Manage Invoice Option

OUTL-BRT- WACS_FPRC_ItemTypeCode

Maps between Oracle Fusion Procurement Cloud Item Type Code and Oracle Utilities Work and Asset Cloud Service Item Type Code.

 

Get WACS values from Admin > L or Database > Lookup > Search > Search for ITEM_TYPE_FLG

 

Get FPRC values from Define > Purchase Order Line Type

OUTL-BRT- WACS_FPRC_PaymentTerm

Maps Payment Term values between Oracle Fusion Procurement Cloud to Oracle Utilities Work and Asset Cloud Service.

 

Get WACS values from Admin > P or Purchasing > Payment Terms > Search

 

Get FPRC values from Financials > Manage Payment Terms

OUTL-BRT-WACS_FPRC_PaymentType

Maps between Oracle Fusion Procurement Cloud Payment Type and Oracle Utilities Work and Asset Cloud Service Check Type Code.

 

Get WACS values from Admin > L or Database > Lookup > Search > Search for CHECK_TYPE_FLG (Customizable)

 

Get FPRC values from Financial > Define Payment method

OUTL-BRT- WACS_FPRC_POLineStatus

Maps Oracle Fusion Procurement Cloud Document Status Code to Oracle Utilities Work and Asset Cloud Service PO Status Code.

 

Sample values:

FPRC -OPEN, CANCELED, FINALLY CLOSED

WACS - ISSUED, CANCELED, CLOSED

OUTL-BRT- WACS_FPRC_POStatus

Maps Oracle Fusion Procurement Cloud Document Status Code to Oracle Utilities Work and Asset Cloud Service PO Status Code.

 

Sample values:

FPRC - OPEN, CANCELED, FINALLY CLOSED

WACS - ISSUED, CLOSED

OUTL-BRT-WACS_FPRC_State

Maps state values between Oracle Fusion Procurement Cloud and Oracle Utilities Work and Asset Cloud Service

 

Get WACS values from Admin > [C or General] > Country > Search for a Country > State tab

 

Get FPRC values from Manage > Geography Lookup

OUTL-BRT-WACS_FPRC_UOM

Maps between Oracle Utilities Work and Asset Cloud Service UOM Code and Oracle Fusion Procurement Cloud UOM Name.

 

Get WACS values from Admin > U or Inventory > Unit Of Measure -Resource > Search

 

Get FPRC values from Manage > Unit of Measure

OUTL-BRT-WACS_FPRC_BCStatus

Maps between Oracle Fusion Procurement Cloud Blanket Contract status to Oracle Utilities Work and Asset Cloud Service Blanket Contract status

Sample values:

FPRC_Status: OPEN, CANCELED,WITHDRAWN, ON HOLD, FINALLY CLOSED

 

WACS Status: ACTIVE,CLOSED,SUSPENDED

OUTL-BRT-WACS_FPRC_BC_Category

Maps between Oracle Fusion Procurement Cloud Blanket Contract Category to Oracle Utilities Work and Asset Cloud Service Blanket Contract Category.

 

Note: This integration supports Blanket Purchase Agreement and Contract Purchase Agreement. Blanket Purchase Agreement must be configured as “BPA” in WACS, BLANKET_CATEGORY_FLG custom Lookup Contract Purchase Agreement must be configured as “CPA” in WACS, BLANKET_CATEGORY_FLG custom Lookup.

 

Get WACS values from Admin > [L or Database] > Lookup > Search for the lookup BLANKET_CATEGORY_FLG.

 

This lookup is a custom lookup with values defined by implementation. There is no system processing, but the values and descriptions will be used to indicate if the Blanket Contract is a Blanket Purchase Agreement (or Blanket Contract) or Contract Purchase Agreement.