top of page
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;

/

7 views1 comment

Recent Posts

See All

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set serveroutput on format wrapped set def off set tab off exec dbms_metad

This SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for identifying scheduled requests that failed to be resubmitted. select

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id numeric(10) not null, supplier_name varchar2(50) not null, contact_na

bottom of page