Friday, May 28, 2010

Contributions by Angela Golla, Infogram Contributor

PeopleSoft Enterprise Performance Management 9.1 Completes Rollout of PeopleSoft Release 9.1
Now available is Oracle’s PeopleSoft Enterprise Performance Management Release 9.1. Enhancements increase productivity, improve business performance, and reduce operational costs. For example, PeopleSoft Enterprise Performance Management 9.1:

Helps organizations improve productivity of the budget planning business process through customer-driven enhancements in PeopleSoft Planning & Budgeting

Improves financial and operational analysis through seamless integration with PeopleSoft Enterprise Human Capital Management, Customer Relationship Management, and Financials/Supply Chain Management Release 9.1

The availability of PeopleSoft Enterprise Performance Management Release 9.1 is the last in a series of rollouts of Oracle’s PeopleSoft Enterprise Release 9.1—Oracle’s largest PeopleSoft Enterprise release ever.

The third release since Oracle and PeopleSoft combined, PeopleSoft Enterprise Release 9.1 includes:
21 new PeopleSoft solutions
1,350 new features
150+ customers Involved
28,000+ pages enhanced with Web 2.0 capabilities
300 new Web services
200 industry-specific enhancements

Thursday, May 27, 2010

Contributions by Angela Golla, Infogram Contributor

Security is always an ongoing concern. For the latest information on this important topic, check out the Security Technology Center available at:

EBS, AIA, PeopleSoft, BI


New this week at the Oracle E-Business Suite Technology blog:

Reminder: Premier Support for 10gR2 Database ends July 2010

Reminder: Premier Support for EBS 11i ends November 2010

EBS 11i and R12 certified with DB 11gR2 on Windows


The Official AIA Blog brings us a very useful technical posting:

Troubleshoot your Node Manager for AIA Foundation Pack 11gR1


Over at the BAOA: Blogging About Oracle Applications blog we find a good rundown on creating CRM workers, the official way, or when circumstances differ, getting the job done with CDM Classes:

Creating PeopleSoft CRM Worker using CDM Classes

PeopleSoft Wiki

Have you looked at the PeopleSoft Wiki lately? It's not only that wikis are Web 2.0, up to date technology that harnesses the power of crowd thinking, it's also that the word wiki just sounds cool. How many other tools do you use at work that rhyme with tiki?

The PeopleSoft Wiki


Ashish Shrivastava over at A Bi Publisher developer's diary... has some valuable experience to share on EBS: OPP Out of memory issue...

A very nice reference table for you to file away and use over at the OracleBIBlog:
OBIEE Date Expressions Reference


In relational theory textbooks, lots of things don't matter. You build cartesian products every morning, first thing. In the real world you are much pickier about what you do in order to avoid what's known in the trade as 'lost that job because of a Cartesian product in the VP's report' syndrome.

Charles Hooper continues his valuable series of performance posts with: Column Order in a Table – Does it Matter? 2

Wednesday, May 26, 2010

Announcing: Oracle Will Be Consolidating Multiple Toll-Free Customer Support Numbers

Contributions by Sherron Garnett, Infogram Contributor

Oracle recently evaluated our toll-free customer support numbers across all geographies and all languages—with an emphasis on those used for Oracle’s PeopleSoft, JD Edwards, Siebel, and Hyperion support—and decided to consolidate these numbers into Oracle Support hotlines.

As a result of this consolidation, customers who call a number that has been consolidated will now hear the following recorded message:

"On June 14, 2010, this Oracle Global Customer Support number will be disconnected as we have transitioned to the Oracle Support hotlines. Please go to to find the Oracle Global Customer Support toll-free number in your country."

For the first six weeks, customers automatically will be transferred to the proper number. For weeks seven and eight, customers will be asked to hang up and dial the correct number. After eight weeks the number will be deactivated.

To see the directory of toll-free numbers, go to
For North America: The number will be 1.800.223.1711

Please use the link above for all other Customer Support Numbers.

Thursday, May 20, 2010

DataGuard, EBS, Performance, SQL Editing Tool, Support Policies, PeopleSoft


TCP socket size is not something most people dwell on a lot. Well, according to Alejandro Vargas' Blog, it can be an important factor for high throughput DataGuard systems: How to Calculate TCP Socket Buffer Sizes for Data Guard Environments


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

Hierarchies in EBS

Hierarchies in RDBMS queries is one of those subjects that make junior developers (and even some fairly senior ones) wish they had taken that opportunity to work in their family business instead of dealing with the code. Oracle is constantly working to make it easier to generate hierarchies from relational tables, and here is another aspect pointed out by Laurent Schneider:


Alberto Dell'Era offers a very useful looking tool for tracing sessions: Xtrace: an Oracle session trace browser – exec flow

Jonathan Lewis has some answers on the question he posed at his lates Quiz Night in this posting about improving efficiency by changing a two table join into a three table join here: double trouble.

At Charles Hooper's Oracle Notes there is a good in-depth discussion of the pluses and minuses of cartesian joins. Cartesian joins tend to scare people, who want to keep them where they belong, between the covers of a relational database theory book. But it turns out there are circumstances where they can improve performance. Read about it here.

SQL Editing Tool

Tanel Poder has a posting on a very handy looking tool for editing and command history in tools like SQL*Plus at the Unix command line: Flexible Sqlplus command line history with RLWRAP

Support Policies

Oracle Tech Support Polices and Lifetime Support brochures have been updated to reflect the extension to 9.2 Extended Support

Tech Support Polices (
For customers with current support contracts for Oracle9i Database Release 9.2 on the following platforms: Solaris SPARC (64 bit), Linux x86 (32 bit). IBM AIX, HP-UX Itanium, HP-UX PA-RISC, HP Tru64 UNIX, Microsoft Windows (32 bit), IBM z/OS on System z, and IBM Linux on System z, Limited Extended Support will be available from July 2010 through July 2012. During this period, you will receive Severity 1 fixes only. Critical Patch Updates (“CPUs”) will not be made available during this period.

Lifetime Support Brochure (
For Oracle Database 9.2 a limited bug fix service will be available from Aug 2010 until July 2012. For details please refer to the Technical
Support Policies.

10.2 Fee Waivers
One final point due to the late porting of 11g on z/Linux we’re extending the fee waiver period for 10gR2 ES for an extra year for z/Linux customers

For customers with current support contracts running Oracle Database 10gR2 for z/Linux, the Extended Support Waiver Period has been
extended for one year. Extended Support will be waived from August 2010 – July 2012.


PeopleSoft users should have already received an email on this, but just in case you missed this:

URGENT: PeopleTools 8.50 Upgrade Issue! Datetime not converted to Timestamp

What are we announcing?

We need to bring to your attention a recent discovery for customers who have upgraded to 8.50 PeopleTools on a pre-9.1 PeopleSoft Application on an Oracle database platform.

It is critical that you review the solution attached to this email (also available in My Oracle Support, Document ID 1094003.1), if you're planning to move to production with this configuration.

If you are currently in production with this configuration, we ask that you immediately log a Service Request with Oracle Global Support and a Support Engineer will consult with you on next steps. When logging this SR, please use the following as the Problem Summary to facilitate a timely response: "Datetime not converted to Timestamp [ID 1094003.1]".

Thank you for your quick attention to this matter. Please contact the Oracle Support team to provide assistance with any concerns you may have with your current implementation.

- Regards,

PeopleTools Install and Upgrade Team, Global Customer Support.

Tuesday, May 18, 2010

Contributions by Angela Golla, Infogram Contributor

Oracle Has Consolidated Our Multiple Toll-Free Customer Support Numbers

Oracle recently evaluated our toll-free customer support numbers across all geographies and all languages—with an emphasis on those used for Oracle’s PeopleSoft, JD Edwards, Siebel, and Hyperion support—and decided to consolidate these numbers into Oracle Support hotlines. To obtain the correct support phone number for your country, please see the Global Customer Support Contacts Directory.

Thursday, May 13, 2010

ADF, Data Warehouse, PeopleSoft, APEX, Blog of Note, Hyperion, SQL*Net, Avoiding Hold


Lots of good ADF postings over at Raghu Yadav's Weblog as usual. An example is this one:

ADF Taskflow Transaction Management

Data Warehouse

The Data Warehouse Insider has some links to podcasts and other resources on the Oracle Communications Data Model


A good tip on protecting PDFs in PeopleSoft over at the PeopleSoft Technology Blog:

Protecting PDF files and XDO.CFG


David Peake lets us know that APEX 4.0 Early Adopter III (EA3) now live! and you can give it a try here:

Blog of Note: Rittman Mead Consulting Weblog

You've often seen postings from this blog, and there are a batch of them out there now. They tend to have informative, highly technical postings to help users of our technology get their jobs done, which is exactly the kind of blog I like. Here are a couple of recent examples:

Adding Default Rows with OBIEE

Oracle EPM 11.1.2 – Essbase Calculations on ASO Cubes – Part 1– Using Calc Manager


A very handy posting for anyone involved in tracking store sales over at the Ranzal and Associates blog: Using Hyperion Essbase to Report Comparable Store Sales


A link from Tom Kytes blog to Jonathan Lewis' blog on SQL*Net compression that will be of interest to a lot of RDBMS users:

A SQLNet thing I probably forgot about...

Avoiding Hold

Hold happens. You sit there listening to the music and think: I could be doing something else right now. The Web Workers Daily blog came across a way to do just that. LucyPhone, an online application that will sit on hold for you and call you back when a person comes on the line.


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

EBS + 11g Database Upgrade Best Practices Whitepaper Available

Wednesday, May 12, 2010

Contributions by Angela Golla, Infogram Contributor

Premier Support for E-Business Suite 11.5.10 ends in November 2010. If you are planning to remain on E-Business Suite 11.5.10 a little while longer and are purchasing Extended Support, please check out Note:883202.1. It provides minimum baseline patch requirements for customers purchasing Extended Support in order to receive new bug fixes. New bug fixes will only be provided to customers who purchase Extended Support and meet the baseline patch requirements. Additional information is available at Oracle's Lifetime Support Policy.

Thursday, May 6, 2010

EBS, Taskflows, AskTom, PeopleSoft, Siebel, Indexing, Exadata, Primavera


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

Discoverer 11g Certified with EBS 12 on Five New Platforms

Database Vault 11gR2 Certified with Oracle E-Business Suite

EBS 12.1.1 Test Starter Kit now Available for Oracle Application Testing Suite


Andrejus Baranovski has several valuable postings of late. Example: Handling Exceptions in Oracle UI Shell and ADF Dynamic Regions


Working with taskflows? Raghu Yadav has several articles on the subject at his blog such as:
Refresh bounded taskflows across regions using InputParameters,PageDef Params

AskTom Turns Ten

The AskTom site is celebrating ten years of helping the Oracle community, as Tom Kyte notes in his blog.


Okay, you get up in the middle of the night. You can't sleep. You absolutely have to have some transient variable persistence. Jim Marion over at Jim's PeopleSoft Journal can fulfill that craving: FUNCLIB's and Event Scoped Variables


There are several postings of late at the Siebel Essentials blog. The latest is on the Gateway Name Server Audit Trail.


Richard Foote, the guru of things that branch and are not trees, shares this wisdom on Concatenated Bitmap Indexes Part I


There's a three part series available over at the Striving for Optimal Performance blog on Exadata Storage Server and the Query Optimizer

Part 1

Part 2

Part 3


I've yet to find any good Primavera blogs, but there is a quite active LinkedIn group. If you have a LinkedIn account: Oracle Primavera Special Interest Group (SIG)

Tuesday, May 4, 2010

Contributions by Angela Golla, Infogram Contributor

Are you upgrading from Oracle RDBMS 10.2 to 11.2? Note:1075832.1 contains a wealth of information such as notes, training, best practices and more.

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.