OracleAppsBlog

A day in the life of an Oracle Applications Consultant

Reports

Saturday, November 28, 2020

Oracle Fusion Financials R13 -  Reports and Analyses

Perhaps the most useful report listing I always have at my disposals is the one Oracle delivers for Financials. It lists all the reports currently available for the following modules: -

• Accounting Hub
• Advanced Collections
• Assets
• Budgetary Control
• Cash Management
• Expenses
• Financials for EMEA
• Financials for Asia/Pacific
• Financials for the Americas
• General Ledger
• Intercompany Accounting
• Payables
• Payments
• Receivables
• Revenue Management
• Tax

Furthermore it classifies the reports accounting to type, sub type and run type and provides catalogue location, description and report output samples.

Download the Oracle Financials Cloud Release 13 Reports and Analyses Listing which covers reports available from Release 12 up to R13.18A

Wednesday, November 25, 2020

Oracle Fusion Procurement R13 -  Reports and Analyses

With each major release Oracle produces a seeded listing of reports. Periodically with the quarterly updates one might see a a few new reports appear. I always find it quite useful to have this to hand when working with clients as it is searchable and you can filter by specific modules. Download the Oracle Procurement Cloud Release 13 Reports and Analyses Listing which outlines what’s available for Sourcing, Suppliers, Purchasing, Self Service Procurement and Purchasing.

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 (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.

Wednesday, September 21, 2005

ITtoolbox Cognos Blog

I came across a Cognos blog at ITtoolbox the other day which I though I would give a mention. Cognos has been around for as long as I’ve been implementing enterprise systems. In my former days as a BaaN consultant we used to use it and even with Oracle it’s a viable option when it comes to reporting.

According to the Cognos site:

Cognos is the world leader in business intelligence (BI) and performance planning software for the enterprise. Our solutions let companies improve and direct corporate performance by enabling all of the key steps in the management cycle—from planning and budgeting, to measuring and monitoring performance, to reporting and analysis. Cognos is the only company to support all of these key management activities with a complete solution that spans all of the essential components of CPM—enterprise planning, scorecarding, and business intelligence.

The About section of the Cognos Blog states the following:

I’ve been developing financial, accounting, and production reports for the last 20 years. Follow along as I share practical experiences in making Cognos Impromptu and Powerplay have a major impact on how organizations do business. I’ll also talk real life systems development, work philosophy, and more about the kind of people I’ve met along the way.

The Author is none other than Atlanta Dan and his bio reads as follows:

I have been developing financial, accounting, and production reports for the last 20 years. I started as a CPA who fell in love with the Apple and Supercalc. Over the years I have had to master Dbase II, Lotus, MS Office (Excel and Access), SQL, and dozens of other languages to make all kinds of reports work. Powerplay and Impromptu captured me 14 years ago and I have yet to find better reporting tools. I started developing for IWR and PPES 5 years ago. Hand-in-hand with these tools I have been developing the related SQL server queries and objects, including developing and implementing data warehouses, marts, and other data staging techniques to provide the data in the format needed by Cognos Powerplay and Impromptu.

Some interesting articles have been posted to date. Enjoy reading!