Receivables - EBS (MOSC)

MOSC Banner

Error while using mo_global.init | ORA-01031: insufficient privileges

edited Mar 31, 2018 5:01AM in Receivables - EBS (MOSC) 10 commentsAnswered

Hi Team,

I have a requirement to use ce_200_transactions_v view to find the available transactions for reconciliation. I have a procedure that's is not in apps schema that's is being called using a concurrent program. Inside the procedure I am trying to access this table like after following the note:1235213.1

declare
L_COUNT NUMBER;

BEGIN

mo_global.init('CE');

mo_global.set_policy_context('S',p_org_id);

fnd_global.APPS_INITIALIZE(user_id=>fnd_global.user_id,
                                resp_id=>20604, -- CM Superuser
                                resp_appl_id=>260);  -- CE                             
       
cep_standard.init_security;
       

    select count(*) into l_count from ce_200_transactions_v;

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