foalabs

Query to find the User preferences set for a User in Oracle Apps/EBS We can use below query to check preferences set for a user.  In this example I am checking the preferences set for user related to workflow/mails. select * from fnd_user_preferences where PREFERENCE_NAME='MAILTYPE' and MODULE_NAME = 'WF' and user_name in  ('HIMANSHU.SINGH'); select preference_value from fnd_user_preferences where user_name='HIMANSHU.SINGH' and preference_name='MAILTYPE'; select distinct PREFERENCE_VALUE from fnd_user_preferences where PREFERENCE_VALUE  like '%MAI%' select PREFERENCE_VALUE from FND_USER_PREFERENCES where USER_NAME='-WF_DEFAULT-' and MODULE_NAME='WF' and PREFERENCE_NAME='MAILTYPE' ; select * from wf_local_roles where notification_preference in ('DISABLED','QUERY') and orig_system='PER' and name in ('HIMANSHU.SINGH');

Some useful Commands for ASM I am sharing few useful commands related to ASM which can be used for DBA's. 1) Check if the ASM disk is a Member or not. In the below example I am using condition to check the path because all my DISK name are configured with Instance name. select path, header_status,name from v$asm_disk where header_status='MEMBER' and PATH like '%PROD%'; select path, header_status,name from v$asm_disk where header_status='FORMER' and PATH like '%PROD%'; 2) List all DISK in ASM. /usr/sbin/oracleasm listdisks  3)  Find Serial Number for a DISK. sudo /usr/local/bin/asm2serial "PROD_DATA01 PROD_DATA02" PROD_DATA01 : 742b00000ac084 (/dev/mapper/inf01_asm_data08) PROD_DATA02: 742b0000ac092 (/dev/mapper/inf01_asm_data09) 4) Find free and used space in DISKGROUP. SELECT name, free_mb, total_mb, total_mb-free_mb "USED_MB", free_mb/total_mb*100 "%FREE" FROM v$asm_disk...

How to submit a concurrent program using the CONCSUB utility in Oracle Apps/EBS Syntax for CONCSUB utility CONCSUB <APPS username>/<APPS password> \ <responsibility application short name> \ <responsibility name> \ <username> \ [WAIT=N|Y|<n seconds>] \ CONCURRENT \ <program application short name> \ <program name> \ [PROGRAM_NAME=”<description>”] \ [REPEAT_TIME=<resubmission time>] \ [REPEAT_INTERVAL= <number>] \ [REPEAT_INTERVAL_UNIT=< resubmission unit>] \ [REPEAT_INTERVAL_TYPE=< resubmission type>] \ [REPEAT_END=<resubmission end date and time>] \ [START=<date>] \ [IMPLICIT=< type of concurrent request> \ [<parameter 1> ... <parameter n>] How to pass a parameter through CONCSUB: Example: '"08JUN96 23:55:00"' Parameters and Meaning  Required. The ORACLE username and password that provides access to the data that the program uses.  Requ...

If we have a EBS instance in  R12.2.x and it is configured with multiple nodes, then we can use the below commands to stop and start all services at one time. To stop all services on all nodes adstpall.sh apps/apps_password -mode=allnodes To Start all services on all nodes adstrtal.sh apps/apps_password -mode=allnodes (The above commands will ask for WebLogic password) This command will internally connect all the nodes via ssh as you would have enabled ssh as part of R12.2.x pre-requisites setup. If you have not enabled ssh, you will not be able to apply patches in remote nodes and it will get failed. If we want to skip stopping of weblogic admin services then we can use below commands adstpall.sh apps/apps -skipNM -skipAdmin