Oracle VM Consulting
view counter

SOA Feed

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

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


Enterprise mashup solution from Big Blue

IBM recently announced the availability of it's enterprise mashup solution, IBM Mashup Center, which will be coming to the market in 2008. For more details on IBM Mashup Center , you can visit the homepage - and interesting Beta launching video in Youtube -

Email XML Publisher generated output

How do we identify the output generated by xml publisher via a concurrent request in oracle ebusiness suite and email it to users?

In order to implement this functionality, we would have to know the following:

1. The concurrent request id of the program that is tied to an xml publisher defined layout
2. The path and name of the output file that is generated by the output post processor for the concurrent request
3. An email utility that can mail the generated output as an attachment

view counter