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