Configuring Admin Data in Oracle Utilities Digital Asset Cloud Service
This section describes the admin data setup in Oracle Utilities Digital Asset Cloud Service related to the integration. The Admin menus can be configured to be grouped alphabetically or by functional groups. The descriptions that follow will include both groupings.
Master Configuration
This section describes the master configuration details for the integration. The following Master Configurations can be found from the Admin menu > [M or General] > Master Configuration:
Digital Asset Integration Master Configuration
Digital Asset Integration Master Configuration
The Digital Asset master configuration is used for synchronizing digital asset customer information to Oracle Utilities Analytics Insights.
Update the Digital Asset Integration Master Configuration created for DACS-DERMS Integration.
Update the Digital Asset Integration master configuration by populating the DataRaker Integration Parameters section with the following data:
Default Batch Control for Extract: X1-DACEX (Digital Asset Customer Extract for DataRaker)
Program Subscription Types Eligible for Sync: Configure one or more program subscription types that are eligible for sync to Oracle Utilities Analytics Insights.
Head End System
Create a new or update an existing head end system for each external energy aggregator interfaced to Oracle Utilities Live Energy Connect.
To create a head end system:
1. In the Admin menu navigate to [H or Digital Asset Management] > Head End System > Add.
2. Enter a unique head end system and its description.
3. Specify the external system created for Oracle Utilities Grid Edge Distributed Energy Resources Management System.
4. Add a processing method for processing role Device Status Check. On the processing method, set the following:
Default Business Object: X1-CtrlDvcStatusCheckComm (Controllable Device - Device Status Check)
Default Outbound Message Type: Controllable Device Status Check
Activity Type
Create a new or update an existing activity type for the Controllable Device Status Check activity.
To create an activity type:
1. In the Admin menu, navigate to [A or Communication].
2. Add or edit the Controllable Device Status Check activity and its description. Refer to the embedded help for more information.
Business Flag Type
Create a new or update an existing Business Flag Type for the KWH Avoided activity.
To create a Business Flag type:
1. In the Admin menu, navigate to [B or Integration].
2. Add or edit the Standard Name for kWh Avoided.
3. Add or edit the Related Transactional BO for kWh Avoided Business Flag.
4. Add or edit the Status.
5. Add or edit the Description.
6. Add or edit the UOM.
7. Add or edit the TOU.
8. Add or edit the SQI.
9. Add or edit the Interval Size.
Communication Type
Create a new or update an existing communication type for the following Communication Types:
Controllable Device: Device Status Check
Controllable Device: Device Status Check Response
To create a communication type:
1. In the Admin menu navigate to [C or Communication Type].
2. Enter a unique communication type and its description. Refer to the embedded help for more information.
Service Task Type
Create a new or update an existing service task type for the following Service Task Type Business Objects:
Digital Asset Enrollment Request Task Type
Digital Asset Unenrollment Request Task Type
To create a service task type:
1. In the Admin menu navigate to [S or General].
2. Enter a unique Service Task Type and its Description. Refer to the embedded help for more information.
Sync Request Process
The Sync Request Process is used to synchronize customer enrollment and unenrollment data from Oracle Utilities Digital Asset Cloud Service to Oracle Utilities Analytics Insights. Maintenance Object - Audit algorithms are responsible for instantiating subscription-based sync request records.
To configure a Maintenance Object:
1. In the Admin menu, navigate to [M or Database] > Maintenance Object > Search.
2. Navigate to the following Maintenance Objects and configure the following:
Usage Subscription (D1-US)
a. Under the Maintenance Object - Options tab, add the “Sync Request BO” MO Option with an option value “X1-DRDigitalAssetCustSync (DataRaker Digital Asset Customer Sync Request)”.
b. Plug in the F1-GCHG-CDCP (Generic Change Data Capture) MO audit algorithm. When a change is detected on a program subscription, this algorithm is responsible for instantiating the sync request.
Contact (D1-CONTACT): Plug in the X1-CNTCDCDA (Contact Change Data Capture (Digital Asset Subscription Based)) MO audit algorithm. When a change is detected on a contact associated to an eligible program subscription, this algorithm is responsible for instantiating the sync request.
Device (D1-DEVICE): Plug in the X1-DVCCDCDA (Device Change Data Capture (Digital Asset Subscription Based)) MO audit algorithm. When a change is detected on a controllable device associated to an eligible program subscription, this algorithm is responsible for instantiating the sync request.
Service Point (D1-SP): Plug in the X1-LOCCDCDA (Location Change Data Capture (Digital Asset Subscription Based)) MO audit algorithm. When a change is detected on a device location associated to an eligible program subscription, this algorithm is responsible for instantiating the sync request.
Scheduling Batch Jobs
Run the following Oracle Utilities Digital Asset Cloud Service Batch Processes:
Enrollment Sync Related Batch Processes
These are the batch processes to run to process the initial and incremental sync request and send the enrollments out as a file from Oracle Utilities Digital Asset Cloud Service.
F1-SYNRQ - Sync Request Monitor Process
X1-DACIL - DataRaker Digital Asset Customer Sync Initial Load
X1-DACEX - Digital Asset Customer Extract for DataRaker
Batch Code
Description
F1-SYNRQ
Sync Request Monitor Process
 
This is the batch process to run the sync request. It is a generic batch process that is used for different sync processes. It includes parameters that can be used to control which sync request BOs to process.
The parameters for this batch process are the following:
Batch Parameters
Parameter Description
Value
maintenanceObject
Sync Request maintenance object
F1-SYNC REQ
isRestrictedByBatchCode
The value of true restrict processing to sync requests whose current state is linked to this batch code.
True
restrictToBusinessObject
Enter a business object code here to limit the process to sync requests linked to this business object.
X1-DRDigitalAssetCustSync
restrictToBOStatus
Enter a status code to limit the process to sync requests in this state.
PENDING
 
Batch Code
Description
X1-DACIL
DataRaker Digital Asset Customer Sync Initial Load
 
This batch process creates initial Digital Asset Customer sync request records for the D1-US MO (first parameter). The sync request BO to use is specified in the second parameter. The initialLoad element in the sync request BO schema is set by this process.
The parameters for this batch process are the following:
Batch Parameters
Parameter Description
Value
syncRequestMO
Maintenance Object
D1-US
syncRequestBO
Sync Request Business Object
X1-DRDigitalAssetCustSync
 
Batch Code
Description
X1-DACEX
Digital Asset Customer Extract for DataRaker
 
This multi-threaded batch process creates the flat file(s) that are extracted for DataRaker. It creates the extract file(s) that contain the Metered Service, Metered Service Point, and Program Subscription information.
The parameters for this batch process are the following:
Batch Parameters
Parameter Description
Value
filePath
The file path where the output should be placed. Refer to Referencing URIs in the user documentation for more details
/tmp
(Sample)
fileName
Name of the extract file
ENROLL_SYNC_{BN}.csv
(Sample)
fileFormat
The extract file format. Valid values are CSV (delimited) FIXD (fixed position output) or XML (XML document)
CSV
includeHeader
If set to 'Y', then a header row is included in the file that is produced.
Y
Kwh Avoided Upload Batch Process
This is the batch process to calculate and send out the device score to Oracle Utilities Grid Edge Distributed Energy Resources Management System. Schedule the corresponding batch jobs in the order they are listed:
Batch Code
Description
X1-KWHAV
kWh Avoided Business Flag Upload
 
This batch control uploads the kwh Avoided data from a CSV file on the server. For each data row in the file, this batch creates a kWh Avoided Business Flag record.
The parameters for this batch process are the following:
Batch Parameters
Parameter Description
Value
fileName
Name of the file or files to be uploaded
kwhavoided.csv
(Sample)
filePath
The file path where the file is to be picked up,
/storage/kwhavoid
(Sample)