Cannot access mtl_organizations with HR:Security profile from APEX
Hi,
we have a HR: Security Profile for a user that restricts access to certain inventory organizations. That profile is assigned to a user.
Then we have a procedure as follows:
CREATE or replace PROCEDURE apps.xxis_mtl_param_test
AUTHID definer
AS
l_tmp VARCHAR2(200);
BEGIN
dbms_output.put_line('starting; DB-User is:'||user );
dbms_output.put_line('starting; EBS-user was: '||fnd_global.user_id);
fnd_global.apps_initialize(6004, 50541, 660);
dbms_output.put_line('user is now: '||fnd_global.user_id);
SELECT
LISTAGG(organization_code, ';')
INTO l_tmp
FROM
mtl_organizations;
dbms_output.put_line('l_tmp: '||l_tmp);