search cancel

ORA-20000: Entity has not been setup in Data Warehouse Settings


Article ID: 41786


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


When I execute the "Load Data Warehouse" job, the job fails and in the bg-dwh.log, I see an error message:

"ORA-20000: Entity has not been setup in Data Warehouse Settings"


Release: All Supported
Component: Clarity Data Warehouse 


Clarity is not yet configured correctly to successfully execute the "Load Data Warehouse" job.


Set the Language and Fiscal Periods for the Data Warehouse and populate it.

Follow these steps: 

  1. Open Administration and from General Settings, click System Options.
  2. In the Data Warehouse Options section, complete the following fields:
    1. Languages
    2. Entity for Fiscal Periods
  3. Populate the Data Warehouse with Clarity Data. Run the following jobs in this order:
    1. Time Slicing
    2. Load Data Warehouse (Important! If you are running the job for the first time to populate the Data Warehouse, select the Full Load configuration in the job parameters)
    3. Load Data Warehouse Access Rights