We have created a responsibility and menu that invokes an APEX app. I successfully log into the app using the EBS credentials, but when I issue the command APPS.FND_GLOBAL.APPS_INITIATE( x, y, z) in the prerendering process P1_GET_USER_ATTRIBUTES of the home page, I encounter an error "ORA-00942: table or view does not exist" - When I run the app native from APEX I encounter the same thing:
ORA-00942: table or view does not exist
Technical Info (only visible for developers)- is_internal_error: false
- ora_sqlcode: -942
- ora_sqlerrm: ORA-00942: table or view does not exist
- component.type: APEX_APPLICATION_PAGE_PROCESS
- component.id: 3838704253574219
- component.name: P1_GET_USER_ATTRIBUTES
- error_backtrace: ORA-06512: at "APPS.FND_CORE_LOG", line 45 ORA-06512: at "APPS.FND_GLOBAL", line 135 ORA-06512: at "APPS.FND_GLOBAL", line 1971 ORA-06512: at "APPS.FND_GLOBAL", line 2607 ORA-06512: at "APPS.FND_GLOBAL", line 2759 ORA-06512: at "APPS.FND_GLOBAL", line 2697 ORA-06512: at line 20 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1033 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1047 ORA-06512: at "APEX_050000.WWV_FLOW_DYNAMIC_EXEC", line 889 ORA-06512: at "APEX_050000.WWV_FLOW_PROCESS_NATIVE", line 65 ORA-06512: at "APEX_050000.WWV_FLOW_PROCESS_NATIVE", line 1083 ORA-06512: at "APEX_050000.WWV_FLOW_PLUGIN", line 2017 ORA-06512: at "APEX_050000.WWV_FLOW_PROCESS", line 188
- error_statement:
begin
SELECT user_id, ebs_organization_id, ebs_login_id, can_create_work_docs, app_admin_flag
INTO :AV_USER_ID, :AV_EAM_ORG_ID, :AV_EBS_USER_ID, :AV_CAN_CONVERT, :AV_APP_ADMIN
FROM wologs_users
WHERE login_code = :APP_USER;
SELECT organization_code INTO :AV_EAM_ORG_CODE
FROM apps.mtl_parameters_view
WHERE organization_id = :AV_EAM_ORG_ID;
:EBS_APP_ID := 0;
:EBS_RESP_ID := 65980;
APPS.FND_GLOBAL.APPS_INITIALIZE(:AV_EBS_USER_ID,:EBS_RESP_ID,:EBS_APP_ID);
:EBS_SESSION_ID:=APPS.FND_GLOBAL.LOGIN_ID();
end;
If I remove the call to APPS.FND_LOABAL.APPS_INITIALIZE I successfully display the home page.