Extracting Service Agreements
This topic provides additional details related to extracting service agreements from Oracle Utilities Customer Cloud Service for import into Oracle Utilities Digital Asset Cloud Service.
Initial Extract Batch Process
Initial extract files for service agreements are created using the Migrates SA to DACS Metered Service (C1-DMSIL) batch process. Use the Batch Control portal to view the parameters used by this batch process. This process should be run only for the initial extract.
Maintenance Object Audit Algorithm
The Sync Service Agreement as DACS Metered Service (C1_DASASYNC) audit algorithm tracks new service agreement data and changes to existing service agreement data and creates data synchronization requests, which are used to create incremental extract files.
Sync Request Business Object
Service agreement sync requests are based on the Sync CCB SA to DACS Metered Service (C1-DACSMSSyncRequest) business object.
Incremental Extract Batch Process
Incremental service agreements extract files are created from sync requests and General Process records using the MS Incremental Sync Batch Control (C1-DMSEX) batch process. Use the Batch Control portal to view the parameters used by this batch process. This process should be run as needed for incremental updates.
Service Agreement Extract File Format
Service agreement extract files use the following tab-separated values format:
Field Name |
Optional/Required |
Notes |
---|---|---|
External Reference Id | Optional | The metered service's reference ID in the CIS application. |
Change Date Time | Optional |
The date and time on which the metered service was changed. Applicable only for Incremental Uploads Will be used to sequence processing in case there are multiple changes to the same metered service point. |
Initial Load Sync Flag | Required |
A value that indicates the type of upload. Valid values are:
|
External Id | Required |
The metered service's ID in the CIS application. When importing data from Customer to Meter or Cloud Cloud Service this is the Service Agreement External ID. |
Metered Service Type | Required |
The type of metered service. When importing data from Customer to Meter or Cloud Cloud Service this comes from the Service Agreement Type. If the provided metered service point type has not been defined as a Metered Service Type in Digital Asset Management / Digital Asset Cloud Service an extendable lookup is used to map this value to the Metered Service Type used in Digital Asset Management / Digital Asset Cloud Service. |
External Contact ID | Optional |
The ID of the contact associated with the metered service in the CIS application. When importing data from Customer to Meter or Cloud Cloud Service this is the Contact External ID. |
External Account ID | Optional | An ID used to identify the account associated with the metered service record in the CIS application. |
Start Date Time | Required | The date and time on which the metered service record started. |
End Date Time | Optional | The date and time on which the metered service record ended or will end (if applicable). |
Division | Optional |
The metered service's division. If the provided division has not been defined as a Division in Digital Asset Management / Digital Asset Cloud Service an extendable lookup is used to map this value to the Division used in Digital Asset Management / Digital Asset Cloud Service. |
SA Status | Optional |
The metered service's status. If the provided status has not been defined as a Division in Digital Asset Management / Digital Asset Cloud Service an extendable lookup is used to map this value to a Status defined in Digital Asset Management / Digital Asset Cloud Service. |
Rate Schedule List | Optional |
A concatenated list of rate schedules and effective dates associated with the metered service. Each row in this list is composed of the following:
Each element in the row will be delimited by comma ( , ). Each row in the list will be delimited by semi-colon ( ; ). For example: ERES-1,2022-01-01ERES-2,2021-01-01 |
Metered SP List | Optional |
A concatenated list of metered service points associated with the metered service. Each row in this list is composed of the following:
Each element in the row will be delimited by comma ( , ). Each row in the list will be delimited by semi-colon ( ; ). Example: 6800401571,2022-12-13T14:30:00-05:00,1703304223,2022-12-13T14:30:00-05:00, |
Is Erased | Optional |
A flag that indicates if the customer has been obfuscated (if supported) in the CIS application. Valid values are Y/N (Default) Applicable only to Incremental Uploads This should be set to "N" if Object Erasure is not supported in the CIS application. |
Sample Record
Below is a sample file:
EXTREFMS11 2023-06-15T13:02:00-08:00 F1IC EXTMS1 CA!ZZMTRDST EXTCONTACT1 EXTACCT1 2022-10-15T09:23:00-08:00 2023-06-14T13:45:00-08:00 ZZEDV 20 ERESRBOH,2022-11-09; EXTMSP1,2022-11-09T13:14:55-08:00,2023-04-14T08:25:44-08:00; Y