Returns Synchronization Process Mapping (Oracle Utilities Work and Asset Cloud Service Initiated)

This section describes data mapping for the Returns Synchronization process initiated by Oracle Utilities Work and Asset Cloud Service. The following are included:

• Get Line Store Turn

• Return Request

• Return Receipt

Get 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
			getAll		Outermosttag
			QueryParameters	getAll	Group
			onlyData	QueryParameters	Boolean				Hardcoded as "true"
			orderBy	QueryParameters	String				Hardcoded as 'TransactionDate:desc'
			finder	QueryParameters	String	findLines	;bindOrganizationCode=

Return Request

Oracle Utilities Work and Asset Cloud Service			Oracle Fusion Procurement Cloud			DVM Mapping
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-RTNOUTMSResponse		Outermosttag
			components.schemas.responseDetails_response	ERP_W1-RTNOUTMSResponse	Group
			responseDetails	components.schemas.responseDetails_response	Group
$POLineId		Field	externalId	responseDetails	String

Return 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
			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.
ERP_W1-RTNOUTMS		Group
components.schemas.sendDetails_request	ERP_W1-RTNOUTMS	Group
sendDetails	components.schemas.sendDetails_request	Group
return	sendDetails	Group
resourceTypeExternalId	return	String	ItemId	ReceivingReceiptTransactionRequests	Int				When (/nssrcmpr:ERP_W1-RTNOUTMS/nssrcmpr:components.schemas.sendDetails_request/ns27:sendDetails/ns54:return/ns55:resourceTypeExternalId != """")

			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.
purchaseOrderNumber	return	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.
$currentRcptReturnQuantity		Field	Quantity	ReceivingReceiptTransactionRequests	Float
unitOfPurchase	return	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).
employeeExternalId	return	String	EmployeeId	ReceivingReceiptTransactionRequests	Int				When (/nssrcmpr:ERP_W1-RTNOUTMS/nssrcmpr:components.schemas.sendDetails_request/ns27:sendDetails/ns54:return/ns55:employeeExternalId != """")
						OUTL-BRT-WACS_FPRC_ConfigProps	PropertyName : fprc.emp.id	Value: fprc.emp.id.error	Otherwise
$currentRcptTransaction		Group
items	$currentRcptTransaction	Group
ParentTransactionId	items	Field	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.
returnLineId	return	String	ExternalSystemTransactionReference	ReceivingReceiptTransactionRequests	String
			DFF	ReceivingReceiptTransactionRequests	Dff				Hardcoded as 'WACS'
returnLineId	return	String	wacsReturnLineId	DFF	String

Get Process Errors

Oracle Utilities Work and Asset Cloud Service			Oracle Fusion Procurement Cloud			DVM Mapping
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
$interfaceTransactionId		Field	id	Template Parameters	String

Return Request 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
		Outermosttag	APIInvocation Error	Outermosttag
			detail	APIInvocation Error	String				Hardcoded as 'Returns cannot be made on any receipt transactions'
400		Field	errorCode	APIInvocation Error	String
$self		Group	errorDetails	APIInvocation Error	Group
metadata	$self	Group
runtime	metadata	Group
instanceId	runtime	Field	instance	errorDetails	String
			errorCode	errorDetails	String				Hardcoded as '400'

Return Request 2

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
			title	APIInvocation Error	String				Hardcoded as 'Bad Request Error'
			detail	APIInvocation Error	String				Hardcoded as 'There are no required receipt quantity to return'
			errorCode	APIInvocation Error	String				Hardcoded as '400'
$self		Group	errorDetails	APIInvocation Error	Group
metadata	$self	Group
runtime	metadata	Group
instanceId	runtime	Field	instance	errorDetails	String
400		Field	errorCode	errorDetails	String

Return Request 3

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
			title	APIInvocation Error	String				Hardcoded as 'Bad Request Error'
			detail	APIInvocation Error	String				Hardcoded as 'There are no required receipt quantity to return'
			errorCode	APIInvocation Error	String				Hardcoded as '400'
$self		Group	errorDetails	APIInvocation Error	Group
metadata	$self	Group
runtime	metadata	Group
instanceId	runtime	Field	instance	errorDetails	String
400		Field	errorCode	errorDetails	String