Configuring Lookups
The following table lists the lookups that are part of this integration.
Lookup Name
Integration Name
Purpose
WAMOFSC_AttachmentBO
Oracle Utilities OFSC WACS Activity Complete
Translates OFSC attachment MIME type to WAM BO name.
 
Note: Only on the edit of a service history, can we add an attachment to a service history. If a specific file type cannot be attached at service history, check if the corresponding file type is mentioned in this lookup; add it if is missing. Also, verify if the respective MIME type is available in OFSC properties wam_upload_attachment_1 to wam_upload_attachment_5.
WAMOFSC_ActivityLinkType
Oracle Utilities WACS OFSC Activity Process
Translates the WAM Activity Link Type to OFSC Activity Link Type.
 
Note: Configure the OFSC second activity link label.
WAMOFSC_
ActivityType
Oracle Utilities WACS OFSC Activity Process
 
Oracle Utilities OFSC WACS Activity Pull Update
Translates the WAM Activity Type to OFSC Activity Type.
WAMOFSC_Email_ID
Oracle Utilities OFSC WACS Activity Interim Status
 
Oracle Utilities WACS OFSC Activity Process
 
Oracle Utilities OFSC WACS Resource Usage Details
 
Oracle Utilities OFSC WACS Work Order
 
Oracle Utilities OFSC WACS Activity Complete
 
Oracle Utilities WACS OFSC Admin Data Sync
 
Oracle Utilities OFSC WACS Work Request
 
Oracle Utilities OFSC WACS Asset Query
 
Oracle Utilities OFSC WACS Activity Pull Update
 
Oracle Utilities OFSC WACS Route Activation
 
Oracle Utilities WACS OFSC Schedule Storeroom Sync
 
Oracle Utilities OFSC WACS Storeroom Sync
 
Oracle Utilities WACS OFSC Storeroom Admin Sync
Used to configure the email IDs of the respective users.
 
Under the Email_Id column where the value of Recipient is “to”, add comma separated email IDs to send an email to multiple users.
 
Do not change or add any values under the Recipient column.
WAMOFSC_
ConfigProps
Oracle Utilities OFSC WACS Resource Usage Details
 
Oracle Utilities OFSC WACS Activity Complete
 
Oracle Utilities WACS OFSC Admin Data Sync
 
Oracle Utilities OFSC WACS Activity Interim Status
 
Oracle Utilities WACS OFSC Activity Process
 
Oracle Utilities OFSC WACS Activity Pull Update
 
Oracle Utilities OFSC WACS Work Order
 
Oracle Utilities OFSC WACS Work Request
 
Oracle Utilities OFSC WACS Route Activation
 
Oracle Utilities OFSC WACS Storeroom Sync
 
Oracle Utilities WACS OFSC Storeroom Admin Sync
 
Oracle Utilities WACS OFSC Schedule Storeroom Sync
Used for configurable properties.
WAMOFSC_Language
Oracle Utilities WACS OFSC Admin Data Sync
Translates the language code from WAM to OFSC.
WAMOFSC_
ActivityStatus
Oracle Utilities OFSC WACS Activity Interim Status
Translation between WAM Activity status and the OFSC status.
WAMOFSC_
SegmentedActivityTypes
Oracle Utilities WACS OFSC Admin Data Sync
Used to identify activity types in OFSC that needs segmentation.
WAMOFSC_ActivityTypeConfigProps
Oracle Utilities WACS OFSC Admin Data Sync
Used to sync between the two systems
WAMOFSC_BacklogGroup
Oracle Utilities WACS OFSC Activity Process
Maps backlog group to the bucket name
WAMOFSC_ServiceArea
Oracle Utilities WACS OFSC Activity Process
Maps service area to the bucket name
Editing Lookups
To edit a lookup:
1. Login to Oracle Integration for Cloud.
2. Navigate to Integrations > Lookups.
3. Select the look up to edit.
4. Make the necessary changes.
5. Click Save and Close.