Post-Installation Validations

Run the following query in the target database as an MDADM user and validate that the count is 12:

Select count(1) from dba_tables where owner='RELADM' and table_name like 'B1%';

Run the following query in the target database as an MDADM user and validate that count is 44:

Select count(1) from dba_tables where owner='MDADM' and table_name like 'B1%' and table_name not like '%TMP';

Run the following query in the target database as an MDADM user and validate that the total number of facts and dimensions is 68 and 295 respectively:

select targetentity,count(table_name) "Count" from (select case when substr(table_name,1,2)='CF' then 'Fact' when substr(table_name,1,2)='CD' then 'Dimension' else 'Others' end as targetentity ,t.* from dba_tables t where owner='DWADM') t where targetentity in ('Fact','Dimension') group by t.targetentity;

Run the following query in the target database as an MDADM user and validate that the count is 116:

select targetentity,count(table_name) "Count" from (select case when substr(table_name,1,4)='MLOG' then 'MV Log' else 'Others' end as targetentity ,t.* from dba_tables t where owner='DWADM') t where targetentity ='MV Log' group by t.targetentity;

Run the following query in the target database as an MDADM user and validate that product version is the version you wanted to deploy and that the applied date time is not null:

select prod_version,applied_dttm from b1_patch where patch_nbr= (select max(patch_nbr) patch_nbr from b1_patch);

Run the following query in the target database as an MDADM user and validate that no result is displayed:

select * from b1_patch_object obj where type_flg='PROJ' and patch_nbr=(Select max(patch_nbr) from b1_patch) and not exists (Select * from oua_work.snp_project p where obj.object_name=p.project_name);

Run the following query in the target database as an MDADM user and validate that no result is displayed:

select * from b1_patch_object obj Where type_flg='VAR' and patch_nbr=(Select max(patch_nbr) from b1_patch) and not exists (Select * from oua_work.SNP_VAR v where obj.object_name=v.var_name);

Run the following query in the target database as an MDADM user and validate that no result is displayed:

select * from mdadm.b1_patch_object obj where type_flg='KM' and patch_nbr=(Select max(patch_nbr) from b1_patch) and not exists (Select * from oua_work.snp_trt km where km.trt_type in ('KI','KJ','KR') and obj.object_name=km.trt_name);

Run the following query in the target database as an MDADM user and validate that no result is displayed:

select * from b1_patch_object obj where type_flg='FOLD' and operation_flg='I' and patch_nbr=(Select max(patch_nbr) from b1_patch) and not exists (Select * from oua_work.SNP_folder f where obj.object_name=f.folder_name and par_i_folder is null);

Run the following query in the target database as an MDADM user and validate that no result is displayed:

select * from mdadm.b1_patch_object obj where type_flg='MFOL' and patch_nbr=(Select max(patch_nbr) from b1_patch) and not exists (Select * from oua_work.snp_mod_folder m where obj.object_name=m.mod_folder_name);

This scenario checks for the existence of several important ETL scenarios, but not all. This is because scenario numbers might vary from version to version. If the import job completed successfully and these core framework scenarios are present, then we can safely assume that all other scenarios will be present in the repository. Run the following query in the target database as an MDADM user and validate that the count is 13:

select count(1) from oua_work.snp_scen where scen_name in ('B1_INITIAL_SETUP_PKG' ,'B1_RUN_ALL' ,'B1_CLEANUP_REPLICATION' ,'B1_FIX_REP' ,'B1_RESET_ENTITY' ,'B1_RESET_INSTANCE' ,'B1_SYNC_CONTEXT' ,'B1_SYNC_MODEL' ,'B1_SYNC_TABLE' ,'B1_FLASHBACK_REP' ,'B1_PURGE_STAGING' ,'B1_PURGE_SESSIONS' ,'B1_CLEAR_LOGS');

Run the following query in the target database as an MDADM user and validate that no result is displayed:

select * from mdadm.b1_patch_object obj where type_flg='SFOL' and patch_nbr=(Select max(patch_nbr) from b1_patch) and not exists (Select 1 from oua_work.snp_scen_folder s where (s.par_i_scen_folder=(Select i_scen_folder from oua_work.snp_scen_folder Where scen_folder_name ='Oracle Utilities BI') or scen_folder_name = 'Framework') and obj.object_name=s.scen_folder_name);

Run the following query in the target database as an MDADM user and validate that no result is displayed:

select * from oua_work.snp_session es where sess_status='E' and not exists(Select 1 from oua_work.snp_session ds Where sess_status='D' and es.sess_name=ds.sess_name);

Run the following query in the target database as an MDADM user and validate that the count is greater than zero:

Select count(1) from b1_product; Select count(1) from b1_global_cfg; Select count(1) from b1_schedule; Select count(1) from b1_storage_cfg; Select count(1) from b1_source_table; Select count(1) from b1_object_map; Select count(1) from b1_object; Select count(1) from b1_object_set; Select count(1) from b1_object_col; Select count(1) from b1_col_expr; Select count(1) from b1_join_expr; Select count(1) from b1_obfuscate_metadata;

Run the following query in the target database as an MDADM user and validate that the count is 25:

select * from all_views where owner='MDADM' and view_name like 'B1%';

Login to the Oracle Analytics Server using the analytics URL and validate that the following dashboard folders are present under Dashboard → My Dashboard.

1. About

2. Administration

3. Credit & Collection Analytics

4. Customer Analytics

5. Distribution Analytics

6. Exception Analytics

7. Meter Data Analytics

8. Mobile Workforce Analytics

9. Operational Device Analytics

10. Outage Analytics

11. Revenue Analytics

12. Work and Asset Analytics

Expand above mentioned analytics folder and dashboard(s) should be present.

Expand "About" and click on "About OUA" and verify the Oracle Utilities Analytics Warehouse version.

To validate the spatial data:

1. Login to the Oracle Analytics Server using Oracle Analytics Server using the analytics URL.

2. Go to Administration→Manage Map Data.

3. Ensure Layers, Background Maps, and Images were imported successfully.

To validate the writeback functionality:

1. Login to the Oracle Analytics Server using the analytics URL.

2. Click Dashboards and select Administration→Custom Field Maintenance Dashboard page.

3. Select Insert Page.

4. Specify Table Name, Field Name and Description.

5. Click Insert.

6. Verify that the record is inserted successfully.

Run the following query in the target database as an MDADM user and validate that five Apex users exist:

Select * from dba_users where username like 'APEX%';