EBS Customizations (MOSC)

MOSC Banner

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);

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