Category Archives: R12 - Page 7

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS

Posted by on July 5, 2012 No comments

Problem:

In R12, after a concurrent request is run and the log file is viewed, when Tools –> Copy File is selected, a browser window opens and displays the following message:

An error occurred while attempting to establish an Applications File Server 
connection with the node FNDFS_. There may be a network configuration problem, 
or the TNS listener on node FNDFS_ may not be running. Please contact your 
system administrator.

Solution:

Set the RRA: Enabled system profile to Yes at the site level, log off and then log back on.

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]

Predefined HRMS Alerts Missing

Posted by on July 5, 2012 No comments

Problem:

After installing R12 on Windows 2008, the predefined HRMS alerts (referred to in the Alerts documentation) missing.

Solution:

Use the FNDLOAD command to manually upload the missing alerts.

Read more »

perl: error while loading shared libraries: libdb.so.3: cannot open shared object file: Permission denied

Posted by on July 2, 2012 No comments

Problem:

While installing R12 on Linux, the following error appears:

perl: error while loading shared libraries: libdb.so.3: cannot open shared object 
file: Permission denied

General Solution:

– As per an internal Bug:4045349, this is an issue with O/S side installation of compat-db rpm.
libdb.so.3 gets installed when compat-db rpm is installed.

– The O/S installation CD would contain compat-db
e.g compat-db-4.1.25-6.i386.rpm ( may change as per your version ).

– Manually install the compat-db rpm
e..g “rpm -ivh compat-db-4.1.25-6.i386.rpm”
(Contact the O/S Administrator for more information to install the compat-db rpm and correct  command )

– Once it is done, re-try to install the applications. ( if the screen shows the Re-try option )

OR

– Remove/clean the current installation ( refer Note:169402.1 ) and re-install the application.

This would resolve the “..libdb.so.3…” error.

Solution in this situation:

[root@oel5vis4bi lib]# pwd
/usr/lib
[root@oel5vis4bi lib]# ls -al libdb.*
lrwxrwxrwx 1 root root   22 Mar 22 15:01 libdb.so -> ../../lib/libdb-4.3.so
-rwxr-x--- 1 root root 5825 Jul  2 11:53 libdb.so.2
-rw-r--r-- 1 root root 5825 Mar 23 11:40 libdb.so.2.6078836
lrwxrwxrwx 1 root root   19 Mar 23 11:42 libdb.so.3 -> /usr/lib/libdb.so.2
[root@oel5vis4bi lib]#

libdb.so.2 extracted from patch 6078836

Change permission on libdb.so.2 to 644:

chmod 644 libdb.so.2

Reference:

11.5.10 Installation Fail on RedHat Server. Error while loading shared libraries: libdb.so.3 [ID 294043.1]

Relink of module “FNDXIT.dll” failed

Posted by on June 25, 2012 No comments

Problem:

After applying patch 12964564, FNDCPASS.exe and FNDXIT.dll no longer link.

fdspwd.obj : error LNK2019: unresolved external symbol _read_db_case_sens refere
nced in function _pwdecp
fdspwd.obj : error LNK2019: unresolved external symbol _fdget_afmnu referenced i
n function _pwdecp
fdspwd.obj : error LNK2019: unresolved external symbol _fdget_afctx referenced i
n function _pwdecp
fdspwd.obj : error LNK2019: unresolved external symbol _fdinit_afmnu referenced
in function _pwdecp
fdspwd.obj : error LNK2019: unresolved external symbol _fdinit_afctx referenced
in function _pwdecp
fdspwd.obj : error LNK2019: unresolved external symbol _fdcr_afmnu referenced in
 function _pwdecp
fdspwd.obj : error LNK2019: unresolved external symbol _fdcr_afctx referenced in
 function _pwdecp
fdspwd.obj : error LNK2019: unresolved external symbol _pwdalt_merge referenced
in function _pwdalt_usrexit
C:/oracle/DEV1/apps/apps_st/appl/fnd/12.0.0/bin/FNDXIT.dll : fatal error LNK1120
: 8 unresolved externals
gnumake: *** [C:/oracle/DEV1/apps/apps_st/appl/fnd/12.0.0/bin/FNDXIT.dll] Error
96
Done with link of fnd executable 'FNDXIT.dll' on Sat Jun 23 15:32:39 SAWST 2012

Relink of module "FNDXIT.dll" failed.

Solution:

Solved by applying patch 13855823.

Framework Pages Have Different Look and Feel in IE7

Posted by on June 24, 2012 No comments

Problem:

Oracle Applications Framework pages have different fonts and sizes in Internet Explorer 7 (IE7).

Oracle Applications Manager and Self Service screens have different fonts.

Firefox renders pages ok.

Solution:

To implement the solution, please execute the following steps:

1. Stop Apache

2. Delete files from the following directories:
$OA_HTML/cabo/images/cache/
$OA_HTML/cabo/styles/cache/

3. Start Apache

4. Clear the browser cache

Reference:

Framework Pages Have Different Look and Feel in IE7 [ID 741054.1]

The business group specified is invalid

Posted by on June 22, 2012 No comments

Problem:

After running a data pump import, the following is displayed in the “Data Pump Batch Exceptions Report”:

The business group specified is invalid

Cause:        You have specified an incorrect business group
identifier or name.
Action:        Correct the business group value or call your
local support representative.

Possible Solution:

Ensure that the business group in the data pump file matches the system profiles:

Profile > System > HR:Business Group
Profile > System > HR: Security Profile

 

You do not have permission to use this software

Posted by on June 15, 2012 No comments

Problem:

When access the Employee Self-Service page in R12, the following error appears:

Error
You do not have permission to use this software
Please contact your Information Technology Department.

Solution:

Set the system profile option ‘HR: Self Service HR Licensed’ to ‘Yes’ at the site level.

Reference:

https://forums.oracle.com/forums/thread.jspa?threadID=2370592

load: class oracle/apps/fnd/formsClient/FormsLauncher.class not found

Posted by on May 3, 2012 No comments

Problem:

After installing fresh Release 12 instance (12.1.3), attempted to log on to application from client PC (Windows XPSP3). Was able to log on to R12, but forms could not be launched. The following message was displayed on the Java console:

load: class oracle/apps/fnd/formsClient/FormsLauncher.class not found.
java.lang.ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class
	at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
	at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source)
	at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
	at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source)
	at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source)
	at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Exception: java.lang.ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class

However, other client machines (Windows 7) were able to log on and launch the forms.

Solution:

After enabling logging (Control Panel > Java > Advanced tab > Debugging, check all options), the ‘java.net.SocketException: Connection reset’ error was seen in the Java console. This indicated a network issue rather than a Java or browser issue. The EBS server (192.168.63.49) was on a different network from the client PCs (200.65.1.x). Therefore, a network route was added to keep the connection alive:

route add 192.168.63.0 mask 255.255.255.0 200.65.1.1 -p

ORA-12518: TNS:listener could not hand off client connection

Posted by on March 27, 2012 2 comments

Problem:

Unable to connect to SQL:

F:oracleVIS12dbtech_st11.1.0>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 27 11:31:04 2012

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

ERROR:
ORA-12518: TNS:listener could not hand off client connection

Solution:

Increase PROCESSES initialization parameter.

Use the following command to check the value of the PROCESSES initialization parameter in SQL*Plus:

show parameter processes

If the database was started using an spfile, then the following command can be used to change the PROCESSES initialization parameter to 500:

alter system set processes=500 scope=spfile;

If the database was started using a pfile, then the value of the processes parameter must be changed in the pfile and the database bounced.

[amazon asin=0071780262&template=iframe image&chan=default]     [amazon asin=1565922379&template=iframe image&chan=default]     [amazon asin=1430236620&template=iframe image&chan=default]

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: PER_449800_ORA_1436

Posted by on March 21, 2012 No comments

Problem:

After logging on to E-Business Suite R12.1.3 Vision instance as UKHRMS, choosing ‘Self Service for UK Managers’, launching ‘All Actions Awaiting Your Attention’ and then  selecting a notification from the list results in the following error:

Error Page  
You have encountered an unexpected error. Please contact the System Administrator for assistance.  
Click here for exception details.

After clicking here, the following error is displayed:

Error Page  
Exception Details.  
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: PER_449800_ORA_1436:
ORA-06512: at "APPS.HR_UTIL_MISC_SS", line 1161
ORA-06512: at line 1

Solution:

User Melanie Dorat had an active application which, even though it was just an application and not an assignment, had a supervisor listed for the position which was one of her employees. Terminate the application to resolve the issue.

[amazon asin=0070077290&template=iframe image&chan=default]     [amazon asin=1453742735&template=iframe image&chan=default]     [amazon asin=0615238440&template=iframe image&chan=default]