Some Links To Oracle EBS Upgrade 12.1.1 to 12.1.3 :
http://sankaramaddi.blogspot.com/2015/11/ebs-upgrade-1211-to-1213.html
http://ermanarslan.blogspot.com/2013/09/ebs-1211-to-1213-upgrade-steps.html
http://otn-world.blogspot.com/2013/12/upgrade-oracle-ebs-r1211-to-1213.html
http://oracledbawings.blogspot.com/2011/07/upgrade-ebs-1211-to-1213.html
http://chandrasekarsivasamy.blogspot.com/2012/08/oracle-applications-upgrade-from-1211.html
NAME: Refresh Materialized View
SHORT CODE: OZFEARNMV
MODULE: Oracle Trade Management
Description: Refresh Materialized Views for Promotional Payments and Indirect Inventorty Tracking
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.
Report Parameters:
Applies to:
Oracle Application Object Library – Version: 11.5.0 to 11.5.10.2 – Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 29-MAY-2010
Goal
What tables are involved in using the system profile ‘Sign-On:Audit Level’?
Solution
There are three primary tables:
FND_LOGINS
FND_LOGIN_RESPONSIBILITIES
FND_LOGIN_RESP_FORMS
1. Least detailed level: User.
When the profile is set to User, the only table that gets updated is the table FND_LOGINS and only one record per user session.
2. Next level: Responsibility.
When the profile is set to Responsibility both FND_LOGINS and FND_LOGIN_RESPONSIBILITIES will be updated.
FND_LOGINS gets only one record per user session.
FND_LOGIN_RESPONSIBILITIES will be updated with one record for each
responsibility selected during the session.
3. Most detailed level: Form.
When the profile is set to Form all three tables are involved.
FND_LOGINS gets only one record per user session.
FND_LOGIN_RESPONSIBILITIES will be updated with one record for each
responsibility selected during the session.
FND_LOGIN_RESP_FORMS will be updated with one record for each form selected during the session.
Reference: Metalink Note 368260.1
Query # 1 :
desc v$license Name Null? Type ----------------------------------------- -------- ---------------- SESSIONS_MAX NUMBER SESSIONS_WARNING NUMBER SESSIONS_CURRENT NUMBER SESSIONS_HIGHWATER NUMBER USERS_MAX NUMBER CPU_COUNT_CURRENT NUMBER CPU_CORE_COUNT_CURRENT NUMBER CPU_SOCKET_COUNT_CURRENT NUMBER CPU_COUNT_HIGHWATER NUMBER CPU_CORE_COUNT_HIGHWATER NUMBER CPU_SOCKET_COUNT_HIGHWATER NUMBER
Query # 2 :
select sessions_current from v$license;
Query # 3 :
select SESSIONS_CURRENT,SESSIONS_HIGHWATER,CPU_COUNT_CURRENT,CPU_COUNT_HIGHWATER from v$license;
Query # 4 :
SELECT USERNAME FROM DBA_USERS
Query # 5 :
SELECT distinct user_id from FND_LOGINS
Query # 6 :
SELECT distinct user_id from icx_sessions
Query # 7 :
SELECT distinct user_id from FND_USER
Query #8:
select application_name,responsibility_name,
security_group_name, user_name,
greatest(u.start_date, ur.start_date, r.start_date) start_date,
least(nvl(u.end_date, nvl(ur.end_date, r.end_date)),
nvl(ur.end_date, nvl(u.end_date, r.end_date)),
nvl(r.end_date, nvl(u.end_date, ur.end_date))) end_date
from fnd_user u,fnd_user_resp_groups ur,
fnd_responsibility_vl r,fnd_application_vl a,
fnd_security_groups_vl s
where a.application_id = r.application_id
and u.user_id = ur.user_id
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and ur.start_date sysdate
and u.start_date sysdate
and r.start_date sysdate
and ur.security_group_id = s.security_group_id
order by application_name,responsibility_name,security_group_name, user_name
Query # 9 :
select application_name,responsibility_name,
security_group_name, user_name,
greatest(u.start_date, ur.start_date, r.start_date) start_date,
least(nvl(u.end_date, nvl(ur.end_date, r.end_date)),
nvl(ur.end_date, nvl(u.end_date, r.end_date)),
nvl(r.end_date, nvl(u.end_date, ur.end_date))) end_date
from fnd_user u,fnd_user_resp_groups ur,
fnd_responsibility_vl r,fnd_application_vl a,
fnd_security_groups_vl s
where a.application_id = r.application_id
and u.user_id = ur.user_id
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and ur.start_date sysdate
and u.start_date sysdate
and r.start_date sysdate
and ur.security_group_id = s.security_group_id
order by application_name,responsibility_name,security_group_name, user_name
Below are keyboard shortcut keys in Oracle Apps 11i. Use these to flaunt your skills in apps.. 
Trust me when you do this in front of clients it works like magic 🙂