Stock Item Create Process (Oracle ERP Product Hub Cloud Initiated)

This section describes data mapping for the following:

Synchronize WACS Items

Mapping details for “wacssyncitem” activity are as shown in the table below:

Product Hub Event Create / Update Item or Publish Item File			WACS REST Service: W1-StockItemSync			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Work and Asset Cloud Service Column	Oracle ERP Product Hub Cloud Column
		Outermosttag	sync		Outermosttag
			components.schemas.SYNC_ request	sync	Group
			W1AdStkItmSy	components.schemas.SYNC_ request	Group
			input	W1AdStkItmSyt	Group
			externalSystem	input	String	ERPWACS_ConfigProps	PropertyName : wacs. externalsystem	Value :	Configuration Properties for WACS-ERP Integrations
onEvent		Group
findItemResponse	onEvent	Group
result	findItemResponse	Group
ItemId	result	Long	externalReferenceId	input	String
			initialLoad	input	String
			stockItemInfo	input	Group				Hardcoded as 'F1IC'
ItemId	result	Long	resourceTypeExternalId	stockItemInfo	String
ItemStatusValue	result	String	boStatus	stockItemInfo	String	ERPWACS_StockItemStatus	ERP_StockItemStatus	WACS_StockItemStatus	Map Stock Item Status between ERP and WACS
ItemDescription	result	String	description	stockItemInfo	String
LongDescription	result	String	longDescription	stockItemInfo	String
ItemNumber	result	String	stockItem	stockItemInfo	String
			usageExpenseCode	stockItemInfo	String	ERPWACS_ConfigProps	PropertyName : wacs.usageexpensecode.default	Value :	Configuration Properties for WACS-ERP Integrations
AssetCategoryValue	result	String	propertyUnit	stockItemInfo	String	ERPWACS_AssetCategory	ERP_AssetCategory	WACS_PropertyUnit	Map ERP Item Class field to WACS Stock Category field
ListPrice	result	Amounttype	unitPrice	stockItemInfo	Decimal
ItemClass	result	String	stockCategory	stockItemInfo	Stockcategory	ERPWACS_ItemClass	ERP_ItemClass	WACS_StockCategory	Map ERP Item Class field to WACS Stock Category field
			hazardous	stockItemInfo	Hazardous				When (string-length (normalize-space (/nssrcmpr:onEvent/nssrcmpr:findItemResponse/inp1:result/ns32:HazardClassValue ) ) > 0) Otherwise, hardcoded as 'W1NO'
HazardClassValue	result	String	hazardousType	stockItemInfo	Hazardoustype	ERPWACS_HazardousType	ERP_HazardousCode	WACS_HazardousType	Map Hazardous Type between ERP and WACS The WACS values can be obtained from Lookup: HAZARD_TYPE_FLG
LotControlValue	result	String	lotManaged	stockItemInfo	Stockiteminfo	ERPWACS_LotManagedFlag	ERP_LotControlFlag	WACS_LotManagedFlag	Map Lot Control Flag between ERP and WACS
InventoryAssetFlag	result	Boolean	capitalSpare	stockItemInfo	Capitalspare	ERPWACS_InventoryAssetFlag	ERP_InventoryAssetFlag	WACS_CapitalSpareFlag	Map ERP Inventory Asset Flag to WACS Capital Spare
AssetTrackedFlag	result	Boolean	trackable	stockItemInfo	Trackable	ERPWACS_AssetTrackedFlag	ERP_AssetTrackedFlag	WACS_TrackableFlag	Map Asset Tracked Flag between ERP and WACS
			repairable	stockItemInfo	Repairable				When (/nssrcmpr:onEvent/nssrcmpr:findItemResponse/inp1:result/ns32:UserItemTypeValue = "Asset Activity") Otherwise, hardcoded as 'W1NO'
PrimaryUOMValue	result	String	unitOfPurchase	stockItemInfo	String	ERPWACS_UOMCode	ERP_UOMName	WACS_UOMCode	Map UOM Codes between ERP and WACS
$Var_unitOfIssue		Field	unitOfIssue	stockItemInfo	String	ERPWACS_UOMCode	ERP_UOMName	WACS_UOMCode	Map UOM Codes between ERP and WACS
ItemCategory	result	Itemcategory	purchaseToIssueRatio	stockItemInfo	Stockiteminfo				Only if ($Var_piRatio != "") Function : number ($Var_piRatio )
CategoryName		String	purchaseCommodity	stockItemInfo	String	ERPWACS_PurchaseCommodity	ERP_PurchaseCategoryName	WACS_PurchaseCommodity	Only if (ns32:ItemCatalog = $Var_ERP_PurchaseItemCategory)
AllowSubstituteReceiptsFlag	result	Boolean	doNotSubstitute	stockItemInfo	Donotsubstitute	ERPWACS_AllowSubstituteReceiptsFlag	ERP_AllowSubstituteReceiptsFlag	WACS_DoNotSubstituteFlag	Map Allow Substitute Receipt Flags between ERP and WACS
			defaultValueToActivity	stockItemInfo	Defaultvaluetoactivity				Hardcoded as 'W1YS'
ItemSupplierAssociation	result	Itemsupplierassociation	vendors	stockItemInfo	Vendors
			vendorsList	vendors	Group
SupplierSiteId		Long	vendorLocationExternalId	vendorsList	String
SupplierItemNumber		String	vendorPartNumber	vendorsList	String
PrimaryFlag		Boolean	vendorPriority	vendorsList	Vendorpriority	ERPWACS_VendorPriority	ERP_SupplierPrimaryFlag	WACS_VendorPriority	Map Vendor priorities between ERP and WACS

Get UOM Conversion

Mapping details for “getuomconversion” activity are as shown in the table below:

Product Hub Event Create / Update Item or Publish Item File			WACS REST Service: W1-StockItemSync			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Work and Asset Cloud Service Column	Oracle ERP Product Hub Cloud Column
onEvent		Outermosttag	create		Outermosttag
findItemResponse	onEvent	Group	UnitOfMeasureConversions	create	Group
result	findItemResponse	Group
PrimaryUOMValue	result	String	FromUOM	UnitOfMeasureConversions	String	ERPWACS_UOM Code	ERP_UOMName	ERP_UOMCode	Map UOM Codes between ERP and WACS
UnitOfIssueValue	result	String	ToUOM	UnitOfMeasureConversions	String	ERPWACS_UOM Code	ERP_UOMName	ERP_UOMCode	Map UOM Codes between ERP and WACS
ItemId	result	Long	ItemId	UnitOfMeasureConversions	String