Receipts Synchronization Process (Oracle Utilities Work and Asset Cloud Service Initiated)
This section describes data mapping for the Receipts Order Synchronization process initiated from Oracle Utilities Work and Asset Cloud Service.
 
 
Receipts
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
APIInvocation
Error
 
Outermosttag
 
 
 
 
 
 
 
errorCode
APIInvocation
Error
String
 
 
 
Hardcoded as '400'
 
 
 
errorDetails
APIInvocation
Error
Group
 
 
 
 
$Var_ProcessingErrorCollection
 
Field
instance
errorDetails
String
 
 
 
 
 
 
 
errorCode
errorDetails
String
 
 
 
Hardcoded as '400'
Create Receipt
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
 
 
create
 
Outermosttag
 
 
 
 
 
 
 
ReceivingReceiptRequests
create
Group
 
 
 
 
 
 
 
ReceiptSourceCode
ReceivingReceiptRequests
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.source.code
Value : fprc.source.code.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
ERP_W1-RCPTOUTMS
 
Group
 
 
 
 
 
 
 
components.schemas.sendDetails_request
ERP_W1-RCPTOUTMS
Group
 
 
 
 
 
 
 
sendDetails
components.schemas.sendDetails_request
Group
 
 
 
 
 
 
 
receipt
sendDetails
Group
 
 
 
 
 
 
 
header
receipt
Group
 
 
 
 
 
 
 
vendorExternalId
header
String
VendorId
ReceivingReceiptRequests
Int
 
 
 
 
vendorLocationExternalId
header
String
VendorSiteId
ReceivingReceiptRequests
Int
 
 
 
 
 
 
 
BusinessUnitId
ReceivingReceiptRequests
Int
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.businessunit.id
Value : fprc.businessunit.id.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
 
 
OrganizationCode
ReceivingReceiptRequests
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.destination.organization.code
Value : fprc.destination.organization.code.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
description
header
String
Comments
ReceivingReceiptRequests
String
 
 
 
 
receivedByEmployeeExternalId
header
String
EmployeeId
ReceivingReceiptRequests
Int
 
 
 
When (/nssrcmpr:ERP_W1-RCPTOUTMS/nssrcmpr:components.schemas.sendDetails_request/ns25:sendDetails/ns93:receipt/ns91:header/ns90:receivedByEmployeeExternalId != """")
 
 
 
 
 
 
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName: fprc.emp.id
Value: fprc.emp.
id.error
Otherwise
receiptHeaderId
header
String
ExternalSystemTransactionReference
ReceivingReceiptRequests
String
 
 
 
 
 
 
 
DFF
ReceivingReceiptRequests
Dff
 
 
 
Hardcoded as "WACS"
purchaseOrderHeaderId
header
String
wacsPoHeaderId
DFF
String
 
 
 
 
_data
lines
_data
wacsRcptHeaderId
DFF
Receivingreceiptrequests
 
 
 
 
lines
receipt
Group
lines
ReceivingReceiptRequests
Group
 
 
 
 
 
 
 
TransactionType
lines
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.receipt.transationtype
Value : fprc.receipt.transationtype.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
 
 
AutoTransactCode
lines
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.receipt.autotransactcode
Value : fprc.receipt.autotransactcode.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
resourceTypeExternalId
 
String
ItemId
lines
Int
 
 
 
Only if (ns94:resourceTypeExternalId != "")
 
 
 
SourceDocumentCode
lines
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.source.doccode
Value : fprc.source.doccode.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
purchaseOrderNumber
header
String
DocumentNumber
lines
String
 
 
 
 
purchaseOrderHeaderExternalId
header
String
POHeaderId
lines
Int
 
 
 
 
purchaseOrderLineExternalId
 
String
POLineId
lines
Int
 
 
 
 
 
 
 
SoldtoLegalEntityId
lines
Int
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.soldtolegalentityid
Value : fprc.soldtolegalentityid.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
 
 
DestinationTypeCode
lines
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.destinationtype.code
Value : fprc.destinationtype.code.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
returnQuantity
 
Decimal
Quantity
lines
Float
 
 
 
 
unitOfPurchase
 
String
UnitOfMeasure
lines
String
OUTL-BRT-WACS_FPRC_UOM
WACS_UOMCode
FPRC_UOMName
Maps UOM Code between Oracle ERP Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS).
 
 
 
InterfaceSourceCode
lines
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.interface.sourcecode
Value : fprc.interface.sourcecode.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
description
 
String
Comments
lines
String
 
 
 
 
receiptLineId
 
String
ExternalSystemTransactionReference
lines
String
 
 
 
 
Close Purchase Order Lines
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
close
 
Outermosttag
 
 
 
 
 
 
 
Template
Parameters
close
Group
 
 
 
 
$Var_WACS_
POHeaderId
 
Field
id0
Template
Parameters
String
 
 
 
 
$Var_WACS_POLineId
 
Field
id1
Template
Parameters
String
 
 
 
 
 
 
 
actionRequest
close
Group
 
 
 
 
 
 
 
name
actionRequest
String
 
 
 
Hardcoded as 'close'
 
 
 
parameters
actionRequest
Group
 
 
 
 
 
 
 
closeAction
parameters
String
 
 
 
Hardcoded as "closeForReceiving"
Receipts 1
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
 
$FPRC_Receipts_
Response
 
Outermosttag
ERP_W1-RCPTOUTMSResponse
 
Outermosttag
 
 
 
 
createResponse
$FPRC_Receipts_Response
Group
components.schemas.responseDetails_response
ERP_W1-RCPTOUTMSResponse
Group
 
 
 
 
ReceivingReceipt
Requests
createResponse
Group
responseDetails
components.schemas.responseDetails_response
Group
 
 
 
 
ReceiptNumber
ReceivingReceiptRequests
String
externalId
responseDetails
String
 
 
 
 
FPRC Line Store Turn
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
getAll
 
Outermosttag
 
 
 
 
 
 
 
QueryParameters
getAll
Group
 
 
 
 
 
 
 
finder
QueryParameters
String
 
 
 
concat ("findLines;bindOrganizationCode=", $Var_OrgCode, " ,bindSourceDocumentCode=", $Var_SrcDocCode, ",bindPOLineId=", $Var_WACS_POLineId, ",bindPOHeaderId=", $Var_WACS_POHeaderId, ",bindReceiptNumber=", $Var_WACS_ReceiptNum )
FPRC Line Store Turn
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
getAll
 
Outermosttag
 
 
 
 
 
 
 
QueryParameters
getAll
Group
 
 
 
 
 
 
 
finder
QueryParameters
String
 
 
 
concat ("findLines;bindOrganizationCode=", $Var_OrgCode, " ,bindSourceDocumentCode=", $Var_SrcDocCode, ",bindPOLineId=", $Var_WACS_POLineId, ",bindPOHeaderId=", $Var_WACS_POHeaderId, ",bindReceiptNumber=", $Var_WACS_ReceiptNum )
Get Receiving Receipt Transaction Processing Error
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
getAll
 
Outermosttag
 
 
 
 
 
 
 
Template
Parameters
getAll
Group
 
 
 
 
$Var_ReceiptTxnReqIntTxnId
 
Field
id
Template
Parameters
String
 
 
 
 
Invoke Receipts Transaction Request
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
 
 
create
 
Outermosttag
 
 
 
 
 
 
 
ReceivingReceiptTransactionRequests
create
Group
 
 
 
 
 
 
 
TransactionType
ReceivingReceiptTransactionRequests
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.returns.transactiontype
Value : fprc.returns.transactiontype.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
 
 
OrganizationCode
ReceivingReceiptTransactionRequests
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.destination.organization.code
Value : fprc.destination.organization.code.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
$CurrentWAMRecLine
 
Group
 
 
 
 
 
 
 
_data
$CurrentWAMRecLine
Group
 
 
 
 
 
 
 
resourceTypeExternalId
_data
String
ItemId
ReceivingReceiptTransactionRequests
Int
 
 
 
 
 
 
 
ReceiptSourceCode
ReceivingReceiptTransactionRequests
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.source.code
Value : fprc.source.code.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
 
 
SourceDocumentCode
ReceivingReceiptTransactionRequests
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.source.doccode
Value : fprc.source.doccode.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
ERP_W1-RCPTOUTMS
 
Group
 
 
 
 
 
 
 
components.schemas.sendDetails_request
ERP_W1-RCPTOUTMS
Group
 
 
 
 
 
 
 
sendDetails
components.schemas.sendDetails_request
Group
 
 
 
 
 
 
 
receipt
sendDetails
Group
 
 
 
 
 
 
 
header
receipt
Group
 
 
 
 
 
 
 
purchaseOrderNumber
header
String
DocumentNumber
ReceivingReceiptTransactionRequests
String
 
 
 
 
 
 
 
SoldtoLegalEntityId
ReceivingReceiptTransactionRequests
Int
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.soldtolegalentityid
Value : fprc.soldtolegalentityid.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
 
 
DestinationTypeCode
ReceivingReceiptTransactionRequests
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.destinationtype.code
Value : fprc.destinationtype.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
returnQuantity
_data
Decimal
Quantity
ReceivingReceiptTransactionRequests
Float
 
 
 
 
$CurrentWAMRecLine
 
Group
 
 
 
 
 
 
 
_data
$CurrentWAMRecLine
Group
 
 
 
 
 
 
 
unitOfPurchase
_data
String
UnitOfMeasure
ReceivingReceiptTransactionRequests
String
OUTL-BRT-WACS_FPRC_UOM
WACS_UOMCode
FPRC_UOMName
Maps UOM Code between Oracle ERP Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS).
receivedByEmployeeExternalId
header
String
EmployeeId
ReceivingReceiptTransactionRequests
Int
 
 
 
When ($FPRC_LinesToReturn_Resp_G/nsmpr3:getAllResponse/nsmpr3:items/ns45:EmployeeId)
 
 
 
 
 
 
 
 
 
 
$FPRC_LinesToReturn_Resp_G
 
Group
 
 
 
 
 
 
 
getAllResponse
$FPRC_LinesToReturn_Resp_G
Group
 
 
 
 
 
 
 
items
getAllResponse
Group
 
 
 
 
 
 
 
ParentTransactionId
items
Int
ParentTransactionId
ReceivingReceiptTransactionRequests
Int
 
 
 
 
 
 
 
InterfaceSourceCode
ReceivingReceiptTransactionRequests
String
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.interface.sourcecode
Value : fprc.interface.sourcecode.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
 
 
BusinessUnitId
ReceivingReceiptTransactionRequests
Int
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.businessunit.id
Value : fprc.businessunit.id.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
 
 
CreateDebitMemoFlag
ReceivingReceiptTransactionRequests
Boolean
OUTL-BRT-WACS_FPRC_ConfigProps
PropertyName : fprc.returns.debitmemo.flg
Value : fprc.returns.debitmemo.flg.error
Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column.
 
Get Processing Error
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
getAll
 
Outermosttag
 
 
 
 
 
 
 
Template
Parameters
getAll
Group
 
 
 
 
$Var_HeaderInterfaceId
 
Field
id0
Template
Parameters
String
 
 
 
 
$Var_InterfaceTransactionId
 
 
id1
Template
Parameters
String
 
 
 
 
Get Receipt Error
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
getAll
 
Outermosttag
 
 
 
 
 
 
 
Template
Parameters
getAll
Group
 
 
 
 
$Var_HeaderInterfaceId
 
Field
id0
Template
Parameters
String
 
 
 
 
$Var_InterfaceTransactionId
 
 
id1
Template
Parameters
String
 
 
 
 
 
 
 
QueryParameters
getAll
Group
 
 
 
 
 
 
 
onlyData
QueryParameters
Boolean
 
 
 
Hardcoded as 'true'