Error while using mo_global.init | ORA-01031: insufficient privileges
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;