Technology Stack - EBS (MOSC)

MOSC Banner

Cannot run mo_global and fnd_global procedures in login trigger of a custom schema.

edited Dec 7, 2013 8:17PM in Technology Stack - EBS (MOSC) 2 commentsAnswered
Hello

We have an EBS 12.1.3 system and we want to create a guest database user that will enable other systems to view some data from our system.
We should enable security so that users sees the data so we created a login trigger for that user that looks like this:
CREATE OR REPLACE TRIGGER SYS.RELAX_GUEST_LOGON_TRC
AFTER LOGON
ON RELAX_GUEST.SCHEMA
begin
APPS.fnd_global.apps_initialize(135073,20420,200);
APPS.mo_global.init('AR','S');
exception
when others then
raise_application_error(-20005,sqlerrm);
end;
/

However, when the user tries to login an error occurs:
ORA-00604: error occurred at recursive SQL level 1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center