Send unix text to your email

mail -s "FILE XFER Script" first.lastname@artesyn.com <file_xfer.sh

QUERY TO FIND RESPONSIBILITIES ATTACHED TO A USER IN ORACLE R12

select fu.user_id,
       fu.user_name,
       furg.RESPONSIBILITY_APPLICATION_ID,
       frv.RESPONSIBILITY_NAME
  from FND_USER fu, FND_USER_RESP_GROUPS furg, FND_RESPONSIBILITY_VL frv
 where fu.user_id = furg.user_id
   and furg.responsibility_id = frv.responsibility_id
   and fu.user_name like 'DAV4635'

How to stop a stubborn concurrent request

select ORACLE_PROCESS_ID from apps.fnd_concurrent_requests where REQUEST_ID='137716679';

137716679

update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id='&REQUEST_ID';

select ORACLE_PROCESS_ID,phase_code,status_code from apps.fnd_concurrent_requests where REQUEST_ID='137716679';

update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id='137716679';

ADOP phase=fs_clone fails with validation error: the value of s_apps_jdbc_connect_descriptor in PATCH Context File is NULL

1. echo $CONTEXT_FILE
2. cat /upgrade/R12_R12D2/fs1/inst/apps/R12D2_lich/appl/admin/R12D2_lich.xml | grep s_jdbc_connect_descriptor
3. go to fs2
4. vi R12D2_lich.xml
5. replace <jdbc_url oa_var="s_apps_jdbc_connect_descriptor/"> with <jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=ghoul.ecp.priv)(PORT=1531)))(CONNECT_DATA=(SERVICE_NAME=R12D2)))</jdbc_url>

Check EBS Installed Modules/Versions

Problem:
How to check if certain Oracle Applications modules/products are installed, and their versions?

Solution:
You can run script adutconf.sql

1. From Application tier, go into:
          cd $AD_TOP/sql/

2. Execute:
         sqlplus apps/<password> @adutconf.sql

File adutconf.ls will be created in directory $AD_TOP/sql

Check product name by searching for “Product” in list file

Cause: FDPSTP failed due to ORA-20100: FND_FILE could not write to file

They were trying to import items from the items menu thru the inventory responsibility. In the logs it shows

**Starts**21-MAY-2018 18:13:02

**SQL error and free**21-MAY-2018 18:13:02

ORACLE error 20100 in FDPSTP

Cause: FDPSTP failed due to ORA-20100: FND_FILE could not write to file l0263903.tmp.

An operating system error occurred during the write operation.

Contact your system administrator. (TEMP_DIR=/dbapps/tmp)

ORA-06512: at "APP21-MAY-2018 18:13:02

Solution

Check if $APPLPTMP on the application server node is the same as the utl_file_dir parameter on the database. In this example mine was /dbapps/tmp

• On the application server node environment 
• $ echo $APPLPTMP
• /dbapps/tmp
• On the database 
• SQL> show parameter utl_file_dir
• 
  
• NAME                                 TYPE        VALUE
• ------------------------------------ ----------- ------------------------------
• utl_file_dir                         string      /dbapps/tmp
• Run this on the database

1. • exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
   • BEGIN FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST'); END;
   • SQL> show user
   • USER is "APPS"
   • SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');
   • BEGIN FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST'); END;
   • PL/SQL procedure successfully completed.
   • 
     
   • SQL>
   •   2  /
   • 
     
   • PL/SQL procedure successfully completed.

• Go to the /dbapps/tmp directory on the DATABASE node!!! 
• cat the last file that was generated
• -rw-r--r-- 1 oracle dba  0 May 21 23:17 o0263921.tmp
• -rw-r--r-- 1 oracle dba 30 May 21 23:17 l0263921.tmp
• ! R12D2:ghoul.ecp.priv:/dbapps/tmp> cat l0263921.tmp
• THIS IS A TEST
• THIS IS A TEST
• ! R12D2:ghoul.ecp.priv:/dbapps/tmp>
• 
  

EBS looking for Java

IE 11: Certification issue with Oracle EBS 12 (Tested in Oct-14)

Post is not my own.

The original is http://layman-is-oracleappsdba.blogspot.tw/2014/10/ie-11-certification-issue-with-oracle.html

Aim:
To resolve following error:

In order to access this application, you must install the J2SE Plugin version 1.7.x_xx. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

Cause:

Internet Explorer 11 is not certified at this time (when this blog is written).

Solution:

You have to add the particular EBS URL's domain to Compatibility Mode in IE 11.

1) Open IE window
2) Click Tools -> Compatibility View Settings
3) Add domain only

For example if your URL is

http://tstunx13.mytestdomain.net:8000

then add

mytestdomain.net

into compatibility view settings. In the image below. I have masked my settings for privacy.

After you have added the domain, restart the browser and try again. You should see similar prompt as below.

The issue is resolved !!