Set up a database session for manually testing application code using SQL*Plus

declare

m_user_id number := 0;

m_resp_id number := 0;

m_resp_appl_id number := 0;

begin

-- Change responibility name to whatever you need

select application_id, responsibility_id

into m_resp_appl_id, m_resp_id

from fnd_responsibility_tl

where responsibility_name = 'System Administrator'

and language = 'US';

-- Change user name to whatever you need

select user_id

into m_user_id

from fnd_user

where user_name = 'SYSADMIN';

fnd_global.apps_initialize (m_user_id, m_resp_id, m_resp_appl_id);

end;

/