Configuring Lookups
The following table lists the lookups and integration processes where these lookups are used:
Lookup Name
Integration Name
Purpose
CCBOFSC_ConfigProps
• Oracle Utilities CCB OFSC Activity CreateUpdate
• Oracle Utilities CCB OFSC Activity Cancel
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB Activity Create
• Oracle Utilities CCB OFSC Appointment Get
• Oracle Utilities OFSC CCB Activity Interim Status
• Oracle Utilities OFSC CCB ServicePoint Query
• Oracle Utilities OFSC CCB Device Verification
Mainly used for configuring the properties with appropriate values.
CCBOFSC_ActivityType
• Oracle Utilities CCB OFSC Activity CreateUpdate
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB Activity Create
• Oracle Utilities CCB OFSC Appointment Get
Used to translate Oracle Utilities Customer Care and Billing Activity Type to Oracle Field Service Activity Type.
CCBOFSC_CountryCode
• Oracle Utilities CCB OFSC Activity CreateUpdate
• Oracle Utilities OFSC CCB ServicePoint Query
Translates the Oracle Utilities Customer Care and Billing Country code to Oracle Field Service.
CCBOFSC_LifeSupport
Oracle Utilities CCB OFSC Activity CreateUpdate
Translates the Oracle Utilities Customer Care and Billing life support to Oracle Field Service.
CCBOFSC_Manufacturer
• Oracle Utilities CCB OFSC Activity CreateUpdate
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB Device Verification
Translates the Oracle Utilities Customer Care and Billing Manufacturer to Oracle Field Service and vice versa.
CCBOFSC_
MeterLocation
• CreateUpdate_Activity_
CCBToOFSC
• Complete_Activity_
OFSCToCCB
Used to translate the Oracle Utilities Customer Care and Billing Meterlocation to Oracle Field Service and Vice versa.
CCBOFSC_Model
• Oracle Utilities CCB OFSC Activity CreateUpdate
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB Device Verification
Translates the Oracle Utilities Customer Care and Billing Model to Oracle Field Service and Vice versa.
CCBOFSC_
DisconnectLocation
• Oracle Utilities OFSC CCB Activity Complete
Translates the Oracle Utilities Customer Care and Billing Disconnection location to Oracle Field Service and Vice versa.
CCBOFSC_
ServiceInstructions
• Oracle Utilities OFSC CCB Activity Complete
Translates the Oracle Utilities Customer Care and Billing Service instructions to Oracle Field Service and Vice versa.
OFSCCCB_Appt_
TimeSlots
• Oracle Utilities CCB OFSC Appointment Get
• Oracle Utilities CCB OFSC Activity CreateUpdate
Translates the Oracle Utilities Customer Care and Billing timeslots to Oracle Field Service time slots and vice versa.
OFSCCCB_InterimStatus
Oracle Utilities OFSC CCB Activity Interim Status
Translates the Oracle Utilities Customer Care and Billing status to Oracle Field Service.
CCBOFSC_ServicePointType
Oracle Utilities CCB OFSC Activity CreateUpdate
Translates the Oracle Utilities Customer Care and Billing Service point type to Oracle Field Service.
CCBOFSC_Email_ID
• Oracle Utilities CCB OFSC Activity CreateUpdate
• Oracle Utilities CCB OFSC Activity Cancel
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB Activity Create
• Oracle Utilities CCB OFSC Appointment Get
• Oracle Utilities OFSC CCB Activity Interim Status
Used to maintain the email address of 'from' (sender) and 'to' (receiver) fields.
CCBOFSC_PremiseType
Oracle Utilities CCB OFSC Activity CreateUpdate
Translates the Oracle Utilities Customer Care and Billing Premise type to Oracle Field Service.
OFSCCCB_TimeZone
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB ServicePoint Query
• Oracle Utilities CCB OFSC Activity CreateUpdate
Used to maintain the Oracle Field Service time zones and their offsets.
CCBOFSC_
ServiceWarnings
• Oracle Utilities OFSC CCB Activity Complete
Translates the service warnings in Oracle Utilities Customer Care and Billing to service warnings in Oracle Field Service and vice versa.
OFSCCCB_DeviceStatus
• Oracle Utilities OFSC CCB Activity Complete
Translates the Oracle Field Service device status to Oracle Utilities Customer Care and Billing.
OFSCCCB_ReadType
• Oracle Utilities OFSC CCB Activity Complete
Translates the Oracle Field Service read type to Oracle Utilities Customer Care and Billing.
CCBOFSC_
MeterConfigurationType
• Oracle Utilities CCB OFSC Activity CreateUpdate
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB Device Verification
• Oracle Utilities OFSC CCB ServicePoint Query
Translates the Oracle Utilities Customer Care and Billing configuration type to Oracle Field Service and vice versa.
CCBOFSC_UOM
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB Device Verification
Translates the Oracle Utilities Customer Care and Billing unit of measure to Oracle Field Service and vice versa.
CCBOFSC_TOU
• Oracle Utilities OFSC CCB Activity Complete
• Oracle Utilities OFSC CCB Device Verification
Translates the Oracle Utilities Customer Care and Billing time of use to Oracle Field Service and vice versa.
CCBOFSC_TimeZone
• Oracle Utilities OFSC CCB ServicePoint Query
• Oracle Utilities CCB OFSC Activity CreateUpdate
Translates the Oracle Utilities Customer Care and Billing time zone to Oracle Field Service Time Zone.
Editing Lookups
To edit a lookup to add or update any value in it:
1. Login to Oracle Integration for Cloud.
2. Navigate to Projects > OU CCB OFSC > Lookups.
3. Click the look up to edit.
4. Make the necessary changes.
5. Click Save and Close.
Note: While editing a lookup, if the changes are not reflected during the runtime, make sure to deactivate and activate the integration that is using the edited DVM for the changes to reflect. Refer to the Activating Integration Flows section for more details.