Search

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;

/

4 views0 comments

Recent Posts

See All

After logon trigger - trace user sessions

-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the conditions for activating trace -- SYS.XX_LOGIN_TRACED_SESSIONS - con

INCLUDE parameter of expdp

-- Export all public database links expdp user/password full=y \ include=db_link:"in (select db_link from dba_db_links where owner = 'PUBLIC')" -- Export one table expdp user/password include=table:"i

Multiplexing Redo Log and Control files

-- List redo log files select group#, member from v$logfile order by group#, member; -- Check redo log file status select group#, members, status from v$log; -- Adding redo log file to a group alter d