Users and Responsibilities in Oracle E-Business Suite

Getting to know all Oracle Users and their responsbilities within E-Business Suite? Yes, this will be required during audit purposes and also to keep a track of who has what and whether they should be using that responsibility or not.



select fu.user_name, fu.description,fu.start_date,fu.end_date,
fu.email_address, fr.responsibility_name,  furg.START_DATE, 
furg.END_DATE from fnd_user_resp_groups_direct furg,
fnd_user fu, fnd_responsibility_tl fr
-- where fu.user_name = ‘&user_name’
where furg.user_id = fu.user_id
and furg.responsibility_id = fr.responsibility_id
and fr.language = userenv('LANG')
order by 1
 

Applying PSU in Oracle Database? Check whether they have any patch conflicts

You would be better off to resolve the conflicts while applying the PSU Patches on the test environment than ignoring the conflicts, which can cause serious harm at a later stage.

To check if a particular patch has got any conflicts, run the below command from the patch directory.

$ cd 10248636
$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0
Central Inventory : /u02/oracle/FEB/DB_TIER/db/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0/oui
Log file location : /u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0/cfgtoollogs/opatch/opatch2011-03-11_08-57-14AM.log

Patch history file: /u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.

Prereq "checkConflictAgainstOHWithDetail" failed.

Summary of Conflict Analysis:

There are no patches that can be applied now.

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
9032412, 10248636

Following patches will be rolled back from Oracle Home on application of the patches in the given list :
9032412

Conflicts/Supersets for each patch are:

Patch : 10248636

Conflict with 9032412
Conflict details:
/u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0/lib/libserver10.a:/kwqit.o

OPatch succeeded.


=============================================================================================================================================================

=====================================================================----------------------------------------------


$ cd 10248636
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0
Central Inventory : /u02/oracle/FEB/DB_TIER/db/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.4.0
OUI location : /u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0/oui
Log file location : /u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0/cfgtoollogs/opatch/opatch2011-03-11_08-57-31AM.log

Patch history file: /u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.

Prereq "checkConflictAgainstOHWithDetail" failed.

Summary of Conflict Analysis:

There are no patches that can be applied now.

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
9032412, 10248636

Following patches will be rolled back from Oracle Home on application of the patches in the given list :
9032412

Conflicts/Supersets for each patch are:

Patch : 10248636

Conflict with 9032412
Conflict details:
/u02/oracle/FEB/DB_TIER/db/tech_st/10.2.0/lib/libserver10.a:/kwqit.o

OPatch succeeded.
$

-----------------

The above shows that there is a conflict if I were to apply the patch 10248636.
So, I resolve the conflict, or I open an SR with Oracle and send across the log file as well as my inventory in detail so I can get a merged patch .


-----

To get your detailed inventory, execute the below command...

$ opatch lsinventory -detail