Cannot run mo_global and fnd_global procedures in login trigger of a custom schema.
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
Tagged:
0