My Oracle Support Banner

Issues In OUA Application (Doc ID 2681140.1)

Last updated on SEPTEMBER 14, 2022

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.0.12 and later
Information in this document applies to any platform.

Goal

**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

OUA - Oracle Utilities Analytics
MV - Materialized View
MDM - Oracle Utilities Meter Data Management
DB - Database

While performing initial sync in OUA, need assistance on below points:


1. B1_CONSUMPTION_MON_MV1 MV is deleted from Database, how can it be restored? Need to restore only 1 MV which is deleted directly from database. Re-sync will perform for all entities. Is there manual way to create for MV only ?
2. How to refresh OUA and MDM DB specific MV?
3. Many of MV specific jobs are not getting executed and last sync date is 01-01-2001 only. Why is that? It was understood that if any of the dependent tables in MV is having last sync date as 01-01-2001 while other tables have 22-05-2020, MV's last sync date will be 01-01-2001 only. It will not execute with latest date until the dependent table dates get updated. Kindly confirm.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.