Contributions by Angela Golla, Infogram Contributor

The May / June issue of Oracle Magazine is now available. It has articles on Oracle's acquisition of Sun and what it means for our customers, cloud computing and more. Check it out at: http://www.oracle.com/technology/oramag/oracle/10-may/index.html

APEX, EBS, RDBMS, Security

APEX

The Apex Evangelists run an APEX aggregator that is definitely worth putting in your RSS list: APEX Blog Aggregator

EBS

This week at the Oracle E-Business Suite Technology blog:

E-Business Suite Technology Stack Roadmap (April 2010) Now Available

11gR2 DB 11.2.0.1 Certified with E-Business Suite on Solaris 10 (x86-64)

Gareth Roberts has a very handy technique for EBS over at the In-Depth Apps blog: Environment Variables from database table - Oracle E-Business Suite.

RDBMS

Tom Kyte has a good in-depth posting estimated cardinalities over at his blog: Something new I learned about estimated cardinalities...

Security

Olaf Heimburger brings us a valuable posting on Using Oracle Proxy Authentication with JPA (EclipseLink-Style) on his blog.

Hyperion, JDEdwards, Book Reviews, PL/SQL

Hyperion

The new 11.1.2 release of EPM is all the buzz on the blogs.

The Look Smarter Than You Are blog discusses fome of the new standalong applications that come with EPM 11.1.2: Oracle EPM 11.1.2 - New Financial Close Applications.

Tim Tow has some valuable tips in this posting: New 11.1.2 Information.

And a couple of items from Essbase Labs:

Smart View 11.1.2 – Ribbons

and

Smart View 11.1.2 – Connections

JD Edwards

A few notes and rumors on the product roadmap from Collaborate, with a prediction of more solid into in the Fall at OpenWorld over at the JD Edwards Advisor blog: JD Edwards EnterpriseOne Roadmap

Book Reviews

The blog of the Amis Technology corner has a lot of good material of late, including two book reviews:

A detailed review of an intermediate advanced book: Oracle Fusion Developer Guide

and one on a very hands-on approach to SOA Suite:
Getting Started With Oracle SOA Suite 11g R1: A Hands-On Tutorial

PL/SQL

We've mentioned the PL/SQL Challenge site here before, and it's worth mentioning again, as Eddie Awad does over at his blog: What Error

OakTable, Piping, EBS, WLS, PeopleSoft, Siebel, Hyperion, Security

Oak Table Net New Website

There's a new website for the OakTable.net, a group of mysterious Oracle performance gurus who meet secretly at an oaken table in Denmark by the light of the moon (well, not secretly, really, also not usually soberly; and they don't actually wait for the moon to appear to pop open a beer, but they're still mysterious for all that). Go have a look. These folks are the best and brightest in Oracle performance.

Also in the realm of performance, and of Oak Table members, is this blog entry from Tanel Poder on cursor: pin S waits, sporadic CPU spikes and systematic troubleshooting. Some esoteric and extremely useful things for those working with Oracle on Unix systems. But some of the most valuable advice in this posting on specifics relates to the general approach to performance, for instance tailoring the time of activity you measure to the event, not just, for instance, taking a one hour chunk of AWR as the gold standard.

Piping Function

No, not for plumbers, for programmers. Tom Kyte speaks of the NO_DATA_NEEDED function in his blog here.

EBS

This week at the Oracle E-Business Suite Technology blog:

The Scoop: Oracle E-Business Suite Support on 64-bit Linux

10gR2 Transportable Tablespaces Certified for EBS 11i

10gR2 10.2.0.4 Certified with EBS 12 on Windows Itanium x64

WLS

Record and play your WebLogic Console Tasks Like a DVR over at James Bayer's Blog.

ADF

Need some samples on ADF TaskFlows? Raghu Yadav has a great list over at his blog: ADF TaskFlows Communications.

PeopleSoft Passwords

Over at the One PeopleSoft Road blog there is a good technical posting on the inner workings of passwords in PeopleSoft, with links to a series on PeopleSoft connectivity at the same blog.

Siebel

There's a good discussion on the The Truth about PreCanInvokeMethod over at the Siebel Essentials blog.

Hyperion

There's a good series going on over at the In 2 Hyperion blog: Financial Reporting with Rolling Years and Periods (Step 3 of 4)

Security

Over at the Oracle Forensics blog, Paul M. Wright has some cautionary notes on: Oracle Wallet AUTO LOGIN ~ common misconception corrected.

Contributions by Angela Golla, Infogram Contributor

Oracle Maximum Availability Architecture - MAA

Oracle Maximum Availability Architecture (MAA) is Oracle's best practices blueprint based on proven Oracle high availability technologies and recommendations. The goal of MAA is to achieve the optimal high availability architecture at the lowest cost and complexity:

MAA best practices span Oracle Database, Oracle Application Server, Oracle Applications and Grid Control.

MAA considers a range of business requirements to make these best practices as widely applicable as possible.

MAA leverages lower-cost servers and storage.

MAA evolves with new Oracle versions and features.

MAA is hardware and OS independent.

Learn more at the MAA Homepage.

New CPU, Updates, Long Running SRs, EBS

New CPU

The new CPU is out. Here are some useful notes and links:

Oracle Products — Documentation & Special Handling Instructions
For information about supported platforms, changes, terminal CPU plans and other aspects of CPUApr2010, see My Oracle Support Note 1060989.1 “Critical Patch Update April 2010 Patch Availability Document for Oracle Products” and Note 1060981.1 “Critical Patch Update April 2010 Patch Availability Document for Oracle BEA Releases”

CPUApr2010 Documentation

Documents related to CPUApr2010 lead customers through all information they need related to their Oracle environment. To ensure that customers receive the necessary level of detail, always refer them to the appropriate document ID instead of providing the patch numbers.

Note 981278.1: Roadmap to the Oracle Critical Patch Update April 2010 documentation
OTN Critical Patch Update Advisory: Oracle Critical Patch Update April 2010 Advisory
Note 1060989.1: Oracle Critical Patch Update April 2010 Availability for Oracle Products
Note 985896.1: Oracle Critical Patch Update April 2010 E-Business Suite Critical Patch Update Note
Note 1060981.1: Critical Patch Update April 2010 Patch Availability Document for Oracle BEA Releases
Note 1060969.1: Oracle Critical Patch Update April 2010 Known Issues for Oracle Database
Note 1061002.1: Oracle Critical Patch Update April 2010 Known Issues for Oracle Fusion Middleware
Note 1061013.1: Oracle Critical Patch Update April 2010 Known Issues for Oracle Enterprise Manager Grid Control
Note 1061014.1: Oracle Critical Patch Update April 2010 Database Molecule Patch Security Vulnerability Mapping
Note 1063379.1: Oracle Critical Patch Update April 2010 Oracle Life Sciences GBU
Note 1077118.1: PeopleSoft, JD Edwards April 2010 Critical Patch Update Knowledge Document
Note 1078890.1: Critical Patch Update April 2010 Patch Availability Document for Oracle Retail Products (Doc ID 1078890.1)
Note 1076933.1: Critical Patch Update April 2010 for Oracle Communications Products

Some Oracle Software Updates

Oracle Application Testing Suite 9.1.0

Oracle Database 11g Release 2 for Windows 32 and 64 bit

Over at Grant's blog:

Updated Support Dates for Forms 10.1.2

Long Running SRs

Chris Warticki has some useful suggestions on dealing with long-running SRs. The article is primarily for those who don't have Priority Support, but still has some good avenues to explore.

Cloning

You don't have to have a big lab or get into some massive scandal about government funding just because you want to do cloning. Alejando Vargas shows you how to clone an Oracle database on the same server using RMAN duplicate from the active database.

EBS

Lots of updates this week from the Oracle E-Business Suite Technology blog:

Warning: E-Business Suite Issues with Sun JRE 1.6.0_20

Critical Patch Update for April 2010 Now Available

TDE Tablespace Encryption 11.2.0.1 Certified with EBS 11i

EBS Techstack Sessions at OAUG/Collaborate 2010

Transportable Database 11gR2 Certified with E-Business Suite

Premier Support Date Changed for Oracle Application Server 10gR2

MS Visual Studio 2008 Certified with Oracle EBS 12 on MS Windows Server (32-bit)

How Does AutoPatch Handle Shared E-Business Suite Products?

Warning: E-Business Suite Issues with Sun JRE 1.6.0_19

Contributions by Angela Golla, Infogram Contributor

Are you moving to or using Oracle E-Business Suite 12.1? Check out the Transfer of Information (TOI) online training sessions indexed in Note:807319.1.