My Oracle Support Banner

ORA-20001 Upon Loading CCB Extracts Through OWB (Doc ID 1621114.1)

Last updated on MAY 23, 2019

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.3.0.0.0 to 2.5.0.0.0 [Release 2.3 to 2.5]
Information in this document applies to any platform.

Goal

OUASA 2.4.0.4
Issues in loading Production CCB extracts through OWB
Data is extracted from CCB 2.3.1 SP6 / FW V2.2.0 SP 16.

Loads of production initial extracts are run to load the dimesnions and facts from extracts through fileprocessor. The following errors are faced:

1.

 
Queries are run as per admin guide to find the mismatch in fact and dimension but there is no mismatch.
Upon checking the B1_ETL_DATA_ERR, there are a few issues related to B1FK but it is not possible to trace them in the extracts.
 

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.