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 11.1.1.3.00 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.


Symptoms

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(SnpScen.java)
at com.sunopsis.dwg.dbobj.SnpScen.localExecuteSync(SnpScen.java)
at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java)
at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(SnpSessTaskSqlS.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
at com.sunopsis.dwg.cmd.e.i(e.java)
at com.sunopsis.dwg.cmd.h.y(h.java)
at com.sunopsis.dwg.cmd.e.run(e.java)
at java.lang.Thread.run(Unknown 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
YYYY-MM-DD HH:MM:SS DEBUG [AIF]:
SELECT mdd.MAPPING_TYPE_CODE
,mdd.COA_LINE_ID1
,mdd.COA_LINE_ID2
,mdd.COA_LINE_ID3
,mdd.COA_LINE_ID4
,mdd.COA_LINE_ID5
,dim.TARGET_DIMENSION_NAME
FROM AIF_MAP_DIM_DETAILS_V mdd
,AIF_MAPPING_RULES map
,AIF_DIMENSIONS dim
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;

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