SELECT ot.user_profile_option_name,
TO_CHAR (v.level_id) level_id,
DECODE (v.level_id,
10001, ‘Site’,
10002, ‘Application’,
10003, ‘Responsibility’,
10004, ‘User ID’,
v.level_id)
level_meaning,
DECODE (v.level_id,
10001, ‘Site’,
10002, apl.application_name,
10003, frt.responsibility_name,
10004, u.user_name,
v.level_id)
level_name,
v.profile_option_value,
o.profile_option_name,
v.creation_date value_creation_date,
v.created_by value_created_by,
v.last_update_date value_last_updated_date,
v.last_updated_by value_last_updated_by
FROM applsys.fnd_profile_options_tl ot,
applsys.fnd_profile_options o,
applsys.fnd_profile_option_values v,
applsys.fnd_responsibility_tl frt,
apps.fnd_application_vl apl,
fnd_user u
WHERE v.level_value = frt.responsibility_id(+)
AND v.profile_option_id = o.profile_option_id
AND o.profile_option_name = ot.profile_option_name
AND ot.language = ‘US’
AND NVL (frt.language, ‘US’) = ‘US’
AND v.level_value = apl.application_id(+)
AND u.user_id(+) = v.level_value
ORDER BY ot.user_profile_option_name,
v.level_id,
DECODE (v.level_id,
10001, ‘Site’,
10002, ‘Application’,
10003, frt.responsibility_name,
10004, u.user_name,
v.level_id);
Archive for the ‘Oracle’ Category
Query To Get The Profile Option Configurations
February 20th, 2022, posted in Oracle EBS Application, Oracle QueriesQuery To Get The Front End URL From Backend
February 6th, 2022, posted in Oracle EBS Application, Oracle Queries
SWAP size Adding While installing a Oracle Database 19c on Oracle Linux
January 30th, 2022, posted in Oracle, Solaris
SWAP Size Adding size while installing a Oracle Database 19c on Oracle Linux
Below is the error message I received while I was trying to install Oracle Database 19c on Oracle Linux 7.
PRVF-7573 : Sufficient swap size is not available on node
As per my error on the installer screen I needed 16GB of SWAP space where as my system has just 4GB. So I need to add a swap file for the installation to continue.
Below steps will outline the steps for the same.
dd if=/dev/sdb of=/tmp/swap01 bs=1K count=16M
chmod 600 /tmp/swap01
mkswap /tmp/swap01
swapon /tmp/swap01
Make sure the bs (*) count is equal to your required SWAP space. Also, the /dev/sdb has enough storage as needed
Current Login Users List In Oracle EBS R12 11i
January 23rd, 2022, posted in Oracle EBS Application, Oracle QueriesRun the following query to find out who are the Oracle Apps Users currently Logged into the application.
SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description FROM icx_sessions icx, fnd_user fu WHERE disabled_flag != 'Y' AND icx.pseudo_flag = 'N' AND (last_connect + DECODE (fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'), NULL, limit_time, 0 , limit_time, fnd_profile.VALUE ('ICX_SESSION_TIMEOUT')/60) / 24) > SYSDATE AND icx.counter < limit_connects AND icx.user_id = fu.user_id;
PLS-00201: identifier UTL MAIL.SEND must be declared
January 9th, 2022, posted in Oracle QueriesPLS-00201: identifier ‘UTL_MAIL.SEND’ must be declared
During execution of the package use UTL Mail package for send the mail may give the error PLS-00201. It may be caused due to in configured of UTL Mail package in the database. You may configure the UTL Mail package with following script:
Error:
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_MAIL.SEND' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Solution:
1. Set the Oracle Home Environment Variable
Set ORACLE_HOME=D:\Oracle\12.1.0\dbhome_1
set PATH=%ORACLE_HOME%\bin;%PATH%
2. Connect with sqlplus / as sysdba
@?\rdbms\admin\utlmail.sql;
@?\rdbms\admin\prvtmail.plb;
3. Set up the Parameter SMTP server.
ALTER SYSTEM SET smtp_out_server='address:25' SCOPE=BOTH;
4. Grant the user with required permission.
GRANT execute ON utl_mail TO NEWUSER;