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'):
More links tomorrow, but in the meanwhile, here's last week's collection:
Caching and pooling:
(Contributed to the Infogram by Chris Gait, Infogram Editor)
Some good ideas about using RDA (Remote Diagnostic Agent) from Chris Warticki:
The finer points of outer joins, ANSI, Oracle and all points between:
A long, sad, detailed history of data breaches over the last several years:
Peter Finnigan's Security Masterclass available:
Podcast from Mike Rothman. He speaks with Rich Mogull of Securosis about database security:
ApEx doesn't do everything? Well, practically everything. And when you need something else there are Java libraries:
Oracle e-Business Suite News
Best Practises for upgrading to R12:
ESM Links from Asmi Maharishi
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.
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.
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.
Global Supply Chains - Understanding Risks and Rewards
A briefing paper from the Economist Intelligence Unit sponsored by Oracle
How to implement Amazon webservice in ADF:
Richard Foote, a well known name in the realm of optimizing Oracle, has a blog now:
There's an Oracle Wiki:
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:
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):
IT Business News
Ever have a web-conference meltdown? I sure have. Web Worker Daily brings us some tips to avoid debacles:
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):
Another 'best of breed' China blog is Danwei:
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:
Here are some Metalink 'notes of note' on Oracle Retail that Debbie Alms discovered for the Infogram:
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
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
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
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
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):
Releases and Patching
11g RDBMS releases (HP-UX added on 21-Nov-2007:
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
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
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)
Security: Critical Patch Update for October 2007 issued
Reading for your testing enjoyment on it's way toward prod:
And a blog entry with some best practices on the CPU:
The latest issue of Oracle magazine (Nov/Dec. 2007):
Oracle Priority Support General News
(Contributed to the Infogram by S. Vitani)
17-Oct-2007 - Oracle Critical Patch Update - October 2007 Release
17-Oct-2007 - Oracle Critical Patch Update for Oracle Server and Middleware Products including Enterprise Manager - October 2007 Release
17-Oct-2007 Oracle® E-Business Suite Critical Patch Update Note - October 2007 Release
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.
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
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.
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)
Oracle Support: 800.223.1711
Oracle Telephone Conference: 888.967.2253
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:
International Oracle Users Group: http://www.ioug.org/
Oracle Applications User Group: http://oaug.org/ - http://floridaoaug.oaug.org/
Special Interest Groups:
Human Resources: http://ohug.org/
OHUG Oracle University site: