1
Nov

Oracle E-Business Suite Forms not opening in Internet Explorer

Issue:


After logging in and clicking on any form, java installation window opens up even though the correct java version is installed on client PC’s.
This issue is seen on all client machines.

Issue occurs for all EBS Users who are using Internet Explorer.

Cause:

Classid is not set properly in $FORMS_WEB_CONFIG_FILE.
EBS looks for classid to launch the form.

Download Java

Java version already installed
Read more...

23
Aug

Error on libdb Library Starting Oracle EBS Application Services on Linux Platforms

Error :

While starting the application services, Apache services do not start.

Error in the log file:
/dap01/appldev/EBSDEV/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb-4.3.so: cannot open shared object file: No such file or directory

Cause:

This is caused by having an older Oracle HTTP Server installed on a newer Operating System. For the OPatch issue, Perl is expecting to find the /usr/lib/libdb-3.3.so library, but it is missing.
The following command locates a higher version of the library (for example, /usr/lib/libdb-4.1.so)

/libdb ls -al /usr/lib *.so
 
Note that the error can be a newer library, depending which is found and used from the operating system. (e.g., libdb-4.2.so, libdb-4.3.so, libdb-4.4.so, etc).

The correct libdb filename to use should depend on output of ldd httpd, for example:


cd $ORACLE_HOME/Apache/Apache/bin
ldd httpd | grep libdb
libdb.so.2 => /usr/lib/libdb.so.2 (0x00868000)

•In this case, libdb.so.2 is expected
•In this case, having libdb-3.3.so will not help

Read more...

2
Jul

ORA-04061: existing state of has been invalidated

Error:-


The changes were not applied because ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "APPS.HR_PERSON_ABSENCE_SWI" has been invalidated ORA-04065: not executed, altered or dropped package body "APPS.HR_PERSON_ABSENCE_SWI" ORA-06508: PL/SQL: could not find program unit being called: "APPS.HR_PERSON_ABSENCE_SWI"

Issue:-


The leave request approval works fine from the notification list but not from within the email and gives an error that the package is invalid.
Read more...

1
May

ORACLE error 20100 in FDPSTP

Error :

ORACLE error 20100 in FDPSTP
FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.

Action:

Check that the directory is a valid directory with wri06-APR-2016 14:48:29

Cause:

The concurrent program was unable to write to the specified temporary file because the virtual path assigned to the APPLPTMP environment variable is not referenced in the UTL_FILE_DIR
Read more...

11
Apr

Error on login page of Oracle E-Business Suite

Error:

Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.

ORA-00257: archiver error. Connect internal only, until freed

Solution:

Check Flash Recovery Area usage:

SELECT
ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,
ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,
ROUND((A.SPACE_RECLAIMABLE / 1024 / 1024 / 1024), 2) AS FLASH_RECLAIMABLE_GB,
SUM(B.PERCENT_SPACE_USED) AS PERCENT_OF_SPACE_USED
FROM
V$RECOVERY_FILE_DEST A,
V$FLASH_RECOVERY_AREA_USAGE B
GROUP BY
SPACE_LIMIT,
SPACE_USED ,
SPACE_RECLAIMABLE;
Read more...

Back to Top