Monthly Archives: February 2012

ORA-00604, ORA-01882 While Connecting With SQL Developer

Problem:

While trying to connect to an Oracle 9.2.0.3 database on EBS 11.5.9 (running on Red Hat Enterprise Linux AS release 4) using SQL Developer 3.0.04, the following message appears:

An error was encountered performing the requested operations:
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
OO604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement 
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack 
can be corrected, do so; otherwise contact Oracle Support
Vendor code 604

Solution:

Change the timezone variable in sqldeveloper.conf to a valid one for the database.

Read more »

Notifications Automatically Closing

Problem:

A preparer creates a purchase request and send it to the approver, who approves it. The preparer then receives a notification that the PR was approved, but the notification automatically disappears from the list after the browser is refreshed or when the user logs off.

Solution:

The AutoClose_FYI parameter must be changed from ‘Y’ to ‘N’ in Notification Mailer.

Then the Notification Mailer must be stopped and started for the change to take effect.

Outbound Server Unable to Make a Network Connection

Problem:

The Notification Mailer shows the following error:

Navigation: Oracle Application Manager > Site Map > Administration tab >
Notification Mailer (under Workflow)
Click: Workflow Notification Mailer

Component Details: Workflow Notification Mailer: TEST3 shows an error in Status
Information:

This automatic Service Component has been restarted the maximum of 10 times after
stopping with error. Thus, it has been system deactivated ->
oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component;
performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation
failed for the following parameters -> {OUTBOUND_SERVER=Unable to make a network
connection.}.

Solution:

Change Outbound Server from EBS application tier server to mail server. The Outbound Server is usually automatically reset as part of the cloning process.

Change OUTBOUND_SERVER from oratestapps.domainname to 10.x.x.x.

Read more »

Oracle Installer Not Detecting Packages

Problem:

While installing 11gR2 64-bit version on Oracle Linux 5.7 64-bit, the installer states that certain RPMs (libaio-devel-0.3.106 and unixODBC-devel-2.2.11)  are missing. After installing the missing RPMs using the ‘rpm -Uvh’ command, the installer still does not detect the newly applied RPMs.

Solution:

Exit the 11gR2 installer, apply the RPMs and then rerun the installer.

Requests Remain In ‘Posting’ Distribution Status

Problem:

When a new request is submitted in PeopleSoft (Main Menu > PeopleTools > Process Scheduler > System Process Requests), the request’s ‘Run Status’ completes with status ‘Success’, but the ‘Distribution Status’ remains at ‘Posting’.

Solution:

Ensure that the Process Scheduler Report Node and Distribution Details for the Server are correctly set up.

Read more »