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 | PUT | Outermosttag | |||||||
Template Parameters | PUT | Group | |||||||
$Var_ FPRCPRHeaderId | Field | FPRCRequisition HeaderId | Template Parameters | String | |||||
components.schemas.request-wrapper | PUT | Group | |||||||
$Var_ FPRCPRNumber | Field | FPRC_ReqNumber | components.schemas.request-wrapper | String | |||||
$Var_ WACSPRNumber | Field | WACS_ ReqNumber | components.schemas.request-wrapper | 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 | |||||||
PurchaseRequisitions | create | Group | |||||||
Requisitioning BUId | Purchase Requisitions | Int | OUTL-BRT-WACS_FPRC_ ConfigProps | PropertyName: fprc.businessunit. id | Value: Empty_RequisitionBUId | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
PreparerId | Purchase Requisitions | Int | OUTL-BRT-WACS_FPRC_Config Props | PropertyName : fprc.pr.preparer.id | Value : Empty_PreparerId | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
ERP_W1-PREQIMSG | Group | ||||||||
components.schemas.sendDetails_request | ERP_W1-PREQIMSG | Group | |||||||
sendDetails | components.schemas.sendDetails_ request | Group | |||||||
integrationDetails | sendDetails | Group | |||||||
headerInfo | integrationDetails | Group | |||||||
description | headerInfo | String | Description | Purchase Requisitions | String | ||||
InterfaceSource Code | Purchase Requisitions | String | OUTL-BRT-WACS_FPRC_Config Props | PropertyName : fprc.interface.sourcecode | Value: WACS | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
lineInfoList | lineInfo | Lineinfo list | ExternallyManagedFlag | Purchase Requisitions | Purchaserequisitions | OUTL-BRT-WACS_FPRC_Config Props | PropertyName: fprc.pr.externallymanage.flag | Value: true | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. |
requisitionInfo | Group | lines | Purchase Requisitions | Group | |||||
itemNumber | requisitionInfo | Decimal | LineNumber | lines | Float | ||||
itemType | requisitionInfo | String | LineTypeCode | lines | String | OUTL-BRT-WACS_FPRC_ItemTypeCode | WACS_ItemTypeCode | FPRC_LineTypeCode | Maps ERP Line Type Code to WACS Item Type Code and vice versa |
itemType | requisitionInfo | String | CategoryName | lines | String | OUTL-BRT-WACS_FPRC_ItemTypeCode | WACS_ItemTypeCode | FPRC_CategoryName | Only if (((ns40:resourceTypeExternalId = "") or not (ns40:resourceTypeExternalId ))) |
description | String | ItemDescription | lines | String | |||||
resourceType ExternalId | String | ItemId | lines | Int | |||||
quantity | requisitionInfo | Decimal | Quantity | lines | Float | ||||
$Var_WACSCurrencyCode | Field | CurrencyCode | lines | String | |||||
unitOfPurchase | requisitionInfo | String | UOM | lines | String | OUTL-BRT-WACS_FPRC_UOM | WACS_ UOMCode | FPRC_ UOMName | "When (ns40:requisitionInfo/ns36:unitOfPurchase) " |
OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName : fprc.default.uom | Value: | Otherwise | ||||||
unitPrice | requisitionInfo | Decimal | Price | lines | Float | ||||
initiatingBlanketContractHeaderExternalId | headerInfo | String | SourceAgreementHeaderId | lines | Int | "When (/nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integrationDetails/ns28:headerInfo/ns30:initiatingBlanketCategory = ""CPA"")" | |||
NegotiatedByPreparerFlag | lines | Boolean | Only if ( "cpa.negotiated config") = dvm:lookupValue ("tenant/resources/dvms/OUTL-BRT-WACS_FPRC_ConfigProps", "PropertyName", "cpa.negotiated config", "Value", "true" )) Hardcoded as "true" | ||||||
initiatingBlanketContractHeaderExternalId | headerInfo | String | Int | "When (((/nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integrationDetails/ns28:headerInfo/ns30:initiatingBlanketCategory = ""BPA"") and (ns40:blanketContractLineExternalId != """")))" | |||||
Boolean | Only if ( "bpa.negotiated config") = dvm:lookupValue ("tenant/resources/dvms/OUTL-BRT-WACS_FPRC_ConfigProps", "PropertyName", "bpa.negotiated config", "Value", "true" )) Hardcoded as "true" | ||||||||
blanketContractLine ExternalId | String | SourceAgreementLineId | lines | Int | Only if (((/nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integrationDetails/ns28:headerInfo/ns30:initiatingBlanketCategory = "BPA") and (ns40:blanketContractLineExternalId != ""))) | ||||
vendorLocation | headerInfo | Group | |||||||
vendorExternalId | vendorLocation | String | SupplierId | lines | Int | Only if (/nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integrationDetails/ns28:headerInfo/ns30:vendorLocation/ns31:vendorExternalId or (/nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integrationDetails/ns28:headerInfo/ns30:vendorLocation/ns31:vendorExternalId != " ")) | |||
vendorLocation ExternalId | vendorLocation | String | SupplierSiteId | lines | Int | Only if (/nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:inte grationDetails/ns28:header Info/ns30:ven dorLocation/ns31:vendorLocationExternalId or (/nssrcm pr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integrationDetails/ns28:headerInfo/ns30:vendorLocation/ns31:vendorLocationExternalId != "")) | |||
vendorPartNumber | requisitionInfo | String | SupplierItemNumber | lines | String | Only if (ns40:requisitionInfo/ns36:vendorPartNumber or (ns40:requisitionInfo/ns36:vendorPartNumber != "")) | |||
requisitionInfo | headerInfo | Group | |||||||
initiatorEmployee ExternalId | requisitionInfo | String | RequesterId | lines | Int | "When (/nssrcmpr:ERP_W1-PREQI MSG/nssrc mpr:components.schemas.sendDetails_request/ns38:send Details/ns42:integrationDetails/ns28:headerInfo/ns30:req uisitionInfo/ns37:initiatorEmployeeExternalId or (/nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integr ationDetails/ns28:headerInfo/ns30:requis itionInfo/ns37:initiatorEmployeeExternalId != """"))" | |||
OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName : fprc.pr.preparer.id | Value: Empty_PreparerId | Otherwise | ||||||
requiredByDate | requisitionInfo | Date | RequestedDeliveryDate | lines | String | "When (ns40:requisitionInfo/ns36:requiredByDate)" | |||
requiredByDate | requisitionInfo | Date | String | "When (not (ns40:requisitionInfo/ns36:requiredByDate ) and /nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integrationDetails/ns28:headerInfo/ns30:requisitionInfo/ns37:requiredByDate)" | |||||
urrent-date() + xsd:dayTimeDuration ("P7D") | |||||||||
DestinationTypeCode | lines | String | OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName: fprc.destinationtype.code | Value: EXPENSE | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
DestinationOrganizationCode | lines | String | OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName: fprc.destination.organization.code | Value: | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
shipToLocation | requisitionInfo | String | DeliverToLocationCode | lines | String | OUTL-BRT-WACS_FPRC_DeliverToLocation | WACS_ShipToLocation | FPRC_DeliverToLocationCode | "When (/nssrcmpr:ERP_W1-PREQIMSG/nssrcmpr:components.schemas.sendDetails_request/ns38:sendDetails/ns42:integrationDetails/ns28:headerInfo/ns30:requisitionInfo/ns37:shipToLocation)" |
OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName: fprc.default.delivertolocation.code | Value: | Otherwise | ||||||
DFF[2] | lines | Group | |||||||
$Var_WACSPR Number | Field | wacsPrNumC | DFF[2] | String | |||||
$Var_WACSPRHeaderId | Field | wacsPrHdrIdC | DFF[2] | String | |||||
costCenterList | accountingInfo | Costcenterlist | wacsPrLineIdC | DFF[2] | Lines | Hardcoded as 'WACS' | |||
accountingInfo | Group | distributions | lines | Group | |||||
quantity | Field | Quantity | distributions | Float | |||||
DistributionNumber | distributions | Float | Function : position () | ||||||
glAccount | String | ChargeAccount | distributions | String | |||||
DFF[2] | distributions | Field | Hardcoded as 'WACS' | ||||||
itngSourceSeg | DFF[2] | String | OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName: fprc.interface.sourcecode | Value: WACS | 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 | ERP_W1-PREQIMSG Response | Outermosttag | |||||||
components.schemas.responseDetails_response | ERP_W1-PREQIMSG Response | Group | |||||||
responseDetails | components.schemas.responseDetails_ response | Group | |||||||
$Var_FPRCPRNumber | Field | externalId | responseDetails | String |