APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00942 when running application after import

FriedaAug 16 2012 — edited Aug 16 2012

APEX 4.1.1

Hi,

I transferred my application via export/import to our production database. I got no errors during installation, but when I run the application I am getting the following error message.

User not found
ORA-00942: table or view does not exist

Technical Info (only visible for developers)

    is_internal_error: true
    ora_sqlcode: -942
    ora_sqlerrm: ORA-00942: table or view does not exist
    component.type: APEX_APPLICATION_COMPUTATIONS
    component.id: 3102806535980644
    component.name: LANG
    error_backtrace:

    ORA-06512: at "SYS.DBMS_SYS_SQL", line 1325
    ORA-06512: at "SYS.WWV_DBMS_SQL", line 1287
    ORA-06512: at "SYS.WWV_DBMS_SQL", line 1358
    ORA-06512: at "SYS.WWV_DBMS_SQL", line 1375
    ORA-06512: at "APEX_040100.WWV_FLOW_DYNAMIC_EXEC", line 776
    ORA-06512: at "APEX_040100.WWV_FLOW", line 4155

I do not know, where to look for the error. I do have an application item with the name LANG and there is an application computation for LANG:

SELECT  LANG_CODE
FROM    GPS_WEB_USERS
WHERE user_name = upper('&APP_USER.')

Any Hints where to look?

Edited by: Anne-Marie Rosa on Aug 16, 2012 5:37 AM

Edited by: Anne-Marie Rosa on Aug 16, 2012 6:32 AM

This post has been answered by Prabodh on Aug 16 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2012

Added on Aug 16 2012

#apex, #apex-discussions, #export, #import

4 comments

1,749 views