Blog | LazyDeploy

Nov 19, 20202 min read

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...

108 views0 comments

Nov 19, 20201 min read

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...

6 views0 comments

Nov 19, 20201 min read

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',...

5 views0 comments

Nov 19, 20202 min read

Scheduled Concurrent Requests

select s.user_name, per.full_name, p.user_concurrent_program_name || nvl2(r.description,' ('||r.description||')',null) program,...

5 views0 comments

Nov 19, 20201 min read

Mail Preferences

-- Change user name to whatever you need update fnd_user_preferences set preference_value = 'MAILHTM2' where preference_name = 'MAILTYPE'...

5 views0 comments

Nov 19, 20201 min read

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...

9 views0 comments

Nov 19, 20201 min read

Add LOV to a Profile

1. Define custom lookup XXX_TEST_LOOKUP (Application Developer --> Lookups) 2. Define custom profile (Application Developer --> Profiles)...

5 views0 comments

Nov 19, 20201 min read

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...

10 views1 comment