OBIA 11g: PSFT 9.2 ELM Missing Tables 'Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist' (Doc ID 2161157.1)

Last updated on MAY 12, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.

Symptoms

Performing an Out of the Box (OOTB) Domain data Load Plan for PeopleSoft (PSFT) 9.2 ELM. In this case PSFT HCM other lower version.  And getting errors for missing PeopleSoft tables.

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