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

Some VirtualBox Commands

VBoxManage Commands

By default, the VBoxManage command (VBoxManage.exe) on Windows is located in the C:Program FilesOracleVirtualBox directory. You need to change to this directory or place this directory in the PATH environment variable.

1. To list all existing virtual hard drives:

VBoxManage list hdds

For example:

UUID:        1817c1f6-6888-4105-b46d-e3135a99cfcb
Parent UUID: base
Format:      VDI
Location:    C:VasudevVirtualBoxWindows XPWindows XP.vdi
State:       inaccessible
Type:        normal

UUID:        260bd00a-d35e-47b5-8c4d-1821ec008818
Parent UUID: 1817c1f6-6888-4105-b46d-e3135a99cfcb
Format:      VDI
Location:    E:VirtualBoxWindows XPSnapshots/{260bd00a-d35e-47b5-8c4d-1821ec0
08818}.vdi
State:       created
Type:        normal

UUID:        712e180b-bbf0-4d0d-ac64-81d545a5669e
Parent UUID: 1817c1f6-6888-4105-b46d-e3135a99cfcb
Format:      VDI
Location:    E:VirtualBoxWindows XPSnapshots/{712e180b-bbf0-4d0d-ac64-81d545a
5669e}.vdi
State:       created
Type:        normal

2. To remove an existing or inaccessible virtual hard drive:

VBoxManage closemedium      disk|dvd|floppy <uuid>|<filename>
                            [--delete]

For example:

C:Program FilesOracleVirtualBox>VBoxManage.exe closemedium disk 1817c1f6-6888
-4105-b46d-e3135a99cfcb
VBoxManage.exe: error: Cannot close medium 'C:VasudevVirtualBoxWindows XPWin
dows XP.vdi' because it has 2 child media
VBoxManage.exe: error: Details: code VBOX_E_OBJECT_IN_USE (0x80bb000c), componen
t Medium, interface IMedium, callee IUnknown
Context: "Close()" at line 1186 of file VBoxManageDisk.cpp

C:Program FilesOracleVirtualBox>VBoxManage.exe closemedium disk 260bd00a-d35e
-47b5-8c4d-1821ec008818

C:Program FilesOracleVirtualBox>VBoxManage.exe closemedium disk 712e180b-bbf0
-4d0d-ac64-81d545a5669e

C:Program FilesOracleVirtualBox>VBoxManage.exe closemedium disk 1817c1f6-6888
-4105-b46d-e3135a99cfcb

C:Program FilesOracleVirtualBox>

3. To start a virtual machine without a console (i.e. ‘headless’):

VBoxManage startvm          <uuid>|<name>...
                            [--type gui|sdl|headless]

dsfdfs

4. After manually copying a VirtualBox hard drive in Windows Explorer and adding it to a newly created VM in the VirtualBox GUI, the following error appears:

Failed to open the hard disk J:VirtualBoxPatch11iPatch11i1.vdi.
Cannot register the hard disk 'J:VirtualBoxPatch11iPatch11i1.vdi' 
{d2696d49-07c6-46bd-9e31-84b4c5fa649b} because a hard disk 
'I:VirtualBoxOEL5VIS4BIOEL5VIS4I1.vdi' with UUID 
{d2696d49-07c6-46bd-9e31-84b4c5fa649b} already exists.
Result Code: E_INVALIDARG (0x80070057)
Component: VirtualBox
Interface: IVirtualBox {c28be65f-1a8f-43b4-81f1-eb60cb516e66}

Use the internalcommands parameter with VBoxManage.exe to set a change the hard drive’s UUID:

C:Program FilesOracleVirtualBox>VBoxManage.exe internalcommands
Oracle VM VirtualBox Command Line Management Interface Version 4.1.16
(C) 2005-2012 Oracle Corporation
All rights reserved.

Usage: VBoxManage internalcommands <command> [command arguments]

Commands:

  loadsyms <vmname>|<uuid> <symfile> [delta] [module] [module address]
      This will instruct DBGF to load the given symbolfile
      during initialization.

  unloadsyms <vmname>|<uuid> <symfile>
      Removes <symfile> from the list of symbol files that
      should be loaded during DBF initialization.

  sethduuid <filepath> [<uuid>]
       Assigns a new UUID to the given image file. This way, multiple copies
       of a container can be registered.

  sethdparentuuid <filepath> <uuid>
       Assigns a new parent UUID to the given image file.

  dumphdinfo <filepath>
       Prints information about the image at the given location.

  listpartitions -rawdisk <diskname>
       Lists all partitions on <diskname>.

  createrawvmdk -filename <filename> -rawdisk <diskname>
                [-partitions <list of partition numbers> [-mbr <filename>] ]
                [-relative]
       Creates a new VMDK image which gives access to an entite host disk (if
       the parameter -partitions is not specified) or some partitions of a
       host disk. If access to individual partitions is granted, then the
       parameter -mbr can be used to specify an alternative MBR to be used
       (the partitioning information in the MBR file is ignored).
       The diskname is on Linux e.g. /dev/sda, and on Windows e.g.
       \.PhysicalDrive0).
       On Linux or FreeBSD host the parameter -relative causes a VMDK file to
       be created which refers to individual partitions instead to the entire
       disk.
       The necessary partition numbers can be queried with
         VBoxManage internalcommands listpartitions

  renamevmdk -from <filename> -to <filename>
       Renames an existing VMDK image, including the base file and all its exten
ts.

  converttoraw [-format <fileformat>] <filename> <outputfile>
       Convert image to raw, writing to file.

  converthd [-srcformat VDI|VMDK|VHD|RAW]
            [-dstformat VDI|VMDK|VHD|RAW]
            <inputfile> <outputfile>
       converts hard disk images between formats

  modinstall
       Installs the necessary driver for the host OS

  moduninstall
       Deinstalls the driver

  debuglog <vmname>|<uuid> [--enable|--disable] [--flags todo]
           [--groups todo] [--destinations todo]
       Controls debug logging.

  passwordhash <passsword>
       Generates a password hash.

  gueststats <vmname>|<uuid> [--interval <seconds>]
       Obtains and prints internal guest statistics.
       Sets the update interval if specified.

WARNING: This is a development tool and shall only be used to analyse
         problems. It is completely unsupported and will change in
         incompatible ways without warning.

Syntax error: Command missing

C:Program FilesOracleVirtualBox>

C:Program FilesOracleVirtualBox>VBoxManage.exe internalcommands sethduuid J:
VirtualBoxPatch11iPatch11i1.vdi
UUID changed to: d716cc7b-749a-4e0d-83b5-c0abc379f18a

C:Program FilesOracleVirtualBox>VBoxManage.exe internalcommands sethduuid J:
VirtualBoxPatch11iPatch11i2.vdi
UUID changed to: 280d9129-f190-4422-82e1-083f6f750814

C:Program FilesOracleVirtualBox>VBoxManage.exe internalcommands sethduuid J:
VirtualBoxPatch11iPatch11i3.vdi
UUID changed to: e577df83-d2e5-49e9-9a2c-18a29dd8fc84

C:Program FilesOracleVirtualBox>VBoxManage.exe internalcommands sethduuid J:
VirtualBoxPatch11iPatch11i4.vdi
UUID changed to: bf722d45-9fdd-4a9f-a9ec-f646f6156c3d


 

 

 

 

 

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

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

SQL Developer Vendor Code 17002

Problem:

When connect to an 11i E-Business Suite database using SQL Developer, the following error appears:

An error was encountered performing the requested operation:

IO Error: Connection reset

Vendor code 17002

Sometimes, the error reads:

An error was encountered performing the requested operation:

IO Error: Got minus one from a read call

Vendor code 17002

Issuing the tnsping command against the instance returns the following:

C:>tnsping vis3

TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 02-MAY-2012 10:21:29

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
C:OracleDevSuiteHomenetworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=oel5vis3.localdomain)
(PORT=1524)) (CONNECT_DATA= (SID=VIS3)))
TNS-12537: TNS:connection closed

Pinging the instance on the database node completed successfully.

The problem started occurring after applying ATG RUP7.

Solution:

AutConfig was run as part of applying ATG RUP 7 patches. This regenerated the sqlnet.ora, which included the following two lines:

tcp.validnode_checking = yes
tcp.invited_nodes=(OEL5VIS3.localdomain)

This blocked all SQL connections to the server. Since this instance is a test environment, the above lines in sqlnet.ora were commented off and the listener bounced.

[amazon asin=1847196268&template=iframe image&chan=default]     [amazon asin=0071484744&template=iframe image&chan=default]    [amazon asin=0137142838&template=iframe image&chan=default]

rm: cannot lstat file: Input/output error

Problem:

While attempting to remove a file on Linux, the message ‘rm: cannot lstat file: Input/output error’ appears:

[applmgr@oel5vis3 applmgr]$ cd /u01/VIS3/oracle/vis3db/9.2.0/oem_webstage/oracle/sysman/vbo/vbos
[applmgr@oel5vis3 vbos]$ ls -ltr
total 16
?--------- ? ?       ?      ?            ? VbosLobStorage.class
?--------- ? ?       ?      ?            ? VbosLobSQLList.class
?--------- ? ?       ?      ?            ? VbosLobOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosDimensionOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosArrayTypeOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosClusterOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosDBLinkOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosIndexOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaObjectHelper.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaObjectOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaSourceOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaClassOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosLob.class
.
.
.
[applmgr@oel5vis3 vbos]$ rm VbosLobOperations.class 
rm: cannot remove `VbosLobOperations.class': Input/output error
[applmgr@oel5vis3 vbos]$ rm -f VbosLobOperations.class 
rm: cannot remove `VbosLobOperations.class': Input/output error
[applmgr@oel5vis3 vbos]$ touch VbosLobOperations.class
touch: cannot touch `VbosLobOperations.class': Input/output error

Solution:

Unmount partition with bad file and run fsck on partition (may need to exit Terminal window and open new Terminal window).

 

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

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]

RW-20003: Error: Unzip failed: unknown reason

Problem:

While installing a Vision instance of 11.5.10.2, the following errors appears:

RW-20003: Error: Unzip failed: unknown reason.
Check log file for details.

General solution:

Verify file owner and group settings for EBS staging area.
Redownload, restage installation media from DVD or E-Delivery.
Verify MD5 checksums for files downloaded from E-Delivery.

Solution (in this case):

/u00/Stage11i/oraApps/Disk4/appl/stage/fnd_WEB3.zip corrupt. Restage.

Read more »