OBIA 11g: Initial SDS Load Errors Out (Doc ID 2125530.1)

Last updated on MAY 23, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

OBIA Initial SDS Load Errors Out

Error happens on the step

ERROR
-----------------------

Error occurs in the ODI SDE_ORAR122_ADAPTOR_SDE_ORA_STATUSDIMENSION_FINAPVALIDATIONSTATUS session log:


The specific error is:


In case statement its referring to table "FND_LOOKUP_VALUES", but the FROM line defines the table to be "FND_LOOKUP_VALUES_PREPAY".

Cause

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