Focus on User Groups at Oracle OpenWorld

Anyone who reads my blog regularly might be tired of me praising user groups, but I believe it is worth repeating myself.  The type of information sharing you get from user groups is unique and very valuable, it is important for Oracle to support that, be aware of it, but not interfere.  I have been involved with the Oracle Apps User Group via the GL SIG for several years now but I will never push my agenda, I listen, provide information or presentations that are requested and I learn.  Many of my colleagues will tell you the same.  So Sunday is User Group day at OpenWorld and I look forward to seeing a lot of familiar faces and learning something new.  I have a bit of a schedule crunch this year, 12 months ago I committed to run the 5k “Dolphin Dash” School fundraiser with my 8 year old son, I didn’t think for a minute it would fall on the same date as OpenWorld.  So I have to run a 5k at 9am and then dash into San Francisco to present at the GL SIG for 11am, if I arrive in my running gear, still sweating please accept my apologies.  I will stay around for more of the sessions and always I will be active on twitter, so you can find me that way too.

At the GL SIG I’ll be talking about and briefly showing the new Accounting Hub Reporting Cloud Service, which I am very excited about.  You will also hear from Lakshmi Sampath from Dell about SLA on their upgrade to R12.  The full agenda is below, I hope to see a lot of you there.

—————————————————————————————–

Agenda GL-SIG @ OpenWorld 2014 on Sunday, September 28th, 11.00am
Location – Moscone W – 3005

Agenda

  1. Introduction to the SIG
  2. Proactive support presentation
  3. Sponsor message (Excel4Apps)
  4. Lakshmi (SLA on Upgrade @ Dell)
  5. David Haimes new Accounting Hub Cloud Reporting Service
  6. Open questions

We will be joined by our Oracle colleagues to tell us about ProActive support and their leading practices to deliver content and help to the Oracle user community.
Excel4Apps will be helping us by sponsoring the meeting at this conference.

In the past many oracle apps customers have looked elsewhere for their reporting needs – until now – see a preview of “Accounting Hub Reporting Cloud Service”. See how many finance users are using their favorite tools for reporting – Smartview, Cubes, and related functionality to get their financials.  Fusion Account Hub Reporting Cloud Service is a new subscription service provides out of the box integration with EBS R12 General Ledger for reporting.  This session will provide an introduction to the new service, how it connects, works with EBS data, the reporting capabilities available and what it does and does not support.  Come listen to David Haimes, Senior Director, Financials Product Development t alk about the new service.

Hear what Lakshmi Sampath from Dell has to say about their upgrade to R12. The presentation covers the R12 Upgrade Case-Study at Dell providing details on what happens during upgrade to R12 in various subledgers (PO, AP, AR, PA, FA) with respect to SLA. This presentation will also provide details on strategies for data conversion to SLA model during upgrade, and cover critical lessons learned during the upgrade @ DELL.

—————————————————————————————–

 

Oracle Ebusiness Suite Financials Books

I am often asked what book to read to learn Oracle Financials, there is no simple answer here.  If you get the concepts right everything else will drop into place much more easily than getting overwhelmed with specific details of how to configure every single feature click by click or what every single UI does in detail.  I have listed some of the books available below.  I have given some commentary, but I advise going to amazon and checking out the reviews there or looking in the comments of this post where I hope you will all share your thoughts on the ones you have read.

Oracle E-Business Suite Financials Handbook, Third Edition

I have the first edition of this book, it is very readable and goes over the concepts and major features of all the products in financials, a good starting point if you are new to financials.  It discusses how you would run an implementation project and does not concern itself with step by step guidance on how to set up specific features.  It’s a good book and well researched.

I have not read the third edition in detail yet, anyone who has please feel free to post comments on this post.

Oracle E-Business Suite Financials R12: A Functionality Guide

Oracle E-Business Suite Financials R12

Full disclosure on this one.  Firstly I was given this book free by the publishers to review, secondly I know the author Mohan Iyer, who is chair of the OAUG GL Special Interest Group.

This book is not going to make you an expert in Oracle Financials and ready to get started on a major implementation right away, it does not get into the detailed steps of how to configure all the modules and features. It simply introduces the modules in a way that a business user can understand, diving into a little more detail in some places. I think it is intended to be a guide for a business user considering or already starting an implementation, so they can understand some of the options and choices available and I feel it mostly meets that goal well.

The Oracle General Ledger guide

I purchased this book and I’ve read most of it. It seems to be very comprehensive and accurate on the details but is not adding the value I’d hope for over and above the online help or product documentation.  I would have liked it to see some more concise overviews of features and business cases for using certain implementation choices over others.  That said I’m thrilled to a book on GL and am sure many people will find it useful.

Oracle E-Business Suite Development & Extensibility Guide

Not had a chance to read this one, but it contains information that many, many people will care a lot about.  Let me know if you have read it.

Shining a Light on the Release 12 World

The Solution Beacon crew have produced a number of good publications and have a lot of experience, they focus on what is new in R12 and what is in it for you.  It comes with a recommendation from Floyd Teter, who is a respected friend of this blog.  I have not read this one myself.

If you have any of these books, or maybe you are one of the authors of these books please share your thoughts with the community in the comments section.

EBusiness Suite Legal Entity FAQ

I’ve been preparing these for a presentation at Oracle OpenWorld next week, they were mostly taken from the questions asked by Alyssa Johnson in her comment, but they are very typical questions that I get asked a lot.

What is the difference between the 11i GRE/LE and R12 LE?

  • GRE/LE is upgraded as an LE in R12
  • In 11i GRE/LE was often a dummy LE, not real LE structure and had little use
  • R12 LE has a more robust definition
  • R12 LE is used more by processes and reports across financials

Where does the LE impact R12 processing?

  • Short answer – Tax, Intercompany (AGIS), Global Features

Why should I assign BSVs to my LEs in the Ledger?

  • It is optional, if your BSV is your company code, you have an implied LE there in your GL
  • It helps with some LE derivation for transaction stamping
  • Allows you to run reports by LE
  • May make Intercompany rules easier to define

In 11i, the LE doesn’t really correspond to the true Legal Entities of the Organization (e.g. only one LE is setup even though there are multiple companies). What is going to break in R12 if I leave it that way?

  • Nothing will break if you do nothing and stay with one ‘dummy’ LE
  • You won’t get all the good stuff we talked about earlier

Is there a connection between the LE and the BU?

  • If you map LE to Ledgers / BSV, there is an indirect LE-OU relationship
  • There is a Default Legal Entity for an OU (Default Legal Context) which in some cases(1:1:1) it will be the only LE so it is a direct assingment

If you want to add anything to this, or have more questions then fine the comments section below…

Financials Sessions at Oracle Open World 2008

A lot of people are asking when various sessions are, readers of this blog are probably interested in Oracle EBS financials, Helle posted on Oracle Mix a couple of useful links. I recommend looking at this pdf which lists all the financials sessions including demogrounds, apps lounges, presentations etc.

My session is listed there, I look forward to seeing some of your there.

Thursday 25th, 3:00 p.m.

Moscone West 2006

Are Intercompany Processing and Reconciliation Currently Pain Points for Your Enterprise?

David Haimes, Oracle; Helle Hennings, Oracle

I blogged last year about the meet the Experts Lounge, well this year it has been renamed to Applications Lounge. I haven’t been asked to attend this year, so if you want to ask me any questions or provide feedback you’ll have to come to the session above, find me at the DEMOgrounds, the Blogger Meetup or follow me in twitter, or use this blog all year round – remember customer interaction is not just for Oracle Open World, it’s for life.

Fixed Assests Intercompany in R12

Fixed Asset?

Fixed Asset?

Something I often forget to mention is the enhancement of Intercompany functionality in Fixed Assets (FA) that has been provided in R12. So here is my attempt to explain it, based on an old email discussion with the FA team, I wouldn’t describe myslef as an FA expert, but if there are any comments or questions I might be able to find an FA expert to get an answer. :)

In 11i FA stores reference accounts in two setup entities; Book Controls and Categories. The intercompany Payables and Receivables accounts were stored directly on the book, only the natural accounts segment were stored for these two accounts. The Account Generator definition would combine the natural account with other sources to get a full account combination. Out of the box, those sources were a default ccid which is also on the book and a ccid from the asset assignment. So the balancing segment is derived from the asset assignment, the natural account from the values on the book, and other segments from the default account.

The intercompany would kick in for two transaction types “Transfer” and “Unit Adjustment”. However, other transactions could result in intercompany impacts, but they would not be generated in FA so GL would do the balancing when the accounting was posted there.

So in R12 FA uses the AGIS Intercompany balancing feature, which is Continue reading

AGIS Out of the Box

outofthebox.jpg

When I was about 10 years old I got a new electric train set for Christmas, but before I got to play with it I had to pinch a plug from one of my siblings toys and fit the only available (and dangerously mismatched) fuse in it. Then I had to read a complicated set of instructions to assemble a delicate set of parts and it was a minor miracle that I had it working before the New Year.

Now when I buy something new, the first thing I do is open the box, turn it on and press buttons to work out how to use it, if I get stuck I maybe look to see if they have a quick start guide. Consumer goods manufacturers make things very intuitive and ready to work right out of the box these days and we have grown to expect that. Remember that iMac add? step 1: plug into power, step 2: plug into a phone line, step 3: – there is no step 3! Wow can I have an ERP system like that please?

When designing AGIS for R12 we tried to minimize the time it would take to get started entering transactions in an initiative we internally called ‘AGIS out of the Box’. I have to give credit to this idea to my former bosses Joe and Terrance for initiating this, but the whole team stopped, sat down and thought about what we could do to allow users to open the box and start using AGIS right away.

We came up with a few ideas

1) No profile options Continue reading

Multi-Org Access Control

Written by David Haimes

accesscontrol.jpgMultiple Organizations Access Control or MOAC (pronounced MOW-ACK) to use the seemingly obligatory acronym, is a powerful, yet simple to implement feature available in R12.

Implementors spend a lot of time figuring out how to configure their Legal Entities, Ledgers and Operating Units. There are a number of options some restrictions, depending on what features you want to implement and where you are. See my earlier posts on Legal Entities and Operating Units for details on that. However it is worth remembering that change is the Status Quo (No, not the band of rocking all over the world fame – it’s latin, look it up) and flexibility is important, what was the optimal way to organize your transaction processing yesterday may not be right today. Many companies are creating shared service centers to centralize processing of financial transactions and a single user may process transactions on behalf of many different Operating Units(OU).

So MOAC allows you to create a security group which can contain many operating units and assign that to the User’s responsibility. All the forms Continue reading