Configuring Lookups

The following table lists the lookups that are part of this integration.

Lookup Name	Description
ERPWACS_AllowSubstitute ReceiptsFlag	Maps Allow Substitute Receipt Flag values between ERP PIM and WACS Get ERP PIM values from Product Information Management > Product Hub > Manage Item > Specification - Item organization - Purchasing (Receiving -Valid Transactions - Allow Substitute receipts) ERP PIM values: true, false WACS values: W1YS, W1NO
ERPWACS_AssetCategory	Maps between ERP PIM Asset Category to WACS Property Unit. Get ERP PIM values from Product Information Management > Product Hub > Manage Item > Specification - Item organization - Purchasing - Purchasing Get WACS values from Admin > [P or Financial] > Property Unit > Search
ERPWACS_AssetTrackedFlag	Maps ERP PIM Asset Tracked Flag to WACS Trackable Flag. Get ERP PIM values from Product Information Management > Product Hub > Manage Item > Specification - Item organization - Manufacturing - Costing - Inventory Asset Value ERP PIM values: true, false WACS values: W1YS, W1NO
ERPWACS_ConfigProps	Maps the PropertyName column to the respective Value column. Do not change value in the PropertyName column.
ERPWACS_Email_ID	Maps from and to recipient values to the corresponding Email ID(s). Configure multiple email IDs using a comma to separate them.
ERPWACS_HazardousFlag	Maps ERP PIM Flag to WACS Hazardous Flag. Hazardous Type must be blank if HazardousFlag is set to W1YS. Get ERP PIM values from Product Information Management > Product Hub > Manage Item > Specification - Item organization - Purchasing - Purchasing ERP PIM values: true, false WACS values: W1YS, W1NO
ERPWACS_HazardousType	Maps ERP PIM Hazardous Code to WACS Hazardous Type Get ERP PIM values from Product Information Management > Product Hub > Manage Item > Specification - Item organization - Purchasing - Purchasing Get WACS values from Admin > L or Database > Lookup > Search > Search for HAZARD_TYPE_FLG
ERPWACS_ItemClass	Maps ERP PIM Item Class to WACS Stock Category Get ERP PIM values from Product Hub > Manage Item Class Get WACS values from Admin > L or Database > Lookup > Search > Search for STOCK_CAT_FLG
ERPWACS_InventoryAssetFlag	Maps ERP PIM Inventory Asset Flag to WACS Capital Spare Flag Get ERP PIM value from Product Information Management > Product Hub > Manage Item > Specification - Item organization - Manufacturing - Costing - Inventory Asset Value ERP PIM values: true, false WACS values: W1YS, W1NO
ERPWACS_LotManagedFlag	Maps ERP PIM Lot Control Flag to WACS Lot Managed Flag Get ERP PIM value from > Product Information Management > Product Hub > Manage Item > Specification - Item organization - Inventory (Control) ERP PIM values: Full lot control, No lot control WACS values: W1YS, W1NO
ERPWACS_PurchaseCommodity	Maps ERP PIM Purchase Category Name to WACS Purchase Commodity. Get ERP PIM values from Product Information Management > Product Hub > Manage Item > Specification > Categories > Choose Purchasing Category Get WACS values from Admin > P or Inventory > Purchase Commodity > Search
ERPWACS_StockItemStatus	Maps Stock Item Status values between ERP PIM and WACS ERP PIM values: Active, Inactive WACS values: Active, Inactive
ERPWACS_UOMCode	Maps UOM Code values between ERP PIM and WACS Get ERP PIM values from Product Information Management > Product Hub > Manage Item > Specification - Item organization - Purchasing Get WACS values from Admin > U or Inventory > Unit Of Measure - Resource > Search
ERPWACS_VendorPriority	Maps ERP PIM Supplier Primary Flag to WACS Vendor Priority. Get ERP PIM values from Product Information Management > Product Hub > Manage Item > Specification - ItemSupplierAssociation/PrimaryFlag ERP PIM values: true, false WACS values: W1PR, W1OT

Editing Lookups

To edit a lookup:

1. Login to Oracle Integration for Cloud.

2. Navigate to Projects > OU WACS ERPSCM > Lookups.

3. Select the lookup to edit.

4. Make the necessary changes.

5. Click Save and Close.