OGL EPF: JBO-27122 and ORA-00942 Table or View Does Not Exist When Running Balance Rules (Doc ID 353493.1)

Last updated on MARCH 20, 2013

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 12.0.0 [Release 11.5 to 12]
Information in this document applies to any platform.
OGL EPF Data Integration
FEM

Checked for relevance on 20-Mar-2013.

Symptoms

Users get JBO-27122 and ORA-00942 Table or view cannot be found error messages when trying to select "From Period" or "To Period" in GL Balances Screen.  These errors occur for both Actual and Budget.  The SQL statement referenced when you try to run Budget is a different select statement.
   
    Here is the navigation path:
    ENTERPRISE PERFORMANCE FOUNDATION ADMINISTRATOR(1)
    DATA RULES
    ORACLE DATA SOURCES
    LEDGER= select a ledger
    RULE= select a rule
    [GO]
   
    In the GL Balances screen (Balances Rules), you will see
   
    US Set of Books
      Gl Actual Balances
        GL Actual Balances V1
    
    Start Date=01-Jan-1900
    End Date=01-Jan-2500
    Duplicate (Blue)
    Run(Blue)
    Update(Blue)
   
    Click Run
    

Rule=select a rule
Version=select a version
From Period: APR% (flashlight)
        

Get the error message in a new popup window:  You have encountered an unexpected error.  Please contact the System Administrator for assistance.  Click here for exception details.
   
When you click the word HERE you get the following JBO and ORA error:
   
Exception Details.
   
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM
(SELECT period_name, start_date, end_date, object_definition_id
FROM GL_PERIOD_STATUSES ps, FEM_INTG_BAL_RULES br, FEM_OBJECT_DEFINITION_B
odb WHERE br.bal_rule_obj_id = odb.object_id AND ps.application_id = 101
AND ps.set_of_books_id = br.ledger_id
AND ps.closing_status IN ('C', 'O', 'P')
AND ps.end_date BETWEEN odb.effective_start_date
AND odb.effective_end_date
ORDER BY ps.period_year desc, ps.period_num desc) QRSLT  WHERE ((
UPPER(PERIOD_NAME)  like  :1 AND  OBJECT_DEFINITION_ID  =  :2 ))
at
oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
at
...oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
            at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
            at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
            at oracle.jsp.JspServlet.service(JspServlet.java:156)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
            at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
            at org.apache.jserv.JServConnection.run(JServConnection.java:294)
            at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.sql.SQLException: ORA-00942: table or view does not exist
   

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