top of page

LazyDeploy.com
It's just one click!
Search
NLS_LANG during Export/Import
1. How does NLS affect import/export? Import and export are client products, in the same way as SQL*Plus or Oracle Forms, and will...

mdvorkin
Nov 19, 20202 min read
108 views
0 comments
User's Active Responsibilities
-- Change SYSADMIN to whatever you need select distinct u.user_name, r.responsibility_name, g.start_date, g.end_date from...

mdvorkin
Nov 19, 20201 min read
6 views
0 comments
Cancel Concurrent Request
Cancell all requests submitted by a user -- Change user name to whatever you need update FND_CONCURRENT_REQUESTS set phase_code = 'C',...

mdvorkin
Nov 19, 20201 min read
6 views
0 comments
Scheduled Concurrent Requests
select s.user_name, per.full_name, p.user_concurrent_program_name || nvl2(r.description,' ('||r.description||')',null) program,...

mdvorkin
Nov 19, 20202 min read
5 views
0 comments
Mail Preferences
-- Change user name to whatever you need update fnd_user_preferences set preference_value = 'MAILHTM2' where preference_name = 'MAILTYPE'...

mdvorkin
Nov 19, 20201 min read
5 views
0 comments
Compile JSP
cd $OA_HTML # Change JSP file name (OracleOasis.jsp) to whatever you need perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile -s...

mdvorkin
Nov 19, 20201 min read
10 views
0 comments
Add LOV to a Profile
1. Define custom lookup XXX_TEST_LOOKUP (Application Developer --> Lookups) 2. Define custom profile (Application Developer --> Profiles)...

mdvorkin
Nov 19, 20201 min read
5 views
0 comments
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...

mdvorkin
Nov 19, 20201 min read
12 views
1 comment
bottom of page