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.

3. Select the “OU WACS ERPPIM” project and go to the Lookups section of the project.

4. Select the lookup to edit and make the necessary changes.

5. Click Save and Close.