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 | Outermosttag | ||||||||
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 | syncBlanket Contract | Outermosttag | |||||||
components.schemas.SYNCBLANKETCONTRACT_ request | syncBlanketContract | Group | |||||||
W1BlnktSyn | components.schemas.SYNCBLANKETCONTRACT_request | Group | |||||||
input | W1BlnktSyn | 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. | |||
$currentSegment | Group | ||||||||
G_BPA_CPA_ HEADER | $currentSegment | Group | |||||||
PO_HEADER_ID | G_BPA_CPA_HEADER | Integer | externalReferenceId | input | String | ||||
blanketContract | input | Group | |||||||
header | blanketContract | Group | |||||||
PO_HEADER_ID | G_BPA_CPA_HEADER | Integer | blanketContractHeaderExternalId | header | String | ||||
DOCUMENT_ NUMBER | G_BPA_CPA_HEADER | Field | blanketContractNumber | header | String | ||||
PO_REVISION_NUMBER | G_BPA_CPA_HEADER | Field | revisionNumber | header | Decimal | ||||
$currentSegment | Group | ||||||||
G_BPA_CPA_ HEADER | $currentSegment | Group | |||||||
DOCUMENT_STATUS | G_BPA_CPA_ HEADER | Field | status | header | String | OUTL-BRT-WACS_FPRC_BCStatus | FPRC_BC_Status | WACS_BC_Status | Maps Blanket Contract status code between Oracle Procurement Cloud(FPRC) and Work and Asset Cloud Service(WACS) |
TYPE_LOOKUP_ CODE | G_BPA_CPA_ HEADER | Field | blanketCategory | header | Blanketcategory | OUTL-BRT-WACS_FPRC_BCCategory | FPRC_BC_Category | WACS_BC_Category | Maps Blanket Contract Category between Oracle Procurement Cloud(FPRC) and Work and Asset Cloud Service(WACS) |
CREATION_DATE | G_BPA_CPA_HEADER | String | creationDateTime | header | Datetime | ||||
BLANKET_TOTAL_AMOUNT | G_BPA_CPA_HEADER | Field | limitAmount | header | Decimal | "When ($currentSegment/nsmpr3:G_BPA_CPA_HEADER/nsmpr3:BLANKET_TOTAL_AMOUNT)" | |||
OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName: wacs.default.bc.limit.amount | Value: | Otherwise | ||||||
START_DATE | G_BPA_CPA_HEADER | Field | initiationDate | header | Date | "When ($currentSegment/nsmpr3:G_BPA_CPA_HEADER/nsmpr3:START_DATE) Function : substring-before ($currentSegment/nsmpr3:G_BPA_CPA_HEADER/nsmpr3:START_DATE, ""T"" )" | |||
CREATION_DATE | G_BPA_CPA_HEADER | String | Otherwise Function : substring-before ($currentSegment/nsmpr3:G_BPA_CPA_HEADER/nsmpr3:CREATION_DATE, "T" ) | ||||||
END_DATE | G_BPA_CPA_HEADER | Field | expirationDate | header | Date | When ($currentSegment/nsmpr3:G_BPA_CPA_HEADER/nsmpr3:END_DATE) Function: substring-before ($currentSegment/nsmpr3:G_BPA_CPA_HEADER/nsmpr3:END_DATE, ""T"" ) | |||
OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName: wacs.default.bc.end.date | Value: | Otherwise | ||||||
VENDOR_SITE_ID | G_BPA_CPA_HEADER | Field | vendorLocationExternalId | header | String | ||||
CURRENCY_CODE | G_BPA_CPA_HEADER | Field | currency | header | String | OUTL-BRT-WACS_FPRC_CurrencyCode | FPRC_Currency Code | WACS_ CurrencyCode | Maps Currency code between Oracle Procurement Cloud(FPRC) and Work and Asset Cloud Service (WACS) |
FOB_LOOKUP_CODE | G_BPA_CPA_HEADER | Field | fob | header | String | OUTL-BRT-WACS_FPRC_FOB | FPRC_FOB | WACS_FOB | Maps FOB values between Oracle Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS). |
TERMS_ID | G_BPA_CPA_HEADER | Field | paymentTerms | header | String | OUTL-BRT-WACS_FPRC_PaymentTerm | FPRC_PaymentTerm | WACS_PaymentTerm | Maps Payment Term values between Oracle Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS) |
G_BPA_CPA_LINES | G_BPA_CPA_HEADER | Field | lines | blanketContract | Lines | ||||
_data | lines | Group | |||||||
PO_LINE_ID | Integer | blanketContractLineExternalId | _data | String | |||||
CREATION_DATE | G_BPA_CPA_HEADER | String | creationDateTime | _data | Datetime | ||||
ITEM_DESCRIPTION | String | description | _data | String | |||||
ITEM_ID | Integer | resourceTypeExternalId | _data | String | |||||
LINE_NUM | Integer | lineNumber | _data | Decimal | |||||
allowOnPo | _data | Allowonpo | When (((nsmpr3:LINE_STATUS = ""CANCELED"") or ((nsmpr3:LINE_STATUS = ""FINALLY CLOSED"") or (nsmpr3:LINE_STATUS = ""ON HOLD"")))) Hardcoded as ""W1NA"" | ||||||
Otherwise Hardcoded as "W1AL" | |||||||||
requisitionInfo | _data | Group | |||||||
LINE_LEVEL_PRICE | Integer | unitPrice | requisitionInfo | Decimal | |||||
AGREEMENT_UOM_NAME | Field | unitOfPurchase | requisitionInfo | 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). | |
purchaseToIssueRatio | requisitionInfo | Decimal | Function: $UOMVals_XML/nsmpr1:ReadResponse/ns26:root/ns26:UOMConvVals[ns26:ItemId = current()/nsmpr3:ITEM_ID and ns26:lineNum = current()/nsmpr3:LINE_NUM]/ns26:ConversionFactor | ||||||
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 | OutboundSOAP RequestDocument | Outermosttag | |||||||
Body | OutboundSOAPRequestDocument | Group | |||||||
GenericRequest | Body | Group | |||||||
Service | GenericRequest | Group | |||||||
Document | Service | Group | |||||||
$docID | Field | Field[1] | Document | Field | |||||
$docName | Field | Field[2] | Document | Field | |||||
$updatedDocTitle | Field | Field[3] | Document | Field | |||||
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 | OutboundSOAPRequestDocument | Outermosttag | |||||||
Body | OutboundSOAPRequestDocument | Group | |||||||
GenericRequest | Body | Group | |||||||
Service | GenericRequest | Group | |||||||
Document | Service | Group | |||||||
$docID | Field | Field | Document | Field | |||||
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 | |
$currenBCline | Outermosttag | create | Outermosttag | ||||||
G_BPA_CPA_LINES | $currenBCline | Group | UnitOfMeasureConversions | create | Group | ||||
AGREEMENT_UOM_CODE | G_BPA_CPA_LINES | String | FromUOM | UnitOfMeasureConversions | String | ||||
ITEM_PUR_UNIT_OF_ISSUE_CODE | G_BPA_CPA_LINES | String | ToUOM | UnitOfMeasureConversions | String | When (fn:exists ($currenBCline/nsmpr2:G_BPA_CPA_LINES/nsmpr2:ITEM_PUR_UNIT_OF_ISSUE_CODE ) and ($currenBCline/nsmpr2:G_BPA_CPA_LINES/nsmpr2:ITEM_PUR_UNIT_OF_ISSUE_CODE != """")) | |||
ITEM_PRI_UOM_ CODE | G_BPA_CPA_ LINES | String | Otherwise | ||||||
ITEM_ID | G_BPA_CPA_ LINES | Integer | ItemId | UnitOfMeasureConversions | 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 | Write | Outermosttag | |||||||
Response | Write | Group | |||||||
root | Response | Group | |||||||
$UOMConvResCol | Field | a | root | 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 | OutboundSOAPRequestDocument | Outermosttag | |||||||
Body | OutboundSOAPRequestDocument | Group | |||||||
GenericRequest | Body | Group | |||||||
Service | GenericRequest | Group | |||||||
Document | Service | Group | |||||||
$searchQuery | Field | Field[1] | Document | Field | |||||
Field[2] | Document | Field | Hardcoded as 'dInDate' | ||||||
Field[3] | Document | Field | Hardcoded as "Asc" | ||||||