An ERPI EBS GL Dimension Load Rule Fails With Error: "ORA-00942: Table or View Does Not Exist" (Doc ID 1157855.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version and later
Information in this document applies to any platform.
***Checked for relevance on 3.2.15***
ERPI has been configured to use an Oracle schema for the database back end.


When running an ERPI E-Business Suite (EBS) GL Dimension Load Rule that is being run for the first time it fails with the Oracle database error below in the AIF_x.log file (where x is the number of the process ID):

YYYY-MM-DD HH:MM:SS FATAL [AIF]: Error in LKM EBS Extract Members Table VS - Process Value Sets
Traceback (most recent call last):
File "<string>", line 93, in ?
java.sql.SQLException: java.sql.SQLException: ORA-00942: table or view does not exist

YYYY-MM-DD HH:MM:SS FATAL [AIF]: Error in EBS Load Dimension Members
java.lang.Exception: The scenario did not end properly.
at com.sunopsis.dwg.dbobj.SnpScen.a(
at com.sunopsis.dwg.dbobj.SnpScen.localExecuteSync(
at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(
at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(
at com.sunopsis.dwg.cmd.e.i(
at com.sunopsis.dwg.cmd.h.y(
at Source)

The section of the log file before the error appears shows a SELECT FROM statement against the AIF_MAP_DIM_DETAILS_V view in the ERPI schema:

YYYY-MM-DD HH:MM:SS INFO [AIF]: LKM EBS Extract Members Table VS - Process Value Sets - START
etc .....

When the following SQL query is run when logged on to the Oracle instance as the ERPI schema user you do not see the CREATE VIEW privilege:

SELECT privilege "Privilege" FROM user_sys_privs ORDER BY privilege;


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