Full_Load_Execution_Plan fails during LOAD_DATASOURCE_TABLE Scenario Execution (Doc ID 2097791.1)

Last updated on JANUARY 18, 2016

Applies to:

Oracle Health Sciences Cohort Explorer - Version 3.0 and later
Information in this document applies to any platform.


On Oracle® Health Sciences Translational Research Center (TRC) 3.1, when executing the Full_Load_Execution_Plan, it fails with the following error:


Steps performed:


1. From ODI connect to TRC Work Repository.

2. Go to "Topology" tab and configure the ORACLE_APPS, ORACLE_HDI, and ORACLE_TM_DATAMART connections to point to the TRC instance database, and ORACLE_HDM connection to point to HDM source database.

3. Go to "Designer" tab.

4. Under "Oracle Healthcare Analytics"/"Execution Plans"/"Initial Setup"/"Create DBLink"/"Packages" execute the following packages:

    Create HdiCdm DBLink

    Create HdmApps DBLink

    Create HdmCdm DBLink

5. Execute the "FULL_LOAD_EXECUTION_PLAN" scenario under "Execution Plans"/"Initial Setup"/"Full_Load_Execution_Plan"/"Scenarios".

6. Go to "Operator" tab and check the execution results.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms