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' |
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 |
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" |
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 |
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 ) |
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 ) |
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 |
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. |
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 |
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' |