view counter

SOA Feed

Oracle SOA Suite 10g and 11g resources, news, and support articles.

Why It’s All Up to AIA

That is the topic of Joshua Greenbaum’s recent blog post during OpenWorld, detailing the reasons why he feels AIA is so important to Oracle.

Did I get my sequence right?

Here is a little twister on Oracle sequence object.

Typically, when we invoke a nextval operation on a sequence object, the current value of the sequence is incremented by 1 and the incremented value is returned. Our assumption here is that this happens irrespective of when and where the nextval operation is invoked.

Turns out that we may be way wrong in our assumptions...

Let us say we have a sequence object named DUMMY_S and its current value is 1.

What would we expect to happen when we execute the following SQL statement?

Copying BOMs/Routings across organizations

For those of us who are mulling over the possibility of copying large sets of BOMs and Routings across inventory organizations, can consider using the following standard Oracle APIs:


iSupplier User Bulk Registration API


The following is the outline for developing a bulk API utility that cancreate/register/approve isupplier user accounts. The utility will also be able to assign responsibility access to supplier user accounts, attach securing attributes including supplier, supplier sites to the user accounts. The securing attributes can contain multiple supplier site information. This utility can be developed in PL/SQL and registered to run as a concurrent program in Oracle eBusiness Suite.


Six questions to analyze for SOA readiness

One of the AIA partners, Infosys, has published an article on their blog listing the six things a company must know if they are ready for SOA.

Look Ma! My Pseudo-Code uses XML!

Have we ever wondered if there is a better way to document design/program logic for a large scale application?

Typically we would consider using generic text based Pseudo-code techniques to lay out the flows. If the pseudo-code burgeons as time passes by, it becomes increasingly difficult to understand the flow from the myriad of statements that make up the pseudo-code. Indentation of statements can only help for small to medium scale designs. For large scale designs, it might be worthwhile to create or develop our own standards based XML language for documenting pseudo-code.

The World of SOA: Laundries, Legos, and Home Construction

As an architect explaining SOA concepts to developers of traditional enterprise applications, I encountered various analogies comparing the concepts of SOA to LegoTM blocks, which are actually considered by some experts as being

Schema Centralization Pattern

The SOA Design Patterns site (and book) has an interesting chapter on the topic of schema centralization.  The recommended solution is essentially the pattern used in AIA.

1. Establish your service inventory using a top-down business process model driven approach.

2. Identify the Enterprise Business Objects (EBO) and Enterprise Business Messages (EBM).

3. Create the EBO Schema canonical definitions using the industry standards.

Welcome to my blog!

Welcome to my blog!

Update: September 09, 2010

The goals of this blog as well as information about me are listed on the side bar, so I would like to take this opportunity to spell out the code of ethics for this blog, adapted from my colleague’s excellent blog.

Hangover of FND_CONCURRENT.wait_for_request

It is a well known fact that the following APIs are used in Oracle eBusiness Suite to control the submission of concurrent requests:

This API is used to submit the concurrent request and get the request id for the submission


view counter