Category Archives: ERP - Page 4

Relink of module “FNDXIT.dll” failed

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

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

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

 

SQL*Loader-404: Column CHAR present more than once

Problem:

When loading data via SQL*Loader into a table on an 11g database, the following message appears:

SQL*Loader-404: Column CHAR present more than once in APPS.TMP_HRDPV_CREATE_IN_CWK's 
INTO TABLE block.

Solution:

In the SQL*Loader control file, the column names had comma after them. There should be whitespace, and then CHAR followed by comma.

You do not have permission to use this software

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

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

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]

JDK for Linux SQL Developer

Problem:

After installing SQL Developer on Linux, which Java JDK should be installed?

Solution:

On the Java SE Downloads page (http://www.oracle.com/technetwork/java/javase/downloads/index.html), locate the Java SE Development Kit 6 Update 31 section (http://www.oracle.com/technetwork/java/javase/downloads/jdk-6u31-download-1501634.html), and download and install the Linux version of the JDK:

Linux x86 (32-bit)    77.07 MB        jdk-6u31-linux-i586-rpm.bin
http://download.oracle.com/otn-pub/java/jdk/6u31-b04/jdk-6u31-linux-i586-rpm.bin

File /etc/oratab is not accessible.

Problem:

After installing 11g on Oracle Linux 5, the database was not automatically created. After exiting OUI and manually running dbca, the following error appears:

File /etc/oratab is not accessible.

Solution:

The script root.sh was not run. Log on as the root user and then run $ORACLE_HOME/root.sh (usually /u01/app/oracle/product/11.1.0/db_1/root.sh).

[amazon asin=0071598758&template=iframe image&chan=default]     [amazon asin=0596514549&template=iframe image&chan=default]     [amazon asin=0071496610&template=iframe image&chan=default]

sqlplus: error while loading shared libraries

Problem:

After installing 11g on Oracle Linux 5 and running SQL*Plus, the following error appears:

sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: 
cannot restore segment prot after reloc: Permission denied

Solution:

Turn off SELinux. As root user, issue the following command:

/usr/sbin/setenforce 0

Creating additional Linux swapfile

Problem:

After installing Linux in a virtual machine, the memory is increased from 512MB to 1536MB. The swap file must be increased as well, but there is no additional hard drive space or partitions to increase the swap partition.

Solution:

Create a new swap file:

1. As the root user, create a 3072MB swap file (block size=1024 bytes, count=1024*3072 blocks):

dd if=/dev/zero of=/swapfile1 bs=1024 count=3145728

2. Create swap file in swapfile1:

mkswap /swapfile1

3. Set file permissions for swapfile1:

chmod 0600 /swapfile1

4. Turn on swapfile:

swapon /swapfile1

5. Add swapfile to fstab:

Edit /etc/fstab and add the following line:

/swapfile1 swap swap defaults 0 0

Reference:

http://www.cyberciti.biz/faq/linux-add-a-swap-file-howto/