OracleAppsBlog

A day in the life of an Oracle Applications Consultant

White Papers

Sunday, August 24, 2008

Batch Invoice Uploads into Oracle Payables

MS Excel to load invoice batches to Oracle Payables! Even Oracle ADI doesn’t do that, in fact few 3rd-party products do. What to do? Do as Kevin Ellis has done, develop your own in-house invoice batch interface. And if that isn’t enough to pique your interest, how about an interface for keeping your chart of accounts current between production legacy and Oracle systems? He has done that too and he has shared all in this comprehensive ORAtips cover story, discussing custom concurrent program and UNIX shell script development, Oracle Applications set-up and end-user considerations.

Download White Paper on Invoice Uploads into Oracle Payables

This article was originally published by Klee Associates, Inc., publishers of JDEtips and SAPtips. For training, consulting, and articles on JD Edwards or SAP, please visit their websites: www.JDEtips.com and www.SAPtips.com.

Friday, October 07, 2005

OraTips releases first Oracle Tips Journal

ORAtips, who empower Oracle clients to optimize the value received from their current software investment, have just released the first issue of their Oracle Tips Journal.

According to the site the Oracle Tips Journal is their flagship service, which will be read by CIOs to IT staff to Business end-users. The Oracle Tips journal will be a paid subscription and is apparently going to be produced on a quarterly basis. However, the first issue is free so sign up at the site and read the first edition. I have to admit it’s a pretty impressive publication as it caters for Oracle Applications as well as the Developer and Database community. Some of the featured articles and white papers are as follows:

Applications

• 11i Inventory’s Cost Cutoff Date – Defer Costing Until Your Standard Costs Have Been Updated, by Eric Guether
• Do You Have an Affirmative Action Plan?, by Leigh-Anne McDonald
• Maintaining Unique Customer Profile for Oracle CRM Implementations, by Anand Kanakagiri
• Oracle 11i Shipping Execution –Interface Trip Stop Trouble Shooting, by Scott Ma
• Overcoming Barriers to Supplier Collaboration, by Warren Sumner
• Lower Your Consulting Costs – Host Your Own JAD Session, by Leigh-Anne McDonald

Developer

• Oracle Discoverer 10g – Is It More Than a Reporting Tool?, by Debra Addeo
• Real Time Migration of Oracle Application Set-Ups Done In-House, by Kevin Ellis

Database

• Battling Growth and Staying Compliant Through Oracle Application Archiving, by Sean Scott
• Instant Cloning Under Your Control, by James H. Lui
• Oracle Application Database Management, Part 1: Take Database Monitoring in Oracle Applications Manager to the Next Level, by Natalka Roshak
• Implementing Oracle 10g on Windows, Part 1: Optimizing Memory Usage, by Scott Jesse
• Instant Cloning under Your Control, by James H. Lui

Enjoy the read and if you think you have something worthwhile to contribute to their publication it looks like they’re open to taking submissions.

Wednesday, January 05, 2005

Oracle OpenWorld Amsterdam Presentations available for download

OpenWorld Amsterdam took place some time ago (September 2004) but I never pointed out on this blog where you can download the presentations from so here goes.

You can obtain a listing of the presentations and associated abstracts here or go straight to the downloads page. There are some really good ppt’s here for anyone with a functional or technical interest in Oracle Products and Software.

Since I’m more functionally oriented a selection of the ones I found quite interesting are: -

• Managing Corporate Performance: Dream or Reality? - John Schoenherr, VP – Analytic Solutions, Oracle Corporation (2.36MB)
• Gaining Value from Business Intelligence: Integrating the Customer Data Hub with Your Data Warehouse - Nick Whitehead, Solution Sales - EMEA BI & Data Warehouse, Oracle Corporation (818KB)
• Oracle Daily Business Intelligence Architecture - Jeffrey Kirk, Product Director - Apps Development, Oracle Corporation (2.62MB)
• The many challenges of integration: processes, data, applications and platforms - Massimo Pezzini, Oracle Corporation (717KB)
• Content Management for the Rest of Us - Rich Buchheim, Senior Director - Product Management and ECM Strategy, Oracle Corporation (4.30MB)
• Real Time Collaboration in the Enterprise - Anindo Roy, Director - S/W Development, Oracle Real Time Collaboration Group, Oracle Corporation (3.70MB)
• Location Technology and Applications with Oracle 10G - Euro Beinat, Geodan Mobile Solutions (1.38MB)
• Increasing Control: Centrally Managing Statutory Requirements and Corporate Policy Compliance - Francis Veldeman and Olivier Arthus, Oracle EMEA (688KB)
• Oracle Customer Service: Information Driven Service - Stephen Slade, HQ Product Director – CRM Service and Wilfred Sholman, EMEA Principal Consultant, Oracle Corporation (3.60MB)
• General Ledger: Improve the Transparency and Auditability of your Corporation - Gerard Verton and Ad de Kievit, Deloitte (965KB)
• Link Planning to Execution with Oracle Enterprise Planning and Budgeting - John Schoenherr, VP – Analytic Solutions and Dirk de Ridder, Principle Sales Consultant, Oracle EMEA (373KB)
• Revenue and Receivables Management: ‘How to keep your boat?’ - Arno van der Weijden, Atos Origin (2.47MB)
• RFID, Mobile and the Brave New World of Sensor based Computing - Simon Pollard, VP - EMEA Industrial Sector, RFID & Sensor Based Services and Edwin W. Kalischnig, Director - Business Development, RFID & Sensor Based Services, Oracle Corporation
• Efficiency, Customer Service and Lean Agility with Oracle Discrete Manufacturing - Nick Arrowsmith, EMEA Supply Chain, Oracle Corporation
• Advanced Procurement: Development Update on Oracle’s SRM Offering - David Hope-Ross, Senior Director - Procurement Applications, Oracle Corporation.
• Unbundling Billing Complexity: Enabling a Convergent Process Architecture for Telecoms - Marc T. Stolte, Director - Telecoms, Oracle EMEA
• Support Complex Business Models with Adaptive Order Fulfillment - Drew Campbell, Vice President - Order Fulfillment Products, Oracle Corporation

Sunday, November 21, 2004

Oracle Partner Feature - Project Partners, the experts in Oracle Projects

This post discusses the site of an Oracle Partner who specialises in the implementation of Oracle Projects and has some good white papers on this topic that can be downloaded.

According to the Project Partners site: -

Project Partners, LLC is a company dedicated to helping our customers achieve a competitive advantage through Enterprise Project Management. Our experience goes beyond standard Oracle Financials, Project Costing and Project Billing.

We have in-depth knowledge in Project Manufacturing, Project Management Integration, Self-Service technology, and much more. We understand the needs of your project driven business.

A summary of white papers and presentations that you can download from their site are as follows: -

• Creating Custom Invoice Format Groups in PA 11i (611KB)
• OP3 White Paper - Rand Egger (503KB)
• Oracle Projects – Client Extensions - Randal B. Martin (110KB)
• Project Allocations - John Sasali, Zach Connors, John Pilkington (485KB)
• Summarization Demystified - Randy Martin (1.87MB)
• R11i Oracle Projects New Features - John Sasali (1.07MB)
• Close Encounters of the Third-Party Kind - Martha Anne McKillip, Principal Consultant (1.23MB)
• Spread ‘em! Using Project Allocations in Oracle Projects 11i - Zach Connors (1.62MB)
• Implementing Projects 11i in a Multinational Environment - A Case Study - Randy Martin (467KB)
• Tracking Capital Expenditures in Oracle Projects - (22KB)
• New Features in Release 11 - Randy Egger (92KB)
• Earned Value Management in the Oracle Financials Environment - J. Steven Joines, L. Bruce Gibby and Randy Egger (434KB)
• When Serious Project Management is a Critical Business Requirement… - P. A. “Trisha” Jansma, L. Bruce Gibby, Calvin R. Chambers, J. Steve Joines and Randy Egger (162KB)

Lastly, they also have a newsletter that you can subscribe to.

Friday, September 10, 2004

Oracle Applications Auditing and Security Best Practices

This post points you to a site that has some really good presentations and white papers related to auditing and securing Oracle E-Business Suite and provides some related links.

Having been an Auditor/Accountant in a former life, I always try to make certain that when implementing an ERP system I take into account security issues and also ensure that the system can be audited by both internal and external parties. Oracle has many built in auditing and security features, but in my experience, people do not make appropriate use of them because they are not aware they exist or they do not have the time or budget to implement them. Personally, I believe awareness of the capabilities of Oracle E-Business Suite is the starting point towards ensuring system security and auditability. Hence, it’s always nice to come across some information which can give you new ideas as to what approach you should take when implementing such a system.

A really good site that I have come across which has some superb white papers and related information on Oracle Applications auditing and security is Integrigy. According to their site: -

Integrigy Corporation is a leader in application security for large enterprise, mission critical applications. Our application vulnerability assessment tool, AppSentry, assists companies in securing their largest and most important applications. Integrigy Consulting offers security assessment services for leading ERP and CRM applications.

Key Oracle Applications papers and presentations on auditing and security that you can download are as follows: -

• Securing 11i - What did you miss? (221KB) - Stephen Kost, Chief Technology Officer
• Securing Oracle Applications - What You Need to Know (78KB) - Stephen Kost, Chief Technology Officer
• Securing the Oracle Applications Infrastructure (152KB) - Stephen Kost, Chief Technology Officer
• Guide to Auditing in Oracle Applications (303KB)

The resources section of the site is also quite good since it not only includes white papers but also security alerts, advisories and notes, analysis and tools and scripts . There is also a quarterly newsletter published which keeps you up to date with Security Issues around Oracle Applications.

Other Resources

• Best Practices for Securing Oracle E-Business Suite – Metalink Note ID 189367.1
• Best Practices For Securing Oracle E-Business Suite 11i For Internet Access – Metalink Note ID 229335.1
• 11i: A Guide to Understanding and Implementing SSL for Oracle Applications – Metalink Note ID 123718.1
• Oracle Applications 11i System Administrator’s Guide
• Oracle Security Alerts – http://technet.oracle.com