Wednesday, December 19, 2007

Infogram Now Blogged!

This is the premier issue of the Oracle Infogram weekly newsletter available as a blog (and thus available as an RSS feed). Now you don't have to wait till the end of the week for a new set of links to useful Oracle info, it will be coming into your RSS reader automatically (anyone have a favorite? Mine is the Sage RSS plugin for Firefox).

Let's start things off with some ideas on using checksums to compare tables from a blog I just discovered recently (by way of another blog, man, this is getting 'linky'):

http://geertdepaep.wordpress.com/2007/12/07/compare-tables/

More links tomorrow, but in the meanwhile, here's last week's collection:

Oracle 11g

Caching and pooling:

http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/11g-caching-pooling.html

RDBMS

(Contributed to the Infogram by Chris Gait, Infogram Editor)

Some good ideas about using RDA (Remote Diagnostic Agent) from Chris Warticki:

http://blogs.oracle.com/Support/newsItems/viewFullItem$37

The finer points of outer joins, ANSI, Oracle and all points between:

http://optimizermagic.blogspot.com/2007/12/outerjoins-in-oracle.html

Security

A long, sad, detailed history of data breaches over the last several years:

http://www.privacyrights.org/ar/ChronDataBreaches.htm

Peter Finnigan's Security Masterclass available:

http://www.petefinnigan.com/weblog/archives/00001134.htm

Podcast from Mike Rothman. He speaks with Rich Mogull of Securosis about database security:

http://www.slaviks-blog.com/2007/12/03/the-need-for-database-security-explained-in-5-minutes/

APEX

ApEx doesn't do everything? Well, practically everything. And when you need something else there are Java libraries:

http://carlback.blogspot.com/2007/12/apex-and-3rd-party-js-libraries.html

Oracle e-Business Suite News

Best Practises for upgrading to R12:

http://blogs.oracle.com/schan/2007/11/29#a2268

Optimizing EBS:

http://blogs.oracle.com/schan/2007/12/11#a2297

ESM Links from Asmi Maharishi

General Announcements

Oracle Configurator ranked as "Strong Positive" in Gartner MarketScope for Sale Configuration
In the recently released
Gartner MarketScope for Sales Configuration Oracle Configurator was the only vendor ranked as 'Strong Positive', the highest possible ranking.

Marazzi (Italy) - Oracle EBS R12 where Demantra was key!
The Marazzi Group is one of the main tile manufacturers in the world and is the leading tile producer in Europe. Demantra was key in proving Oracle's supply chain management-driven solutions. Click
here to read more.

Events

Oracle's 2nd Annual Maintenance Summit is now open!
January 30 – February 1, 2008 - Gaylord Palms Resort and Convention Center, FL
Register Now...click Here
Last year’s inaugural event was a tremendous success, and this year’s Summit promises to be even more spectacular. The conference is free to all Oracle customers and prospects. This year’s conference will be focused on delivering a reliable Asset Lifecycle Management program through people, business process, and software.

Case Studies

Motorola - Case Study on Reverse Logistics
The Integrated Digital Enhanced Network (iDEN) division of Motorola,which provides global support for a wide range of cell phones and two-way radios, took up the challenge of creating competitive advantage by streamlining its reverse supply chain, an often-overlooked area of the value chain. iDEN looked to turn its product return and refurbishment processes into a strategic competitive advantage.

White Papers

Global Supply Chains - Understanding Risks and Rewards

A briefing paper from the Economist Intelligence Unit sponsored by Oracle

JDeveloper

How to implement Amazon webservice in ADF:

http://technology.amis.nl/blog/?p=2654

Performance

Richard Foote, a well known name in the realm of optimizing Oracle, has a blog now:

http://richardfoote.wordpress.com/

Web 2.0

There's an Oracle Wiki:

http://wiki.oracle.com/page/FAQ

Have you joined Oracle Mix yet? Oracle Mix is a place you can post that idea you’ve had for years about improving an Oracle product and have the rest of the user community vote on it, or you can just network. It’s like a cocktail party, only without the drinks, or the snacks, or…well it’s still worth checking out:

https://mix.oracle.com/\

Eddie Awad talks about user groups, not a Web 2.0 concept per se, but many of the implementations make use of the latest gadgets and gizmos. (There's even an Oracle user's group in Second Life):

http://awads.net/wp/2007/12/13/the-value-of-oracle-users-groups/

IT Business News

Ever have a web-conference meltdown? I sure have. Web Worker Daily brings us some tips to avoid debacles:

http://webworkerdaily.com/2007/12/13/how-to-have-a-great-web-meeting/

Have any operations in China? This is an excellent blog on Chinese legal issues (and this article points to an interesting blog on business in China):

http://www.chinalawblog.com/2007/12/china_sucess_stories_new_blogr.html

Another 'best of breed' China blog is Danwei:

http://www.danwei.org/from_the_web/danwei_picks_20071213.php

Client Side Oracle

Tired of using JInitiator on the client for EBS Releases 11i and 12? You can now Replace JInitiator with Sun Java Plug-in 1.5.0_13:

http://blogs.oracle.com/schan/2007/12/07#a2290

Oracle Retail

Here are some Metalink 'notes of note' on Oracle Retail that Debbie Alms discovered for the Infogram:

Retail Allocations

1. Same Allocation Can Be Approved In Multiple Concurrent Sessions
MetaLink Note 461260.1



2. Are You Receiving Errors After Applying Patch 12.0.5?
MetaLink Note 465094.1


Retail Merchandising

1. "Modulus 10" Algorithm Used to Verify Item Number In Retail Merchandising System
MetaLink Note 466840.1

2. Finding Actual Income Does Not Get Populated In DEAL_ACTUALS_ITEM_LOC Table For Bill Back Rebate Deals?
MetaLink Note 469403.1

3. Receiving An Error When Creating An External Transfer In A Non-Multichannel Environment?
MetaLink Note 462928.1


Retail Invoice Matching

1. Finding That The Invoice Is Not Matching Correctly When Using Amount Tolerance?
MetaLink Note 434978.1

2. Are You Receiving The Following Warning Message During Detail Matching: "Dept/Class For Item Is Not Associated With A Business Role Needed For Routing"?
MetaLink Note 434978.1


Retail Price Management

Discrepancy In Field Size In RPM GUI And In Tables On Backend
MetaLink Note 460780.1



Retail Integration Bus

1. RIB Container Shutting Down Unexpectedly And Not Being Restarted For Version 12.0.1
MetaLink Note 467317.1

2. Retail Integration Bus 12.0.1.x Patch Releases
MetaLink Note 461062.1

3. Required Grants For Retail Integration Bus Distributed XA Transaction
MetaLink Note 467466.1

Retail Data Warehouse

Finding Overlapping Seasons Or Phases Are Getting Rejected in RDW
MetaLink Note 455925.1



Retail Security Manager

Finding You Can Only Access Role Admin / Role Admin Workspace Using Admin Role?
MetaLink Note 467514.1



Retail Point-Of-Service (versions 6 & 7)

How Is It Possible To Close A Store Through The Use Of A Database Script?
MetaLink Note 396091.1


Retail Price Optimization

Oracle Retail Price Optimization Personal Computer (PC) Recommendations
MetaLink Note 465321.1


Retail RPAS

1. Domain Daemon Process Disappears And Users are Prohibited from Logging In
MetaLink Note 464169.1

2. Experiencing Contention Issues on the "Wbbatch" Binary When Running the Autoworkbook Build Job?
MetaLink Note 467450.1


Retail Store Inventory Management (SIM)

Receiving An Error In Retail Merchandising System (RMS) When Processing A Warehouse Return Created In Store Inventory Management (SIM) System?
MetaLink Note 465291.1



Retail Point-Of-Sale

How To Setup Base Currency In Store Inventory Management (SIM) And Retail Point Of Sales (RPOS) version 11.1?
MetaLink Note 415454.1



Retail Warehouse Management System

Why Can The Receiving Labels Be Nulled Even Though An Appointment Is In "Open" Status?
MetaLink Note 433987.1

Support News

Finally something to do with that spare mainframe in your closet. Oracle 10.2.0.3 now certified for IBM System Z (Linux on a mainframe):

http://blogs.oracle.com/schan/2007/12/10#a2292

What's New in Oracle Support Services

Releases and Patching

11g RDBMS releases (HP-UX added on 21-Nov-2007:

http://www.oracle.com/technology/software/products/database/index.html

Some Metalink notes of note contributed to the Infogram by Pushpinder Sethi:

Oracle Workflow Notification Mailer

Metalink Note #

268085.1 Configuring the Oracle Workflow 2.6/11i.OWF.H Java-based Notification Mailer with Oracle Applications 11i

164871.1 Configuring the Workflow Notification Mailer in Oracle Applications Manager 11i

172174.1 WF 2.6: Oracle Workflow Notification Mailer Architecture in Release 11i

OCP Tracks

New Oracle Certification Beta Exams Now Available:

· 1Z1-241 PeopleSoft Application Developer I: PeopleTools & PeopleCode (Last Date for Beta version: November 30, 2007)

· 1Z1-242 PeopleSoft Application Developer II: App Engine & Integration (Last Date for Beta version: January 4, 2008)

· 1Z1-312 - Oracle Application Server 10g: Administration II (Last Date for Beta version: Extended to November 30, 2007)

· 1Z1-402 Enterprise Linux Fundamentals (Last Date for Beta version: Extended to December 15, 2007)

· 1Z1-403 Enterprise Linux System Administration (Last Date for Beta version: January 20, 2008)

Read more

Security: Critical Patch Update for October 2007 issued

Reading for your testing enjoyment on it's way toward prod:

http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpuoct2007.html

And a blog entry with some best practices on the CPU:

http://blogs.oracle.com/gridautomation/2007/10/17#a71

The latest issue of Oracle magazine (Nov/Dec. 2007):

http://www.oracle.com/technology/oramag/oracle/07-nov/index.html

Oracle Priority Support General News

(Contributed to the Infogram by S. Vitani)

Reminders:


17-Oct-2007 - Oracle Critical Patch Update - October 2007 Release

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=455284.1

17-Oct-2007 - Oracle Critical Patch Update for Oracle Server and Middleware Products including Enterprise Manager - October 2007 Release

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=455287.1

17-Oct-2007 Oracle® E-Business Suite Critical Patch Update Note - October 2007 Release

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=455294.1

03-Oct-2007 - Oracle Announces Maintenance Wizard Version 2.06 for the eBusiness Suite Upgrade to Release 12
Oracle Support provides Maintenance Wizard to guide you through the upgrade of Oracle Applications technology stack and products from Release 11i versions to Release 12. It draws on instructions from numerous manuals and other documentation to provide you with a complete picture of the activities required for an upgrade.
Maintenance Wizard helps you to reduce upgrade tasks by dynamically filtering the necessary steps based on criteria it obtains from your Applications environment. The resulting report is a set of step-by-step instructions of exactly what you need to do to complete your specific upgrade, including any critical patches that your system may require. It can also automatically execute many of the tasks for you, so as to reduce the possibility of errors or accidental omission of vital tasks.

https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=215527.1

01-Oct-07 - Oracle Announces the Support Diagnostics Patch for eBusiness Suite Release 11i - September Release

* Support Diagnostics is a free tool provided by Oracle Support to ease the gathering and analyzing of information from your eBusiness Suite specific to a existing issue or setup

· Formatted output displays the information gathered, the findings of the analysis and appropriate actions to take if necessary

· This tool is easy to use and is designed for both the functional and technical user
Oracle Support Diagnostics are designed to improve:

· Problem Avoidance - resolving configuration and data issues that would cause processes to fail

· Self Service Resolution - resolving problems without the need to contact Oracle Support

· Reduction in Resolution Time - minimizing the time spent to resolve an issue by increasing support engineer efficiency

https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=226429.1

20-Jul-07 - Introduction to Database N-apply for CPU Patches:

With the July 2007 Critical Patch Update for 10.2.0.3 Database, Oracle is introducing a new way of packaging and applying CPUs called N-apply. This eliminates all non-security fixes from Critical Patch Updates, eliminates the cumbersome CPU merge patch, and in general improves customer experience by allowing them to install Critical Patch Updates more quickly and easily.

For more information see MetaLink Note:Note 438314.1.

Webcasts also available: https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=444376.1

Software Configuration Manager:

Diagnose system issues before they become critical. Increase system performance and availability. Get faster
problem resolution and reduce IT risks and costs. Optimized performance.
HealthChecks identify potential issues that may affect the overall stability, performance, and scalability of your
Oracle environment and inform you of the risks and recommendations associated with these issues.
Software Configuration Manager, a proactive automated support capability, included in Oracle Premier Support,
offers you a simpler way to track, manage, and support your Oracle configurations while reducing the risk of
unplanned system downtime.


Overview -
http://www.oracle.com/pls/ebn/swf_viewer.load?p_shows_id=5073092 (Flash: 4 minutes)
http://www.oracle.com/support/premier/advanced-support-technologies/my-configurations-projects.html

Webcasts also available: https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=418277.1

Podcast: The Importance of Using Oracle's Software Configuration Manager (mp3: 12 minutes)


http://feeds.feedburner.com/~r/OracleAppcast/~3/104568129/5272999.mp3

Important Numbers:

Oracle Support: 800.223.1711
Oracle Telephone Conference: 888.967.2253

Helpful Links:

Oracle Web Conferencing:
http://conference.oracle.com (disable pop-ups)
MetaLink - Oracle Support:
http://metalink.oracle.com
Oracle Technology Network:
http://otn.oracle.com
Oracle Applications Community:
http://www.oracle.com/applications/community/index.html
Oracle OpenWorld:
http://www.oracle.com/openworld/index.html
About Priority Service:
http://www.oracle.com/support/advanced-customer-services/priority-service.html

Online Tutorials: Oracle By Example: http://www.oracle.com/technology/obe/start/index.html
Oracle University:
http://education.oracle.com/
Oracle Advisor Webcast Program:
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=398877.1
Schedule:
https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=398884.1
Archive:
https://conference.oracle.com/imtapp/app/arc_pub.uix?scope=m

International Oracle Users Group: http://www.ioug.org/
Oracle Applications User Group:
http://oaug.org/ - http://floridaoaug.oaug.org/
Special Interest Groups:
http://secure.meetingexpectations.com/oaug/groups/GroupList.aspx?type=1001&name=Special%20Interest%20Groups%20(SIG)

PublicSector: http://www.govtsig.org/
Human Resources:
http://ohug.org/
OHUG Oracle University site:
http://education.oracle.com/pls/web_prod-plq-dad/ou_usergroups.ou_ohug_home

No comments:

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.