A day in the life of an Oracle Applications Consultant


Tuesday, May 12, 2009

SURVEY - Reporting from Oracle E-Business Suite

Reporting from Oracle EBS is an important and current issue, so it would be great if you can share your views on what’s good and bad and any tips via the survey that Simon Tomey has set up.

Simon’s going to the UKOUG EBS Financials SIG in May to help with a workshop on this, so it would be tremendous to get your views, so we can have a discussion with some bite. Moreover I think we will all find the results of interest. If you’re not currently working with an organisation, please complete the survey from the perspective of the organisation that you last worked for.   

Take part in the Oracle E-Business Suite Reporting Survey   


Reporting Survey Results for May 2009 UKOUG SIG

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: and

Thursday, August 14, 2008

BI Publisher Webinar

Simon Tomey of BeLife will be running a Webinar for BI Publisher at the following dates and times: -

  • Thursday 21st August 2008 @ 7:00 PM - 8:00 PM GMT - Register Here
  • Thursday 28th August 2008 @ 7:00 AM - 8:00 AM GMT - Register Here

A short description of the webinar:

Oracle XML/BI publisher is possibly the richest new piece of functionality in E-business suite and certainly the easiest to implement. It means you can forget the text based reports you have been struggling with and delight your users with clean attractively formatted documents and spreadsheets.

This series of webinars will include some ‘quick wins’ and the steps to building and customising great XML output. Simon will demonstrate how to:

  • implement the templates which already exist in your system
  • convert GL reports to produce clean MS Excel output
  • build templates to create documents and spreadsheets (such as dunning letters, customer open balance letters, remittance advices and listings). 
  • include tables, logos, pictures, headers and footers, first and last page only content, and conditional statements (e.g. if..then). 
  • Apply some tricks (e.g. getting different XML reports from the same output file)

The first in this series of presentations will cover the seven steps to producing a BI publisher report using a very simple example. I recommend you download the slides from Simon’s presentation.

Audio Services will be provided for the following countries and it is essential that for this particular webinar you can access the audio services.

  • Australia
  • Austria
  • Belgium
  • France
  • Germany
  • Ireland
  • Italy
  • Netherlands
  • New Zealand
  • Spain
  • Switzerland
  • United States

Hence when you have registered and are given the conference call number, please check to ensure that you can actually dial that number. If, for example, you live in India and would like to make use of the audio features you would have to dial in to the conference using a U.S. number. Using VOIP services such as skype for the audio is not ideal as you may experience some network latency, in most instances you will be better off using a landline or mobile to access the conference audio.

Please also note that the webinar allows up to 25 panelists for the audio, a panelist being someone who can have a two way conversation with the presenter. Anyone who is not a panelist will only have the ability to listen to the presenter. When signing up please let me know if you would like to be a panelist. As there is a limit to the number of panelists the option to be a panelist will be awarded on a first come first served basis.

Note: If you’re unable to attend the webinar live or cannot utilise the audio facilities (as a result of your country not being included in the list of countries above) a recording of the session will be available for subsequent download and playback.

Thursday, April 17, 2008

Integrating Financial Management with Project Management using EcoSys Financial Manager

Recently I been working with a company called Ecosys Management to learn and implement one of their products, EcoSys Financial Manager. According to their site: -

EcoSys Financial Manager Architecture EcoSys Financial Manager (FM) is a web based enterprise project financial management system. Project financial management involves all aspects of managing and monitoring the flow of funds from the organization into discrete initiatives, programs, projects, and ongoing operations. These discrete efforts execute and should align to strategic objectives and priorities. The project financial management cycle encompasses long range planning, fiscal period budgeting, forecasting, spending requests, allocations, performance measurement, controls, closeouts, and adjustments.

Large organizations need to be agile and responsive - financial processes and workflows need to flow top down and bottom up. Finance and Accounting needs to reconcile information flowing in both directions: down from executives responsible for strategic planning and up from the people in the field who are close to the work required.

EcoSys FM successfully bridges corporate strategic planning and project financial management for our customers in a varied range of industries. Particularly if you are looking to integrate project management with financial management, EcoSys FM is a proven solution in organizations using Primavera and other enterprise project management systems.

If you’re interested in learning a bit more then download this EcoSys Financial Manager Presentation. If you’re potentially interested in implementing this product in your organisation then contact EcoSys


Tuesday, April 15, 2008

Oracle Reports using BI Publisher

I’m currently working as an associate consultant with an organisation called BeLife Ltd. We are interested in showing organisations how they can transform their Oracle Reports using BI Publisher (formerly XML Publisher) and would like to offer a free 1 hour demonstration of this product to anyone that’s interested.

BI Publisher is standard Oracle Financials integrated functionality, but it is only used by a few organisations. Recent feedback suggested that this is because organisations just don’t know how to start with using BI Publisher even though users are eager to experience the benefits. We’d like to show you in an hour how you can get started.

We can show you how to use BI Publisher to generate:

  • Remittance Advices
  • Dunning Letters and Customer Statements
  • General Ledger Reports for downloading direct to Excel, including grouping and formulae (sums, average, maximum, minimums)
  • Management information reports with tables, graphs and conditional formatting.

Whether you’re a super user, end user or implementor if you’re interested in potentially using this reporting tool or know of anyone that may be interested in a demonstration please contact me at .(JavaScript must be enabled to view this email address).


This demonstration will be run as a webinar. Details of the first part of a series of BI Publisher webinars are outlined here.

Page 1 of 49 pages  1 2 3 >  Last ›