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

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:
http://www.oracle.com/technology/deploy/security/index.html

EBS, AIA, PeopleSoft, BI

EBS

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

Reminder: Premier Support for 10gR2 10.2.0.4 Database ends July 2010

Reminder: Premier Support for EBS 11i ends November 2010

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

AIA

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

Troubleshoot your Node Manager for AIA Foundation Pack 11gR1

PeopleSoft

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

BI

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

Performance

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

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 http://www.oracle.com/support/contact.html 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 http://www.oracle.com/support/contact.html.
For North America: The number will be 1.800.223.1711

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

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

DataGuard

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

EBS

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

TDE Tablespace Encryption 11.2.0.1 Certified with EBS 12

Interim Update #1: Microsoft Office 2010 and E-Business Suite

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:

CONNECT BY and Recursive CTE

connect by and recursive with (part 2)

Performance

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

http://blog.tanelpoder.com/2010/05/07/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 (http://www.oracle.com/support/collateral/oracle-technical-support-policies.pdf)
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 (http://www.oracle.com/support/library/brochure/lifetime-support-technology.pdf)
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

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.

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.

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

ADF

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

PeopleSoft

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

Protecting PDF files and XDO.CFG

APEX

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

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

Hyperion

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

SQL*Net

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.

EBS

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

EBS + 11g Database Upgrade Best Practices Whitepaper Available

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.

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

EBS

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

Discoverer 11g 11.1.1.2 Certified with EBS 12 on Five New Platforms

Database Vault 11gR2 11.2.0.1 Certified with Oracle E-Business Suite

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

ADF

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


Taskflows

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.

PeopleSoft

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

Siebel

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

Indexing

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

Exadata

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

Primavera

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)

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.