Skip navigation.

Feed aggregator

ATG Live Webcast Replay Available: EBS 12 OAF Rich UI Enhancements

Steven Chan - Thu, 2011-02-10 11:50
The E-Business Suite Applications Technology Group is thrilled at the response to our first ATG Live Webcast. Following up to that event, I am pleased to provide the links to replay the event and download the presentation file. The Latest E-Business Suite R12.x OA Framework Rich User Interface Enhancements Original Recording Date: Thursday, January 27, 2011 Replay Link (Note: You will need an account to view the replay.) Presentation Download Link Bill Sawyer
Categories: APPS Blogs

New Whitepaper: Upgrading EBS 11i Forms + OA Framework Personalizations to EBS 12

Steven Chan - Wed, 2011-02-09 12:25
Personalizations are -- and have always been -- one of the safest and most upgradable ways to "customize" your Oracle E-Business Suite screens, both for Oracle Forms-based screens and for Oracle Application Framework-based pages. However, the upgrade from Release 11i to Release 12.1 spans many years of EBS evolution, during which time Oracle has actively been building many new features and modules. A lot has changed in Oracle E-Business Suite that may affect upgrading your personalizations from 11i to 12.1. We have published a new note on My Oracle Support that discusses ways to evaluate your existing personalizations: * Upgrading Form Personalizations and OA Framework Personalizations from Oracle E-Business Suite Release 11i to 12.1 (Note 1292611.1) Sara Woodhull
Categories: APPS Blogs

Safari 5 certified with EBS Release 12 on Apple Mac OS X 10.5 and 10.6

Steven Chan - Sun, 2011-02-06 15:52
Oracle E-Business Suite Release 12 (12.0.4 or higher, and 12.1.2 or higher) is now certified with the Safari 5 browser on the following Apple Mac OS X desktop configurations: Mac OS X 10.5 ("Leopard") * Mac OS X 10.5 ("Leopard" version 10.5.6 or higher) along with any other security and Java updates listed in the 'Software Update' program on the Mac * Safari version 5 (5.0.2 or higher) * Apple Java/JRE plugin 5 (1.5.0_13 or higher) Mac OS X 10.6 ("Snow Leopard") * Mac OS X 10.6 ("Snow Leopard" version 10.6.3 or higher) along with any other security and Java updates listed in the 'Software Update' program on the Mac. * Safari version 5 (5.0.2 or higher) * Apple Java/JRE plugin 6 (1.6.0_20 or higher) John Abraham
Categories: APPS Blogs

Oracle Discoverer ( certified with EBS R12 on IBM: Linux on System z

Steven Chan - Mon, 2011-01-31 12:50
Oracle Discoverer 10g ( is now certified with E-Business Suite Release 12 (12.1.2 or higher) on the IBM: Linux on System z platform. With this certification, Oracle Application Server 10g ( is now fully certified with E-Business Suite on Linux on System z. Specifically, the following OracleAS components are now certified for external integration with E-Business Suite R12 environments: * Single Sign-On * Oracle Internet Directory * Discoverer * Portal (as included in OracleAS * Web Cache John Abraham
Categories: APPS Blogs

Database 10gR2 Certified with EBS on 14 Additional Platforms

Steven Chan - Tue, 2011-01-25 18:45
As a follow-on to the original certification announcement (on July 2, 2010), Oracle Database 10gR2 Patch Set is certified with Oracle E-Business Suite Release 11i and R12 on the following additional platforms: Platforms certified for 11i (11.5.10 (RUP 6) and higher) * IBM AIX on Power Systems (64-bit) (5.3, 6.1) * Oracle Solaris on SPARC (64-bit) (8, 9, 10) * Oracle Solaris on x86-64 (64-bit) (10) (See Note 1) Platforms certified for R12 (12.0.4 and higher) and 12.1 (12.1.1 and higher): * HP-UX Itanium (11.23, 11.31) * IBM AIX on Power Systems (64-bit) (5.3, 6.1) * Oracle Solaris on SPARC (64-bit) (8, 9, 10) * Oracle Solaris on x86-64 (64-bit) (10) (See Note 1) John Abraham
Categories: APPS Blogs

Reminder: ATG Live Webcast Jan. 27th - EBS 12 OAF Rich UI Enhancements

Steven Chan - Tue, 2011-01-25 02:05
Reminder: the E-Business Suite Applications Technology Group (ATG) is presenting our first ATG Live Webcast this week. The one-hour event will be webcast live with a dial-in access for Q&A with the Applications Technology Group (ATG) Development experts presenting the event. The basic information for the event is as follows: The Latest E-Business Suite R12.x OA Framework Rich User Interface Enhancements Date: Thursday, January 27, 2011 Time: 8:00 AM - 9:00 AM Pacific Standard Time Presenters: * Prabodh Ambale, Senior Manager, ATG Development * Gustavo Jimenez, Development Manager, ATG Development Bill Sawyer
Categories: APPS Blogs

In-Depth: Thoughts on Testing from a Battle-Scarred Support Engineer

Steven Chan - Mon, 2011-01-24 15:05
"The more I practice, the luckier I seem to get." "If you think safety is expensive, just try having an accident." The two quotes above I think pretty accurately sum up the importance of preparation and planning. The first has been attributed to various professional golfers over the years and suggests luck is never accidental. If things work, they work for a reason and that reason is usually because of good preparation, not good luck. The second quote has been attributed to various airline industry executives. Here the message is that however much time, and inevitably money, that you spend making sure your planes do not crash, it will cost you considerably more if one of them does. The real message is of course that planning and preparation pay off in the long term and, in the context of your Oracle Applications upgrade, you can conclude that successful upgrades are the result of good testing, not good fortune. This article is just a few thoughts from a battle-scarred Support Engineer on why good testing is crucial to the success of your system and why it is important for you to thoroughly test any patches, upgrades or migrations before carrying out the work on your production environment. The great majority of the work that you do in any project will be testing. Underestimate it at your peril. Testing is not simply a necessary evil which has to be endured before the inevitable, white-knuckle ride of the production upgrade. Testing is not where you should be cutting corners. Testing is where you should be going into every conceivable corner you can find and looking for something that might, without warning, jump out of the shadows and derail your production upgrade. Nick Quarmby
Categories: APPS Blogs

Upgrading EBS 12 to DB 11g with Physical Standby Enabled

Steven Chan - Fri, 2011-01-21 17:08
It's possible to use Oracle Data Guard to create physical standby databases for disaster recovery. E-Business Suite users can configure their environments with the latest version of Oracle Data Guard 11g by following the documents linked in this article: * Business Continuity for EBS Using Oracle 11g Physical Standby DB When upgrading a database to a new release, you can upgrade the Data Guard Physical Standby database inline to minimize the downtime. To achieve this in an EBS 12 environment, additional manual configuration steps are needed on both the primary and standby systems. These manual steps allow redo to be shipped from the primary and applied on the standby during the upgrade. Sreelatha Doma
Categories: APPS Blogs

Reminder: Error Correction Support for DB 10gR2 Ends April 30, 2011

Steven Chan - Thu, 2011-01-20 14:17
Experienced Apps DBAs know that they need to monitor database support windows for their E-Business Suite environments. For an in-depth discussion about how database support policies affect E-Business Suite users, see: * On Database Patching and Support: A Primer for E-Business Suite Users An important deadline is approaching if you're still running any E-Business Suite release on the 10gR2 database. New 10gR2 patches produced after April 30, 2011 will require No new patches will be produced for after that date. Steven Chan
Categories: APPS Blogs

E-Business Suite Release 12 Certified With Microsoft Windows Server 2008 R2 (Windows x64)

Steven Chan - Wed, 2011-01-19 17:57
I am pleased to announce that Oracle E-Business Suite Release 12 (12.1.1 or higher) is now certified with Microsoft Windows x64 (64-bit) on both the application and database tiers through a certified migration of an existing Release 12 installation. Microsoft Windows Server 2008 R2 is a Windows x64 (64-bit) only operating system and is the latest Windows server version. John Abraham
Categories: APPS Blogs

Critical Patch Update for January 2011 Now Available

Steven Chan - Tue, 2011-01-18 11:35
The Critical Patch Update (CPU) for January 2011 was released on January 18, 2011. Oracle strongly recommends applying the patches as soon as possible. Steven Chan
Categories: APPS Blogs

Top 10 Reasons to Develop in a VM

Jeff Kemp - Mon, 2010-08-30 01:00
The cost of providing Virtual Machines to all your developers can be quite high, especially in terms of initially setting it all up (e.g. a typical developer may require two VMs running concurrently, one for the database server, one for the app server; their desktops will require enough grunt to run these while they also [...]

Generate DML/DDL/QUERY from SQL – the easy way

Jeff Kemp - Wed, 2010-08-25 21:00
This is a comment on’s article “Generate DML/DDL/QUERY from SQL” – comments are not enabled on their blog so here’s my addendum. The following query is offered as a means of generating a script to ONLINE all datafiles in a database: select 'ALTER DATABASE DATAFILE '''|| name || ''' online ;' from v$datafile; I [...]

InSync10 Day 2

Jeff Kemp - Wed, 2010-08-18 08:00
Another good day in Melbourne. Heard Richard Foote talk about Indexing New Features in Oracle 11g release 1 and 2. One thing he demonstrated was the creation of an index on only part of a table – normally I’d use a function-based index for this sort of thing, but his technique results in an index [...]

Never satisfied

Jeff Kemp - Wed, 2010-08-18 03:00
So I followed the great advice here to use the new COLLECT function in Oracle 10g to solve the common string-aggregation-in-SQL problem. I chose this solution over the others because it sorts the results as well, which was a user requirement. This is because the COLLECT function optionally takes an ORDER BY clause – even [...]

InSync10 Day 1

Jeff Kemp - Mon, 2010-08-16 05:00
After a scrumptious breakfast at the Armoury I headed in what I believed was the general direction of the Melbourne Convention Centre – after making a wrong turn I eventually spotted a footbridge over the river that rung a bell from my GoogleEarthing; after taking some photos I was finally at InSync10. The first session [...]

Editing Oracle Reports

Jeff Kemp - Wed, 2010-08-11 01:00
If you’re like me, the above picture will probably have given you a frisson of dread. Just a little. The example here is not a very complicated report, just a few repeating groups based on quite a nice data model. What catches me every time, however, is a few little apparent quirks in Oracle Reports [...]

Directory File List in PL/SQL

Jeff Kemp - Tue, 2010-08-10 01:00
UTL_FILE, unfortunately, does not allow you to query the contents of a directory. One option is to create a java routine. Note: this is not my code – a colleague sent the basics to me and I’ve just modified it somewhat to suit my purpose. CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "DirectoryLister" AS [...]

Purge all Recyclebins without SYSDBA

Jeff Kemp - Mon, 2010-08-09 01:00
Want to purge all the recyclebins for all users in your database? Can’t (or don’t want to) log in as each user individually to run this, one by one: PURGE RECYCLEBIN You could log in as SYSDBA and run: PURGE DBA_RECYCLEBIN But, what if you don’t have SYSDBA access? (Yes, this has happened to me, with [...]

Forms Library: PKG_DEBUG

Jeff Kemp - Fri, 2010-08-06 01:00
This is just a post to document a standard utility functions that I like to create in a Oracle Forms library, if equivalents are not already available. Suggestions or critiques are welcome. “No warranty is express or implied about the suitability of this code for any purpose.” This package could do with some improvements: use [...]