Initialization of Peoplesoft ERP Source System With FDMEE Fails With "ODI-1228" Error

(Doc ID 1675952.1)

Last updated on MARCH 05, 2018

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version and later
Information in this document applies to any platform.


When using peoplesoft as a source system, it is not possible to initialize the source system. The following error is returned.

"ODI-1217: Session PS_GL_SETUP_SOURCE_SYSTEM (232501) fails with return code
 942. ODI-1226: Step p_ps_sql_db_type_fin fails after 1 attempt(s). ODI-1228:
 Task p_ps_sql_db_type_fin (Variable) fails on the target connection
 PSFT_FMS_DATA_SERVER. Caused By: java.sql.SQLSyntaxErrorException: ORA-942:
 table or view does not exist at
 oracle.jdbc.driver.T4CTTIoer.processError( at
 oracle.jdbc.driver.T4CTTIoer.processError( at
 oracle.jdbc.driver.T4C8Oall.processError( at
 oracle.jdbc.driver.T4CTTIfun.receive( at
 oracle.jdbc.driver.T4CTTIfun.doRPC( at


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