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
• Oracle Utilities OFSC WACS Asset Query
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_SimplifiedWAMActivityStatus
Oracle Utilities OFSC WACS Asset Query
Translation between WAM Activity Status to simplified OFS Activity Status.
WAMOFSC_BacklogGroup
Oracle Utilities WACS OFSC Activity Process
Maps backlog group to the bucket name. An OFS activity’s initial resource bucket is derived from the WACS activity’s backlog group if the wam.bucket.assignment.group property of the WAMOFSC_ConfigProps lookup is set to “BACKLOG”.
WAMOFSC_ServiceArea
Oracle Utilities WACS OFSC Activity Process
Maps service area to the bucket names. An OFS activity’s initial resource bucket is derived from the WACS service area if the wam.bucket.assignment.group property of the WAMOFSC_ConfigProps lookup is set to “SERVICE_AREA”
Editing Lookups
To edit a lookup:
1. Login to Oracle Integration for Cloud.
2. Navigate to Projects > OU WACS OFSC > Lookups.
3. Select the look up to edit.
4. Make the necessary changes.
5. Click Save and Close.