Purchase Order Synchronization Process (Oracle Fusion Procurement Cloud Initiated)
This section describes data mapping for the Purchase Order Synchronization process initiated from Oracle Fusion Procurement Cloud.
WACS Purchase Order Synchronization
Oracle Utilities Work and Asset Cloud Service
Oracle Fusion Procurement Cloud
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM Name
Oracle Utilities Work and Asset Cloud Service
Oracle Fusion Procurement Cloud
 
 
 
Outermosttag
syncPurchaseOrder
 
Outermosttag
 
 
 
 
 
 
 
components.schemas.SYNCPURCHASEORDER_
request
syncPurchaseOrder
Group
 
 
 
 
 
 
 
W1PurOrdSync
components.schemas.SYNCPURCHASEORDER_
request
Group
 
 
 
 
 
 
 
input
W1PurOrdSync
Group
 
 
 
 
 
 
 
externalSystem
input
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName: wacs.externalsystem
Value:
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
onEvent
 
Group
 
 
 
 
 
 
 
getPurchaseOrder
Response
onEvent
Group
 
 
 
 
 
 
 
result
getPurchase
OrderResponse
Group
 
 
 
 
 
 
 
Value
result
Group
 
 
 
 
 
 
 
POHeaderId
Value
Long
externalReference
Id
input
String
 
 
 
 
 
 
 
purchaseOrder
input
Group
 
 
 
 
 
 
 
header
purchaseOrder
Group
 
 
 
 
POHeaderId
Value
Long
purchaseOrderHeaderExternalId
header
String
 
 
 
 
DocumentStatusCode
Value
String
status
header
String
OUTL-BRT-WACS_FPRC_POStatus
FPRC_POStatusCode
WACS_POStatusCode
Maps PO Status Code between Oracle ERP Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS)
OrderNumber
Value
String
purchaseOrderNumber
header
String
 
 
 
 
OrderRevision
Value
Decimal
revisionNumber
header
Decimal
 
 
 
 
DocumentDescription
Value
String
description
header
String
 
 
 
 
CreationDate
Value
Datetime-times
tamp
creationDateTime
header
Datetime
 
 
 
 
BuyerId
Value
Field
buyerEmployeeExternalId
header
String
 
 
 
 
 
 
 
issueDate
header
Date
 
 
 
Function: fn:current-date ()
PurchaseOrderLine
Value
Group
 
 
 
 
 
 
 
PurchaseOrderSchedule
PurchaseOrder
Line
Group
 
 
 
 
 
 
 
PurchaseOrder
Distribution
PurchaseOrderSchedule
Group
 
 
 
 
 
 
 
DeliverToLocationCode
PurchaseOrder
Distribution
String
shipToLocation
header
String
OUTL-BRT-WACS_FPRC_DeliverToLocation
FPRC_DeliverToLocationCode
WACS_ShipToLocation
Maps ERP Procurement Cloud Deliver To Location Code to WACS Ship To Location or vise versa. In WACS, Ship To Location is a storeroom.
SupplierSiteId
Value
Long
vendorLocationExternalId
header
String
 
 
 
 
CurrencyCode
Value
String
currency
header
String
OUTL-BRT-WACS_FPRC_CurrencyCode
FPRC_CurrencyCode
WACS_CurrencyCode
Maps Currency code between Oracle Procurement Cloud(FPRC) and Work and Asset Cloud Service (WACS)
ConversionRate
Value
Field
exchangeRate
header
Decimal
 
 
 
Only if (/nssrcmpr:onEvent/inp1:getPurchaseOrderResponse/inp1:result/ns31:Value/ns31:ConversionRate != "") Function : number (fn:format-number (number (/nssrcmpr:onEvent/inp1:getPurchaseOrderResponse/inp1:result/ns31:Value/ns31:ConversionRate ), "#.#######" ) )
FOBCode
Value
String
freeOnBoard
header
String
OUTL-BRT-WACS_FPRC_FOB
FPRC_FOB
WACS_FOB
Only if (/nssrcmpr:onEvent/inp1:get
PurchaseOrderResponse/inp1:result/ns31:Value/ns31:FOBCode)
PaymentTermsId
Value
Long
paymentTerms
header
String
OUTL-BRT-WACS_FPRC_PaymentTerm
FPRC_PaymentTerm
WACS_PaymentTerm
Only if (/nssrcmpr:onEvent/inp1:getPurchaseOrderResponse/inp1:result/ns31:Value/ns31:PaymentTermsId)
PurchaseOrderLine
Value
Purchaseorderline
lines
purchaseOrder
Lines
 
 
 
 
 
 
 
_data
lines
Group
 
 
 
 
POLineId
 
Long
purchaseOrderLineExternalId
_data
String
 
 
 
 
LineStatusCode
 
String
status
_data
String
OUTL-BRT-WACS_FPRC_POLineStatus
FPRC_POLineStatus
WACS_POLineStatus
Maps PO Line Status Code between Oracle ERP Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS).
ItemDescription
 
String
description
_data
String
 
 
 
 
LineNumber
 
Decimal
lineNumber
_data
Decimal
 
 
 
 
xmlns.oracle.com
 
Group
 
 
 
 
 
 
 
apps
xmlns.oracle.com
Group
 
 
 
 
 
 
 
prc
apps
Group
 
 
 
 
 
 
 
po
prc
Group
 
 
 
 
 
 
 
viewDocument
po
Group
 
 
 
 
 
 
 
publicFlex
viewDocument
Group
 
 
 
 
 
 
 
purchasingDocument
Line
publicFlex
Group
 
 
 
 
 
 
 
', 'Wacs
'purchasingDocumentLine
Field
purchaseRequisitionLineId
_data
String
 
 
 
Function: ns31:LineFlexfield[(fn:resolve-QName(@xsi:type, .) = fn:QName('http://xmlns.oracle.com/apps/prc/po/viewDocument/publicFlex/purchasingDocumentLine/', 'Wacs'))]/ns30:wacsPrLineIdC
SourceAgreement
Number
 
String
blanketContractNumber
_data
String
 
 
 
 
SourceAgreementLine
 
Decimal
blanketContractLineNumber
_data
Decimal
 
 
 
 
LineType
 
String
itemType
_data
Itemtype
OUTL-BRT-WACS_FPRC_ItemTypeCode
FPRC_LineTypeCode
WACS_Item
TypeCode
Maps ERP Line Type Code to WACS Item Type Code and vice versa
Quantity
 
Measuretype
quantity
_data
Decimal
 
 
 
Only if (ns31:Quantity != 0)
Price
 
Field
unitPrice
_data
Decimal
 
 
 
Function : number (fn:format-number (number (ns31:Price ), "#.#######" ) )
UnitOfMeasure
 
String
unitOfPurchase
_data
String
OUTL-BRT-WACS_FPRC_UOM
FPRC_UOMName
WACS_UOMCode
Maps UOM Code between Oracle ERP Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS)
PurchaseOrderSchedule
[1]
 
Group
 
 
 
 
 
 
 
NeedByDate
PurchaseOrderSchedule[1]
Date-date
requiredDate
_data
Date
 
 
 
 
PromisedDate
PurchaseOrderSchedule[1]
Date-date
promiseDate
_data
Date
 
 
 
 
SupplierItem
 
String
vendorPartNumber
_data
String
 
 
 
 
OrderedAmount
 
Field
lineAmount
_data
Decimal
 
 
 
Only if (ns31:OrderedAmount != 0) Function : number (fn:format-number (number (ns31:OrderedAmount ), "#.###" ) )