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:

  • F1IL - Initial Load

  • F1IC - Incremental
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:

  • Rate Schedule

  • Effective Date

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:

  • External Metered SP Id (Required)

  • Start Date Time (Required)

  • End Date Time (Optional)

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