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:
Title :
Getting “ORA-01031: insufficient privileges” error when trying to Debug.
Description :
When trying to debug a procedure, package, etc., the following error messages are received:
ORA-01031: insufficient privileges
Cause :
The Oracle user or schema account does not have the required Oracle rights to debug an object.
Resolution :
Ensure the User or Schema has all the required Oracle privileges granted for debugging objects on that database.
1. connect as sysdba
2. exec the sql:
grant debug connect session to XXXXXX;
or
grant DEBUG ANY PROCEDURE to XXXXXX;;
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