Category Archives: Windows - Page 6

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3395507964_562

Posted by on July 19, 2012 1 comment

Problem:

Checked alert log file  and saw the following errors:

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition 
WRH$_ACTIVE_3395507964_562 by 128 in                 tablespace SYSAUX 
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge of WR snapshots (546) and older
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition 
WRH$_ACTIVE_3395507964_562 by 128 in                 tablespace SYSAUX 
MMON Flush encountered SYSAUX out of space error(1688).
MMON (emergency) purge - nothing to purge, pgsid=0.

Solution:

Add a new datafile to the SYSAUX tablespace.

Read more »

Sharing Violation While Backing Up Oracle on Windows

Posted by on July 18, 2012 No comments

Problem:

While backing up DEV1 instance on Windows 2008, the following error appears:

C:oracleDEV1instappsDEV1_ittl-hrmstestappltmpOFF446.tmp
Sharing violation

Solution:

Ensure that the Oracle processes are stopped in Windows Services.

It appears that there are still (orphan) database processes running. Right click the Taskbar and open Task Manager. Select the Processes tab. From the View menu, click Select columns. In Select Process Page Columns, scroll down the list and check Command Line. Delete any processes that start with C:oracleDEV1.

Help target US/FND/@OAM_WF_GSC_MLR_DETAILS could not be found

Posted by on July 16, 2012 No comments

Problem:

On the page:
Applications System:DEV1  >   Workflow  >   Service Components  > Component Details: Workflow Notification Mailer: DEV1

after clicking the Help link, the following error appears:

404 NOT FOUND 

An error occurred while retrieving Oracle Applications Help information. 

Help target US/FND/@OAM_WF_GSC_MLR_DETAILS could not be found.

Solution:

Bug in EBS help files. Instead, manually navigate to help file:

Help Contents > Applied Technology > Oracle Workflow > Administrator’s Guide > Oracle Workflow Manager

 

Reference:

Help Files in OAM Error Help Target US/FND/@OAM_WF_GSC_MLR_DETAILS Could Not Be Found [ID 1074282.1]

ERROR – RDA execution failed (9009)

Posted by on July 12, 2012 No comments

Problem:

When running RDA from Application Diagnostics, the following error appears in the output report:

ERROR - RDA execution failed (9009)
ACTION - Review the output of the RDA command (shown below) to determine the cause 
of this error

Solution:

In APPL_TOP, create APPSORA.cmd from APPSSID_hostname.cmd.

Read more »

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]

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

 

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

Posted by on June 22, 2012 No comments

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

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