12.2.4 Online Patching Downtime Mode

Online Patching Downtime Mode

There is new, not advertised, "hidden" feature in the new 12.2.4 AD pack, what is an admission that current online patching mode is not the best not the fastest way to apply patches on a system.
This new feature is the "downtime mode" feature for patching the run(!) edition directly, just like before 12.2 system. The only requirement is that you should shutdown the whole application tier.

Citing from the document:

"Online Patching Downtime Mode New Feature in R12.AD.C.Delta.5 and R12.TXK.C.Delta.5

This new feature helps optimizing the process of upgrading to Oracle E-Business Suite 12.2. When applying Oracle E-Business Suite patches in this mode, adop will first confirm that the application tier services are down, and will then proceed to apply the patch to the run edition of the Oracle E-Business Suite database and file system.

Downtime mode patching does not use an online patching cycle. The process of applying a patch in downtime mode completes more quickly than in online mode, but at the cost of increased system downtime."

Enough interesting, isn't it?

Search for "downtime mode" phrase here:

http://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm

Oracle ADF Essentials on GlassFish 3.1 with EBS datasource

Hi All!

Today I will give you a full guide to install and configure a workable ADF Essentials installation based on a GlassFish 3.1 application server and I will configure an Oracle EBS datasource.

Main steps:

1. GlassFish server installation and base configuration
2. ADF Essentials runtime installation
3. Oracle EBS datasource configuration

Loading files as attachments into Ora EBS with ODI

Loading files as attachments into Oracle EBS with ODI

At the end of last year I got a new task to work out a solution how to load files into Oracle EBS as a PO attachment. What was the small specification? To load PDF files - containing the PO number is their's name - into Oracle EBS database as an attachment for that PO headers the belong to the PO number. It was a small but quite interesting ODI and EBS development task.

What I needed to do my job? Or what I got for working out the solution

• an Oracle EBS 11i
• an Oracle Data Integrator (ODI 11.1..1.5)
• an ODI agent on that server where the Oracle EBS database installed
• a file directory on the same database node - this will contain the to be imported PDF files 
• a custom EBS interface schema for database connection

I have used these 2 references for solving the problem:

Oracle Data Integrator 11g Cookbook Chapter 8

http://oraclemaniac.com/2012/01/07/attach-concurrent-program-output-to-the-apps-transaction/

Let's go into the details

12.2.3 EBS version is available

The 12.2.3 EBS version has been publicated.
Now it is downloadble from support.oracle.com as 17020683 patch.

I am goind to download and apply it soon. Then of course I report my experience. I am quite curious about this new look and feel the skyros.

Newly publicated features of Oracle EBS 12.2.3 version

The 12.2.2 EBS version is quite new, but the Release Content Documents was updated with some new features what will be available in 12.2.3 version.
Check the 1302189.1 note for the updated RCD PDF files.

Some examples, it's not all of them, I have collected some interesting point for me:

OAF

• New Skyros Skin
• Rich Table Interactions
• Dynamic Views

The new Skyros skin could be a big changes in the look and feel if the following cite is really true:

Some thoughts about how useful could be a migration strategy document.

Do you find yourself in such situation, that you feel at the end phase of your project: "It would have good if we found the solution earlier" , "would have gone much more smoothly", don't you?

I have begin to collect some useful strategy documents I have used at my projects. Check my other blog post. This is the first one, the migration strategy document. Hope you like it.
http://architecttar.blogspot.com/2013/11/useful-strategy-documents-has-to-made.html

Oracle EBS 12.2.2 complete installation diary

12.2.2 installation diary

The new EBS 12.2.2 installation is not so simple as an old EBS, it contains many steps from many notes and based on a partially complete installation media.

In this blog post I will show you my latest 12.2.2 installation, through a "complete" diary.
So what will the post contains?

• all required installation documents and notes
• installation media files - complete list
• installation steps
• detected problems