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...
User Equivalence Configuration
There are two nodes in a cluster ebsdb01.dbaarena.com, ebsdb02.dbaarena.com
cd $ORACLE_HOME/oui/prov/resources/scripts
[oraprod@ebsdb01 scripts]$ ls -ltr
total 100
-rwxr-x--- 1 oraprod oinstall 1394 Jul 20 2006 validatePaths
-rwxr-x--- 1 oraprod oinstall 6983 Jul 20 2006 ouiSetup
-rwxr-x--- 1 oraprod oinstall 35064 Dec 11 2006 sshUserSetupNT.sh
-rwxr-x--- 1 oraprod oinstall 16520 Mar 31 2009 sshConnectivity.sh
-rwxr-x--- 1 oraprod oinstall 32343 Dec 16 2009 sshUserSetup.sh
./sshUserSetup.sh -user
Read more...
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...
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;
Workflow Mailer Validation Error
Symptoms:
While configuring the Workflow Notification Mailer, a "Validation Error" is displayed.
