Configuring Lookups
This section describes the lookups and the configuration details in the integration:
Lookups
The following table lists the lookups that are part of this integration:
Lookup Name
Integration Name
Purpose
OUTL-BRT-DACS_DRMS_AllowEventDays
OU DACS DERMS Program Rule Sync
Translates DACS Program Rule Allow Event Days Flag to the DERMS Program Rule Allow Event Days Flag
OUTL-BRT-DACS_DRMS_AssetType
OU DERMS DACS Enrollment Request
 
OUTL-BRT-DACS_DRMS_AssetSpec
OU DERMS DACS Enrollment Request
Translates DERMS device make and model (format MAKE!MODEL) to DACS asset specification.
OUTL-BRT-DACS_DRMS_ConfigProps
• OU DACS DERMS Aggregator Sync
• OU DERMS DACS Aggregator Sync Ack
• OU DACS DERMS CommonErrorHandler
• OU DACS DERMS Customer Event Opt-Out Update
• OU DACS DERMS Device Score FTP Transfer
• OU DACS DERMS Device Score OS Transfer
• OU DACS DERMS Device Status Check
• OU DERMS DACS Device Status Ack
• OU DERMS DACS Enrollment Request
• OU DACS DERMS Enrollment Sync
• OU DERMS DACS Enroll Sync Ack
• OU DERMS DACS Event Device Reserve
• OU DERMS DACS Event Outcome Process
• OU DERMS DACS Program Event Status Update
• OU DACS DERMS Program Rule Sync
• OU DERMS DACS Program Rule Sync Ack
• OU DERMS DACS SP Network Location Transfer
Generic properties and default values used in the integration’s business logic and mappings
OUTL-BRT-DACS_DRMS_CycleFrequency
OU DACS DERMS Program Rule Sync
Translates DACS Program Rule Frequency to the DERMS Program Rule Frequency. This is the cycle frequency for which the Program Rule is applicable. 1-to-1 relationship between each Program Rule and Frequency.
OUTL-BRT-DACS_DRMS_DeviceLocationStatus
OU DACS DERMS Enrollment Sync
Translates device status values between applications
OUTL-BRT-DACS_DRMS_Email_ID
• OU DACS DERMS Common Error Handler
• OU DACS DERMS Customer Event Opt-Out Update
• OU DACS DERMS Device Score FTP Transfer
• OU DACS DERMS Device Score OS Transfer
• OU DERMS DACS Event Device Reserve
• OU DERMS DACS Event Outcome Process
• OU DERMS DACS SP Network Location Transfer
Provides the email information to send error details:
• to property contains the email address(es) of people who handle technical issues like network connection issues, 401 unauthorize issues.
• to.ProcessNotification property contains the email address(es) of business or application users in DACS and/or DERMS.
OUTL-BRT-DACS_DRMS_EventType
• OU DERMS DACS ProgramEvent Status Update
Translates event type between applications
OUTL-BRT-DACS_DRMS_Routing
• OU DACS DERMS Customer Event Opt-Out Update
• OU DACS DERMS Device Status Check
• OU DERMS DACS Event Device Outcome Process
• OU DACS DERMS Enrollment Sync
• OU DERMS DACS Event Device Reserve
• OU DACS DERMS Program Rule Sync
• OU DACS DERMS Aggregator Sync
• OU DERMS DACS SP Network Location Transfer
This lookup is used to route the DERMS environment instances to the DACS CIS Division
OUTL-BRT-DACS_DRMS_EnrollmentStatus
OU DERMS DACS Enrollment Request
Translates the enrollment status to code
OUTL-BRT-DACS_DRMS_EventOutcome
OU DERMS DACS Event Outcome Process
Translates the incoming event outcome to DACS code
OUTL-BRT-DACS_DRMS_StageStatus
OU DERMS DACS ProgramEvent Status Update
Translates stage status values between applications
OUTL-BRT-DACS_DRMS_WeekDay
OU DACS DERMS Program Rule Sync
Translates DACS Program Rule Week Start to the DERMS Program Rule Week Start. This is applicable for cycle frequency of Weekly.
Editing Lookups
To edit a lookup:
1. Login to Oracle Integration for Cloud.
2. Navigate to Projects.
3. Select the project and go to the Lookups section of the project.
4. Click Save and Close.
Lookup Tables
This section lists the lookup tables in this integration.
Lookup: OUTL-BRT-DACS_DRMS_AllowEventDays
The values released in this lookup are the values defined in the edge applications. You need not configure this lookup unless there are custom values.
DACS_AllowEventDays
DERMS_AllowEventDays
Description
X1AD
All_Days
All Days
X1WE
Weekend
Weekend
X1WD
Weekdays
Weekdays
 
Lookup: OUTL-BRT-DACS_DRMS_AssetSpec
DRMS_MAKE_MODEL
DACS_SPECIFICATION
Description
NEST!N3GEN
EST_G3_SPEC
Value for DACS/DERMS for device
 
Lookup: OUTL-BRT-DACS_DRMS_AssetType
DRMS_ASSET_TYPE
DACS_ASSET_TYPE
Description
SMART_THERMOSTAT
SMART THERMOSTAT
Value for DACS/DERMS for type of device
 
Lookup: OUTL-BRT-DACS_DRMS_CycleFrequency
The values released in the lookup are the defined values in the edge applications. No need to configure this lookup unless there are custom values.
DACS_Frequency
DERMS_Frequency
Description
X1DY
Daily
Daily
X1MT
Monthly
Monthly
X1SE
Seasonal
Seasonal
X1WK
Weekly
Weekly
 
Lookup: OUTL-BRT-DACS_DRMS_DeviceLocationStatus
DACS_DEVICE_LOC_STATUS
DRMS_DEVICE_STATUS
Description
D1YS
Active
Value for DACS/DERMS for active or inactive device
D1NO
Inactive
 
 
Lookup: OUTL-BRT-DACS_DRMS_EnrollmentStatus
Property Name
Value
Description
PENDING
SUCCESS
 
ERROR
ERROR
 
VALERROR
ERROR
 
FAILURE
ERROR
 
10589
SUCCESS
Duplicate errors can be ignored
 
Lookup: OUTL-BRT-DACS_DRMS_Email_ID
Property Name
Sample Value
Description
From
admin@myCy.com
The email address used to identify who is sending the notification.
 
This value is the default email address for all outgoing emails for this project.
To
errorDist@myCy.com
The email address(es) who should receive any error notification. Multiple emails can be configured by putting comma to separate the email IDs.
 
These are likely the administrators or users who maintain the applications.
to.process.notification
busUserDist@myCy.com
The email address(es) who should receive notification when the file processing has completed, or no file was processed. Multiple emails can be configured by putting comma to separate the email IDs.
 
These are likely the business or application users.
 
Lookup: OUTL-BRT-DACS_DRMS_EventOutcome
The values released in the lookup are the defined values in the edge applications. No need to configure this lookup unless there are custom values.
DRMS_EVENT_OUTCOME
Value
Description
0
D1SP
Successful participation
1
D1CN
Cancelled
2
D1ER
Error
3
D1IO
In-flight override
4
D1ND
Non-responsive device
 
Lookup: OUTL-BRT-DACS_DRMS_EventType
DRMS_EventType
DACS_EventType
Description
X1EC
X1EC
Economic Event Type
X1EM
X1EM
Emergency Event Type
X1DT
X1DT
 
X1RE
X1RE
 
 
Lookup: OUTL-BRT-DACS_DRMS_Routing
DRMS_Instance
DRMS_Site_Connection
DACS_CIS_Division
DACS_Connection
Attribute Value of DERMS SITE in DRMS Parameters
Name of OIC Connection
CIS Division value
Name of DACS Connection
 
Lookup: OUTL-BRT-OUAI_DACS_DRMS_StageStatus
DRMS_StageStatus
DACS_StageStatus
Description
CANCELED
F1CN
 
COMPLETED
F1CO
 
IN_PROGRESS
X1IP
 
SCHEDULED
X1SD
 
 
Lookup: OUTL-BRT-DACS_DRMS_WeekDay
The values released in the lookup are the defined values in the edge applications. No need to configure this lookup unless there are custom values.
DACS_Frequency
DERMS_Frequency
Description
1
SUN
Sunday
2
MON
Monday
3
TUE
Tuesday
4
WED
Wednesday
5
THU
Thursday
6
FRI
Friday
7
SAT
Saturday
Configuration Properties
The lookups include properties that can be configured and defaulted in the integration.
Lookup: OUTL-BRT-DACS_DRMS_ConfigProps
Property Name
Sample Value
Description
notification.type.email
email
Hardcoded value for the integrations to send to the 'common error handler' to decide how to send the notifications out. In future release this might be augmented with other types besides the current default: 'email'
notification.email.error.flag
true
If the value is set to true, email notification will be sent out for errors.
 
Valid values: true/false.
 
Default to true.
 
Also, setup the OUTL-BRT-DACS_DRMS_Email_ID 'to' property for the users or administrators who should receive the email.
notification.email.pro cess.complete.flag
true
If the value is set to true, email notification will be sent out when the process is completed.
 
Valid values: true/false.
 
Default to true.
 
This is used by flows doing file processing. Also, setup the OUTL-BRTDACS_DRMS_Email_ID 'to.process.notification' property for the users who should receive the email.
notification.email.pro cess.nofile.flag
true
If the value is set to true, email notification will be sent out when no file was processed.
 
Valid values: true/false. Default to true.
 
This is used by flows doing file processing. Also, setup the OUTL-BRTDACS_DRMS_Email_ID 'to.process.notification' property for the users who should receive the email.
dacs.enrollmentSource.default
X1BY
Default to X1BY (Bring Your Own). This is used in Enrollment Request flow.
 
Valid Values:
• X1BY - Bring Your Ownm
• X1CC - Contact Center
• X1SS - Self Service
dacs.prefixtag.fileuploaded
Sent-
Prefix to append to the filename from DACS that has been transferred successfully to the target location.
 
Shared property for all file related flows in this integration.
dacs.prefixtag.filenot uploaded
Error-
Prefix to append to the filename from DACS to mark the file as error or not uploaded to the target location.
 
Shared property for all file related flows in this integration.
dacs.file.target.transfer.pref
os or ftp
 
dacs.os.namespace
dacsnamespace
DACS Object Storage namespace serves as a container for all DACS related buckets and objects.
 
It is used when calling the Object Storage APIs.
 
Required to be populated when DACS is in the cloud.
dacs.dvcScore.extract .filename.prefix
DeviceScore
Device Score Extract file name prefix.
 
It should have the same beginning value as the batch parameter filename in Batch Process X1-SDCSE.
 
Integration use this for filtering the file(s) to pick up from DACS file location by the Device Score flows.
dacs.dvcScore.ftp.input.directory
/sploutput/DACSEnv/DvcScore
DACS FTP directory where the Device Score extract files are stored for OIC to pick up from.
 
Required to be populated when DACS is on-premises.
dacs.os.dvcScore.bucket name
DACS_DVCSCORE
Define the bucket name where the Device Score Extract files are stored in the DACS Object Storage for OIC to pick up from.
 
It is used when calling the Object Storage APIs.
 
Required to be populated when DACS is in the cloud.
dacs.spNtwkLoc.ftp.input.directory
/sploutput
 
/DACSEnv
 
/SPNtwkLocInputDir
DACS FTP directory where the SP Network Location files are dropped by the OIC flow for DACS to pick up from.
 
Required to be populated when DACS is on premises.
dacs.spNtwkLoc.os.bucketname
DACS_SPNetworkLoc
Define the bucket name where the SP Network Location files are dropped in the DACS Object Storage by OIC flow for DACS to pick up from.
 
It is used when calling the Object Storage APIs.
 
Required to be populated when DACS is in the cloud.
dacs.error.ack.messagecategory
11114
DACS - Integration Message Category
dacs.error.ack.messagenumber
31002
Error occurred while processing request to NMS %1%2%3%4%5%6%7%8%9
syncAckDelayInSeconds
3
Value is in seconds.
 
Delay before seeing an cknowledgement back. Used in Aggregator and Program Rule Sync Ack Flows.