Concurrent request error

| Oct 29, 2010
A concurrent request was running into an error. The following error was shown in the logfile of the request.APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.I noticed the $CUSTOM_TOP variable was not set, but after setting this

Upgrade stories : Bursting

The parameters of the concurrent "XML Publisher Report Bursting Program" have changed between 11i and R12. Oracle added a new parameter, before the previously defined 2 parameters.The new and hidden parameter is called "Dummy for Data Security", and is defaulted by "select xdo_cp_data_security_pkg.get_concurrent_request_ids from dual".

Oracle Technology Day – Milwaukee

Today I am participating in Oracle Technology Day in Brookfield, WI.  Brookfield is a suburb of Milwaukee and closer to my house than work so the commute was better than normal.  Those of you that participate in these regularly know that it is an opportunity for Oracle to buy us breakfast and lunch, and in return, they get an opportunity to tell us about their technology.  We also get an opportunity to network with several people from the area and find out what others are doing.  Meeting others from the are is the best part of these days.  The technology (more...)

CP8 for released

Just wanted to let you know that on October 5, 2010, Oracle has released CP8 for You will find it on MetaLink as patch number 9694503. When compared to CP7, 10 bugs have been fixed.

So far this cumulative patch has been released for the following platforms:
  • IBM AIX on Power Systems (64-bit)
  • Microsoft Windows 32-bit
  • Linux x86 (works for both 32 bit and 64 bit)
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on x86 (32-bit)
If you are upgrading to CP8 from any patch level prior to CP4 then JDBC patch patch for bug (more...)

Profit Magazine Article

I recently had the opportunity to answer APEX questions for Oracle's Profit magazine. You can read the interview online here. Hopefully this exposure will introduce Oracle Application Express (APEX) to a broader community.

Don’t guess, measure!

I’m watching a builder working on the roof of the office next door. This morning he hauled up a big batch of insulation material, and now he’s putting down the last insulation batt. He has none left over and he’s not missing any. He had exactly the right number. Why? (more...)

Virtualization of Application Servers and Database Servers

I've been pretty busy watching and listening to all the presentations from Oracle Open World and VM World to pick up trends, directions, best practices and insights.   From everything I am seeing, my time is being well spent on virtualizing database and application servers.  You can also read more about this at  .

Cell level write-back via PL/SQL

A topic of conversation that regularly comes up when I talk to customers and developers about the OLAP Option is write-back to OLAP cubes. The most frustrating of these conversations usually involves someone saying 'but... the OLAP Option doesn't support write-back'. This is not the case and never has been.


ruby-plsql-spec upgraded to use RSpec 2.0

Initial version of ruby-plsql-spec gem was using RSpec version 1.3. But recently RSpec 2.0 was released which API is not compatible with previous RSpec 1.x API and as a result plsql-spec utility was failing if just RSpec was upgraded to version 2.0.

Therefore I updated also ruby-plsql-spec to use latest RSpec 2.0 gem and released ruby-plsql-spec gem version 0.2.1. You can install the latest version with

gem install ruby-plsql-spec

Upgrade from previous version

If you previously already installed initial ruby-plsql-spec version 0.1.0 then you need to update your spec/spec_helper.rb file (more...)

Mon humeur du jour.

Suicide pill in full motion :


Since many folks asked about an ability to view posted events, here is the url to do so

Erlang formula’s programmed in PL/SQL

Since a long time I am busy using queuing formula’s to be able to calculate cpu queue’s and I/O queues. One of the big problems I was facing that the formula’s I like to use on big data sets with my GAPP analysis were only available in perl. For a long time I was using proximity functions to avoid the perl programmed Erlang-C formula and some other. Last weekend I just had the time to start programming the formula’s in PLSQL, just to have them easily accessible in my database. After finish programming the package I realized that the package (more...)

Do you see the light? Oracle database team does

After Oracle decided that SQL Developer Data Modeler should be a paid-for product, adoption naturally dropped to so close to zero you couldn’t measure it. I’ve asked around at several conferences and never managed to find a single person who paid for this product…

Just before Oracle OpenWorld, Oracle realized (more...)

After OOW, my laptop broke down – data rescue scenario

I just got back in the office from a 2 week conference + vacation (SFO,WAS,NY). Then I was finally back in shape to work and do the usual geek stuff again but suddenly my Neo laptop suddenly stopped working! (the one I mentioned here, but it’s now on Fedora)

It can’t even boot to BIOS, certainly a case worse than BSOD.

So after fiddling with the laptop and systematically ruling out other component failures (power cable,monitor,memory,HD), Yes it’s much like troubleshooting an Oracle database! … we decided to bring it to the service center.

But wait! it may (more...)

Incremental Refresh of Oracle Cubes

One of the more common questions I get is about how cubes are processed, in particular how and when Oracle cubes are processed incrementally. Here is a short summary of how the cube refresh process works, a few scenarios and some suggestions on being smart about solutions.

- The cube (more...)

12.1.2 to 12.1.3 upgrade on Solaris

| Oct 7, 2010
We have recently upgrade our instances to 12.1.3. Here is what we did.

1) patch 8626084
2) From Apps tier Source $INST_TOP/ora/10.1.3/sid_hostname.env file to set $ORACLE_HOME as 10.1.3 home.
3) cd /8626084/Disk1
4) ./runInstaller -invPtrLoc $ORACLE_HOME/oraInst.loc
5) On fourth screen it will ask for oc4jadmin password. Kindly put "oafm".
6) Stop opmn processes, keeping same 10.1.3 env.
$ORACLE_HOME/opmn/bin/opmnctl stopall
7) Unzip patch in 10.1.3 and 10.1.2 OH to have latest opatch version.
8) Run Autoconfig on both Apps nodes.

Finding XML Publisher Version in R12

| Oct 7, 2010
Its being long I have posted something. Got Stuck in major milestone in our project and 12.1.3 upgrade.

1) The following SQL statement will show which patches and thus with version of Oracle XML Publisher is installed on an Oracle E-Business Suite Release 12.0 and 12.1 environment:

SELECT DECODE (bug_number, '4440000', '5.6.3') PATCH, bug_number
FROM ad_bugs WHERE bug_number IN('4440000');
----- ------------------------------
5.6.3 4440000

2) The version of a specific Java Class has a one to one relationship with the currently installed version of Oracle XML Publisher. This method is suitable (more...)

China May Lead Patenting, How About Innovation?

Title is self explanatory. My following blog refers the stories..

Larry, Fusion Apps, and SOA Middleware Technology

At Oracle Open World 2010, Larry Ellison glowingly referred Oracle Fusion Apps (OFA) in his eagerly watched keynote as the largest engineering project of Oracle in the recent times. He covered some important aspects of the Oracle Fusion Apps. He said that it is the first ERP Application completely based (more...)

Resolving timeouts while using ejb beans for SOA invocation – deployment

If you are using AS11 BPEL's apis for deployment or invocations and facing time-outs, and the task really needs more time, then you may need to increase the ejb timeout.

1. Find ejb_ob_engine_wls.jar in your deployment.
2. Modify META-INF/weblogic-ejb-jar.xml,
3. Increase time-out
4. rejar and replace the original jar