Master Configuration | Name / Description |
Master Data Synchronization Configuration | Lists all foreign key references that need resolution. Each one should reference the view that contains the external key / production key cross-reference. For entities that undergo both the initial and the ongoing sync, two views are specified. For entities that undergo the ongoing sync, an external system / ID type mapping is specified to cater for entities that might be synchronizing from more than one external system. |
Seeder Sync Request Master Configuration | Lists the maintenance objects (device, device configuration, etc.) that require synchronization. Each references the synchronization business object that needs to be instantiated when processing a synchronization request for that maintenance object. For maintenance objects that undergo both initial and the ongoing synchronization, two business objects are specified. |
Object Name | Business Object | Description |
Device Config Composite Sync Request | D1-CompositeSyncRequestDC | A composite synchronization request that handles syncing in Device Configuration and creating related Measuring Component. This business object a child of the D1- CompositeSyncRequest business object. |
Contact Initial Sync Request | D1-InitialSyncRequestContact | Instances of this business object represent individual initial contact synchronization requests. |
Device Configuration Initial Sync Request | D1-InitialSyncRequestDC | Instances of this business object represent individual initial device configuration synchronization requests. |
Device Initial Sync Request | D1-InitialSyncRequestDevice | Instances of this business object represent individual initial device synchronization requests. |
Install Event Initial Sync Request | D1-InitialSyncRequestIE | Instances of this business object represent individual initial install event synchronization requests. |
Measuring Component Initial Sync Request | D1-InitialSyncRequestMC | Instances of this business object represent individual initial measuring components synchronization requests. |
Service Point Initial Sync Request | D1-InitialSyncRequestSP | Instances of this business object represent individual initial service point synchronization requests. |
Dynamic Option Initial Sync Request | D2-InitialSyncRequestDynOpt | Instances of this business object represent individual initial dynamic option synchronization requests. |
Dynamic Option Event Initial Sync Request | D2-InitialSyncRequestDynOptEvt | Instances of this business object represent individual initial dynamic option event synchronization requests. |
Usage Subscription Initial Sync Request | D2-InitialSyncRequestUS | Instances of this business object represent individual initial usage subscription synchronization requests. |
Ongoing Sync Request Acknowledgement | D1-OngoingSyncReqAckMsg | Used to send a message to the sending system to acknowledge receipt of an ongoing synchronization request. |
Scalar Meter Read Ongoing Sync Request | D1-OngoingSyncReqScalarMtrRead | Instances of this business object represent individual ongoing scalar meter read synchronization requests. |
Contact Ongoing Sync Request | D1-OngoingSyncRequestContact | Instances of this business object represent individual ongoing contact synchronization requests. |
Device Configuration Ongoing Sync Request | D1-OngoingSyncRequestDC | Instances of this business object represent individual ongoing device configuration synchronization requests. |
Device Ongoing Sync Request | D1-OngoingSyncRequestDevice | Instances of this business object represent individual ongoing device synchronization requests. |
Install Event Ongoing Sync Request | D1-OngoingSyncRequestIE | Instances of this business object represent individual ongoing install event synchronization requests. |
Measuring Component Ongoing Sync Request | D1-OngoingSyncRequestMC | Instances of this business object represent individual ongoing measuring component synchronization requests. |
Service Point Ongoing Sync Request | D1-OngoingSyncRequestSP | Instances of this business object represent individual ongoing service point synchronization requests. |
Dynamic Option Ongoing Sync Request | D2- OngoingSyncRequestDynOpt | Instances of this business object represent individual ongoing dynamic option synchronization requests. |
Dynamic Option Event Ongoing Sync Request | D2- OngoingSyncRequestDynOptEvt | Instances of this business object represent individual ongoing dynamic option event synchronization requests. |
Usage Subscription Ongoing Sync Request | D2-OngoingSyncRequestUS | Instances of this business object represent individual ongoing usage subscription synchronization requests. |
Sync Request Seeder | D1-SyncRequestSeeder | Used to identify the appropriate synchronization business object to create when processing synchronization requests. |
Contact Synchronization Add | D1-SynchronizationAddContact | Used when adding a new contact as a result of a synchronization request. |
Device Configuration Synchronization Add | D1-SynchronizationAddDC | Used when adding a new device configuration as a result of a synchronization request. |
Device Synchronization Add | D1-SynchronizationAddDevice | Used when adding a new device as a result of a synchronization request. |
Install Event Synchronization Add | D1-SynchronizationAddIE | Used when adding a new install event as a result of a synchronization request. |
Measuring Component Synchronization Add | D1-SynchronizationAddMC | Used when adding a new measuring component as a result of a synchronization request. |
Service Point Synchronization Add | D1-SynchronizationAddSP | Used when adding a new service point as a result of a synchronization request. |
Usage Subscription Synchronization Add | D2-SynchronizationAddUS | Used when adding a new usage subscription as a result of a synchronization request. |
Batch Code | Name / Description |
D1-CMSYN | Composite Sync Request |
D1-SIIER | Initial Sync Request - Error |
D1-SILCN | Initial Sync Request - Load Data Contact |
D1-SILDC | Initial Sync Request - Load Data DC |
D1-SILDV | Initial Sync Request - Load Data Device |
D1-SILIE | Initial Sync Request - Load Data IE |
D1-SILMC | Initial Sync Request - Load Data MC |
D1-SILSP | Initial Sync Request - Load Data SP |
D1-SILUS | Initial Sync Request - Load Data US |
D1-SIKCN | Initial Sync Request - Resolve Keys Contact |
D1-SIKDC | Initial Sync Request - Resolve Keys DC |
D1-SIKDV | Initial Sync Request - Resolve Keys Device |
D1-SIKIE | Initial Sync Request - Resolve Keys IE |
D1-SIKMC | Initial Sync Request - Resolve Keys MC |
D1-SIKSP | Initial Sync Request - Resolve Keys SP |
D1-SIKUS | Initial Sync Request - Resolve Keys US |
D1-SIOER | Ongoing Sync Request -Error |
D1-SIOPE | Ongoing Sync Request - Pending |
D1-SRSDE | Sync Request Seeder - Error |
D2-SIKDO | Initial Sync Request - Resolve Keys DO |
D2-SIKDE | Initial Sync Request - Resolve Keys DOE |
D2-SIKUS | Initial Sync Request - Resolve Keys US |
D2-SILDO | Initial Sync Request - Load Data DO |
D2-SILDE | Initial Sync Request - Load Data DOE |
D2-SILUS | Initial Sync Request - Load Data US |
F1-SAKRQ | Sync Request Allocate Keys Monitor |
F1-SRLRQ | Sync Request Load Records Monitor |
F1-SYNRQ | Sync Request Monitor Process |
F1-SYSRQ | Sync Request Sampling Monitor (Deferred) |
Contact | Usage Subscription | Service Point | Install Event | Device Configuration | Device | Measuring Component | Dynamic Option | Dynamic Option Event | |
---|---|---|---|---|---|---|---|---|---|
Transformation / Schema Validation Job | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Key Allocation Job | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Foreign Key Resolution / BO Validation Job (dependent on ALL Key Allocation Jobs finishing) | 3 | 8 | 3 | 6 | 3 | 3 | 6 | 3 | 5 |
Load Job | 4 | 9 | 5 | 7 | 5 | 4 | 7 | 4 | 6 |
Inbound Web Service | Description | Schema Name |
D1-SyncRequestInbound | Sync Request Inbound | D1-SyncRequestSeeder (BO) |
D1-SyncRequestInboundComposite | Sync Request Inbound Composite | D1-CompositeSyncRequestDC (BO) |
Step | Process | Objects |
1 | Oracle Utilities Customer Care and Billing sends a synchronization request to the middleware integration layer. For example, consider a request to update information about a service point. | |
2 | The middleware components transforms the request from the Customer Care and Billing format, to the format used by Oracle Utilities Meter Data Management (this format is based on the business object schemas of the synchronization request business objects). | |
3 | The middleware component invoke the appropriate Inbound Web Service, and sends the transformed request. | Inbound Web Service: D1- SyncRequestInbound (mapped to the D1- SynrRequestSeeder business object) |
4 | The Inbound Web Service invokes the Sync Request Seeder business object, which in turn, determines which synchronization request business object to create (based on the type of data in the synchronization request and the Seeder Sync Master Configuration). | Synchronization Request BO: D1- OngoingSyncRequestSP |
5 | For initial synchronization requests, background processing creates master data for each synchronization request, including the following steps: • Data Transformation / Schema Validation • Allocate Keys • Resolve Foreign Keys / Validate Business Object • Load Data | |
6 | For ongoing synchronization requests, the following steps are performed by Enter algorithms on the synchronization request business object lifecycle states: • Data Transformed/Basic Schema Validated: • Determine Sync Request BO • Setup Transformed Data • Pre-Added: • Sync Request Pre-Add Data • FKs Resolved: • Resolve Keys - Ongoing Sync • Updating: • Sync Request Update Data | Setup Transformed Data Algorithm: D1- SETTRANDT Sync Request Pre-Add Data Algorithm: D1-SR-PREADD Resolve Keys - Ongoing Sync Algorithm: D1-RESKEYFAL Sync Request Update Data Algorithm: D1- SR-UPDDAT |