Configuring Lookups
The following table lists the lookups that are part of this integration.
Lookup Name
Integration Name
Purpose
OFSCSOM_ActionCode
Oracle Utilities OFSC CCS Activity Complete
Translates the OFFS status to corresponding CCS Action Code
SOMOFSC_ActivityType
• Oracle Utilities OFSC CCS Activity Complete
• Oracle Utilities CCS OFSC Appointment Get
• Oracle Utilities CCS OFSC Activity Process
• Oracle Utilities OFSC CCS Activity Create
Translates CCS Activity type to OFFS Activity type
SOMOFSC_ConfigProps
• Oracle Utilities OFSC CCS Activity Complete
• Oracle Utilities CCS OFSC Appointment Get
• Oracle Utilities CCS OFSC Activity Process
• Oracle Utilities CCS OFSC Activity Get Status
• Oracle Utilities OFSC CCS Activity Create
Used for configurable properties
SOMOFSC_InterimStatus
Oracle Utilities CCS OFSC Activity Get Status
Translates activity status in OFFS to status in SOM/C2M/CCS
SOMOFSC_TimeZone
Oracle Utilities CCS OFSC Activity Process
Translates CCS time zone to OFFS time zone
SOMOFSC_MeterConfigurationType
Oracle Utilities OFSC CCS ServicePoint Query
Translates CCS meter configuration type to OFFS meter configuration type
OFSCSOM_MeterStatus
Oracle Utilities OFSC CCS Activity Complete
Translates CCS Meter Status to OFFS Meter Status and vice versa
SOMOFSC_CountryCode
• Oracle Utilities CCS OFSC Activity Process
• Oracle Utilities OFSC CCS Activity Create
Translates CCS Country Code to OFFS Country Code and vice versa
SOMOFSC_Email_ID
• Oracle Utilities CCS OFSC Activity Process
• Oracle Utilities OFSC CCS Activity Complete
• Oracle Utilities CCS OFSC Appointment Get
• Oracle Utilities OFSC CCS Activity Create
Configures the email IDs of respective user
SOMOFSC_LifeSupport
Oracle Utilities CCS OFSC Activity Process
Translates the life support codes from CCS to OFFS
OFSCSOM_Appt_Timeslots
• Oracle Utilities CCS OFSC Activity Process
• Oracle Utilities CCS OFSC Appointment Get
Translates OFFS time slots to CCS time slots and vice versa
OFSCSOM_StatusReason
Oracle Utilities OFSC CCS Activity Complete
Translates OFFS cancel reason to CCS.StatusReason field
OFSCSOM_ReadSequence
• Oracle Utilities OFSC CCS Activity Complete
• Oracle Utilities OFSC CCS Device Verification
Transforms the CCS Read sequence to OFFS Read sequence and vice versa.
OFSCSOM_Decimals
• Oracle Utilities OFSC CCS Activity Complete
•  
• Oracle Utilities OFSC CCS Device Verification
Maps the CCS Decimals to OFFS Decimals and vice versa.
OFSCSOM_Dials
• Oracle Utilities OFSC CCS Device Verification
• Oracle Utilities OFSC CCS Activity Complete
Maps the CCS Dials to OFFS Dials and vice versa
SOMOFSC_Key
Oracle Utilities CCS OFSC Activity Process
Maps the CCS Key to OFFS Key and vice versa
SOMOFSC_DeviceLocation
• Oracle Utilities CCS OFSC Activity Process
• Oracle Utilities OFSC CCS Activity Complete
Maps the CCS Device Location to OFFS Device Location and vice versa
SOMOFSC_MeasurementCondition
Oracle Utilities CCS OFSC Activity Process
Maps the CCS Measurement Condition to OFFS Measurement Condition and vice versa
SOMOFSC_AttachmentBO
Oracle Utilities OFSC CCS Activity Complete
Maps the OFFS Mime types to CCS attachment BO.
SOMOFSC_Sync_RegisterSQIData
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS SQI property label.
SOMOFSC_Sync_RegisterTOUData
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS TOU property label.
SOMOFSC_Sync_RegisterUOMData
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS UOM property label.
SOMOFSC_Sync_ActivityData
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS activity property label
SOMOFSC_Sync_DeviceConfiguration
Data
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS configuration property label.
SOMOFSC_Sync_DeviceManufacturer
Data
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS manufacturer property label.
SOMOFSC_Sync_DeviceModelData
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS model property label
SOMOFSC_Sync_DeviceTypesData
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS device types property label
SOMOFSC_Sync_DeviceHeadEnd
SystemData
Oracle Utilities CCS OFSC Admin Sync
Maps the Serial number to OFFS head end system property label
SOMOFSC_ActivityTypeConfigProps
Oracle Utilities CCS OFSC Admin Sync
Maps the OFFS activity type properties values
SOMOFSC_LanguageCode
Oracle Utilities CCS OFSC Admin Sync
Maps the CCS language code to OFFS language code
Editing Lookups
To edit a lookup:
1. Login to Oracle Integration for Cloud.
2. Navigate to Projects > OU CCS OFFS > Lookups.
3. Select the lookup to edit.
4. Make the necessary changes.
5. Click Save and Close.