Configuring Lookups
The following table lists the lookups that are part of this integration.
Lookup Name
Integration Name
Purpose
OUTL-BRT-DACS_DRMS_AssetType
OU DERMS DACS Enrollment Request
 
OUTL-BRT-DACS_DRMS_AssetSpec
OU DERMS DACS Enrollment Request
 
OUTL-BRT-DACS_DRMS_ConfigProps
OU DACS DERMS CommonErrorHandler
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 ProgramEvent Status Update
Generic properties and default values used in the integration’s business logic and mappings
OUTL-BRT-DACS_DRMS_DeviceLocationStatus
OU DACS DERMS Enrollment Sync
Translate device status values between applications
OUTL-BRT-DACS_DRMS_Email_ID
OU DACS DERMS Common Error Handler
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
Provide 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
Translate event type between applications
OUTL-BRT-DACS_DRMS_Routing
OU DACS DERMS Device Status Check
OU DERMS DACS Event Outcome Process
OU DACS DERMS Enrollment Sync
OU DERMS DACS Event Device Reserve
Routing to the correct GE DERMS instance
OUTL-BRT-DACS_DRMS_EnrollmentStatus
OU DERMS DACS Enrollment Request
Translate 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
Translate stage status values between applications
Editing Lookups
To edit a lookup:
1. Login to Oracle Integration for Cloud.
2. Navigate to Integrations > Designer > Lookups.
3. Select the lookup to edit and make the necessary changes.
4. Click Save and Close.
 
The following lookups include properties that can be configured and defaulted in the integration.
Lookup: OUTL-BRT-DACS_DRMS_ConfigProps
Property Name
Sample Value
Description
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.direc tory
/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-premise.
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.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.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.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.
enrollmentSyncAckDelay
5
 
notification.email.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.process.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-BRT-DACS_DRMS_Email_ID 'to.process.notification' property for the users who should receive the email.
notification.email.process.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-BRT-DACS_DRMS_Email_ID 'to.process.notification' property for the users who should receive the email.
notification.type.email
email
Default to email
 
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-OUAI_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 package.
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-OUAI_DACS_DRMS_EventType
DRMS_EventType
DACS_EventType
Description
X1EC
X1EC
 
X1EM
X1EM
 
X1DT
X1DT
 
X1RE
X1RE
 
 
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_Routing
DRMS_Instance
DRMS_Site_
Connection
DACS_CIS_Division
DACS_Connection
x
Name of OIC Connection
CIS Division value
Name of DACS Connection
 
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_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_AssetSpec
DRMS_MAKE_
MODEL
DACS_
SPECIFICATION
Description
NEST!N3GEN
EST_G3_SPEC
Value for DACS/DERMS for device
NEST!N4GEN
ZZ_CTRL_DVC_THERM_SPEC22
 
ECOBEE!E3GEN
EcoBee_E3