Workflow Mailer Notification not sending out mails

Today Amanda pinged me about an issue with Workflow Notification Mailer in an R12.1.3 instance.  Mails were not going out.  I checked the SMTP with commandline:

telnet 25
Subject: Test mail from smtp commandline of

The mail was going out fine.  So there was no issue on the unix Sendmail side. I suggested that we check the configuration inside Apps.  A search on revealed this article:

What to Review When Notifications are not Emailed (Outbound Processing)? [ID (more...)

ORA-06512: at "APPS.FND_CORE_LOG", line 318

Shoaib pinged me today. He was getting this error duing AutoConfig on DB node:


ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_CORE_LOG", line 318
ORA-06512: at "APPS.FND_CORE_LOG", line 62
ORA-06512: at "APPS.FND_CORE_LOG", line 456
ORA-06512: at "APPS.FND_PROFILE", line 110
ORA-06512: at "APPS.ADX_PRF_PKG", line 203
ORA-06512: at line 7

A search on My Oracle Support revealed R12: ORA-06502: PL/SQL: numeric or value error trying to update table fnd_profile_option_values [ID 1501822.1]

However the error described was similar, but not same:

ORA-06502: PL/SQL: numeric or (more...)

java.lang.IllegalArgumentException: Illegal argument for colorScheme applet parameter

Today Jayabharath Velugoti pinged me, about forms not launching in an 11i instance. When I tried reproducing the issue, I go this in my laptop java console:

 Following Exception occured: java.lang.IllegalArgumentException: Illegal argument for colorScheme applet parameter

java.lang.IllegalArgumentException: Illegal argument for colorScheme applet parameter
at oracle.forms.engine.Main.initDesktop(Unknown Source)
at oracle.forms.engine.Main.start(Unknown Source)
at sun.plugin2.applet.Plugin2Manager$ Source)
at Source)

A search on revealed this article: Opening Any Form Applications Gives: Illegal Argument For Color Scheme Applet Parameter. [ID 858367.1]

However (more...)

Query for CPU patches

Here's my updated query to identify the CPU patches (April 2011 - October 2012) applied on your 11i or R12 instance:

column BUG format a8;

column PATCH format a60;
set linesize 100;
set pagesize 200;

select b.bug_number BUG, b.LAST_UPDATE_DATE LDATE, decode(bug_number,
14321237, 'Oct 2012 CPU Patch for R12.1 + ATG_PF.B.Delta3',
14321239, 'Oct 2012 CPU Patch for R12.0.6',
14321240, 'Oct 2012 CPU Patch for 11i+RUP7',
14321241, 'Oct 2012 CPU Patch for 11i+RUP6',
13979374, 'July 2012 CPU patch for 11i+RUP7',
13979377, 'July 2012 CPU patch for 11i+RUP6',
13979372, 'July 2012 CPU patch for R12.1+ATG_PF.B. (more...)

No application machine is available to service any funcationality in DBA domain

After a recent clone of OTM loosely based on method described in, when we brought up the services, the following message appeared on accessing the OTM URL:

Error found handling the request.
No application machine is available to service any funcationality in DBA domain.

glog.exception.log was showing this error:

2012-06-28 13:36:25.728 0       Error   Exception       Server t3:// is not responding
  3:09 PM
2012-06-28 13:36:53.804 0       Error   Exception       Could not notify APPSERVER2 of APPSERVER2 activation
2012-06-28 13:39:07.491 306049  Error   Exception       cause.QueryFoundNoRecords
  3:09 PM

After going through (more...)

File too large zip error: Output file write failure

Recently while zipping a few directories for a clone, I got this error when the file size became greater than 2 GB.

File too large

zip error: Output file write failure (write error on zip file)

I tested the file system's ability to create files greater than 2 GB by creating a dummy 3GB file:

dd if=/dev/zero of=3gb-file bs=1024k count=3000

The 3 GB file got created without issues.

Then I checked the zip version.

$ zip -v
Copyright (c) 1990-2006 Info-ZIP - Type 'zip "-L"' for software license.
This is Zip 2.32 (June 19th 2006), by Info-ZIP.
Currently maintained (more...)

What languages and currencies are enabled in EBS

Raghava asked me about the languages and currencies being used in a new instance which has gone live. For languages we have this query:

select language_code
from fnd_languages
where installed_flag='I'

For currencies, I told him that in EBS all currencies are enabled. I executed the following query:

select CURRENCY_CODE,symbol
from apps.fnd_currencies
where enabled_flag='Y'

It returned 71 rows.

Total rows in fnd_currencies was 249.

However, I thought of a more logical way of getting this data. That would be to query transaction tables. Which transaction table to query here ? I queried dba_segments for the largest objects:

select object_name,bytes
from dba_segments