select usr.user_id, usr.user_name, res.RESPONSIBILITY_ID, res.RESPONSIBILITY_NAME
from apps.FND_USER usr, apps.FND_RESPONSIBILITY_TL res, apps.FND_USER_RESP_GROUPS grp
where upper(res.RESPONSIBILITY_NAME) like upper('%' || NVL('&EnterRespName', 'INV')|| '%')
and upper(res.RESPONSIBILITY_NAME) NOT like '%AX%'
and upper(res.RESPONSIBILITY_NAME) NOT like '%OPM%'
and grp.responsibility_id = res.responsibility_id
and grp.user_id = usr.user_id;
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
I’ve tried using this statement below to find an appropriate column based on what I think it should be named but it returned no results :
SELECT * from dba_objects WHERE
object_name like '%DTN%'
A column isn't an object. If you mean that you expect the column name to be like '%DTN%', the query you want is:
SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE '%DTN%';
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;;