Catch me at Oracle OpenWorld 2013

Just a quick post to list out the sessions I’ll be involved in presenting this year at Oracle OpenWorld.  I will also be active on twitter as we approach the conference and during the week itself, look for the #OOW hashtag and follow me.

Oracle Fusion Financials Cloud Service and Oracle Fusion Accounting Hub [CON9815]  – Wednesday, Sep 25, 1:15 PM – 2:15 PM – Marriott Marquis – Foothill F

This is part of the Partner Network Exchange, I am pretty excited about it because I firmly believe we can enable partners to provide fast, and high quality implementations for customers with our Rapid Implementation tools and the ERP Cloud service.

Get up and running on Oracle Fusion Financials at the speed of the cloud with the Oracle Fusion Financials rapid implementation tools. Upload tools enable you to upload repetitive entries such as the chart of accounts directly from Excel to Oracle Fusion Financials Cloud Service. Oracle Fusion Functional Setup Manager guides you through the essential steps for setting up and configuring your applications, using the most-common features and best practices considerations. Also discover how Oracle Fusion Accounting Hub addresses common problems such as integrating accounting from Oracle as well as non-Oracle applications. All of this will enable your customers to reap the benefits of Oracle Fusion in the cloud or on-premises faster than ever.

Oracle Fusion Applications: Social Collaboration and Mobile for ERP [CON9553] – Tuesday, Sep 24, 3:45 PM – 4:45 PM – Moscone West – 3022

Social and mobile are areas where the enterprise software industry is seeing some exciting innovation that drives productivity and business benefit.  I’m presenting with John Killen and we want to show you how your organization can make best use of the features in Fusion ERP suite.  We have a lot of product to show, so there will be more demo and less powerpoint, there will be no snoozing in this session.

Learn how Oracle Fusion solutions for social networking and mobile can help ERP organizations boost user productivity and increase user adoption. Oracle Fusion ERP applications are optimized for today’s collaborative, hyperconnected, mobile workforce and enable new levels of productivity and collaboration for finance, procurement, and project portfolio management teams. This session highlights the ways your company can increase performance and alignment across ERP organizations and related business processes.

I will also be talking on Sunday at the OAUG GL SIG meeting, the topic will be the upgrade to Ebusiness Suite R12 Subleger Accounting (SLA).  Which is a hot topic whenever I talk to customers, there is a lot of power in SLA and I think people are pretty excited about it and realizing some quick gains from it’s power.

I’m going to be pretty busy preparing for these presentations, but I’d like to find time to blog about some of the other things I’ll be attending or I think are interesting to followers of this blog.  Watch this space.

Oracle OpenWorld: The Fusion Apps WOW factor

This certainly felt like my busiest OpenWorld ever, but one of my most enjoyable.  I’ve already blogged my What, Where and When and I pretty much did all I planned to do.  I spent a lot of time at the Demo Booth for Fusion Financials and really enjoyed people’s reaction to Fusion Applications.  My favorite incident was when I was showing to an Oracle representative and his client who was an experienced Russian lady who had a lot of questions and then wanted to see a demo, all my answers to her questions had to be translated so she would mostly be looking at the interpreter.  However during the demo  she just looked over at me and smiled instead of looking at the interpreter and the amazement on her face said it all.  It seems the WOW factor needs no translation.

Happy Fusion – Our Time is Now

robot clockWhilst I was visiting the Oracle offices in Hyderabad recently, the Fusion development team gave me the gift in this photo and that’s what prompted this post. Fusion has, and continues to be, an incredible journey. Building a full suite of enterprise applications from the ground up is certainly a challenge, but the learning from the continual customer interactions and the amazing people and products from the many companies that have joined Oracle during the acquisitions, has been an immensely rewarding and enjoyable and enriching experience. One thing that has been a little frustrating is that I was not able to blog in detail about Fusion while it was not released, but as it is now generally available, the time is now. The Oracle Applications Blog has relaunched recently and we’ll see a lot more content there, I saw a really nice paper by infosys on Fusion Financials and Joe (my former boss and now much respected colleague in the strategy team) has been active on the Fusion Financials strategy team blog and now I am ready to get my opinions and interpretation on things out there. This is a very exciting time for me, because I believe the team has done a phenomenal job of building Fusion Applications.

So over the next weeks and months I hope to bring you some interesting Fusion Applications posts and I will continue to mix in Ebusiness Suite and general tech topics as always. You will also see me getting a little more active on twitter again so please follow me there too and let me know what you think and what you would like to here more details about.

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…

Want more on Legal Entities?

I was perusing the statistics that wordpress.com provides for this blog and was interested to learn that the most commented on post, with a whopping 69 comments, is the classic from November 2007 – How do I define my Legal Entities? .  It has also received 18,449 page views which is the second most viewed post on this blog.  My conclusion is that people are interested in this topic and want to learn more, so I thought I would mention the OAUG GL SIG meeting at OpenWorld where I have been asked to make a short presentation about Legal Entities, essential details are:

 

Title: OAUG General Ledger SIG
Time Sunday, 04:00 PM, Moscone West – 3005
Length 1 Hour
Abstract: The OAUG General Ledger SIG is a worldwide community of professionals engaged in the use of record-to-report business processes. Group members are business users, consultants, and support members engaged in the use of Oracle General Ledger.

This session focuses on Oracle Fusion Financials’ General Ledger feature, the Oracle E-Business Suite Release 12+ update, and the Oracle Financials release roadmap.

I have just started to think about preparing slides and I thought that rather than actually work on them, I would blog and see if anyone had ideas on the type of thing I should talk about (the hip crowd would call it crowd sourcing).  It’s been almost 4 years since that post, so let me know in the comments what more information you would like on Legal Entities in Oracle Apps.

The comments section is just down below, past all the widgets asking you to like the post and share it…

New Oracle Financials Blog

There is a new Financials blogger on the block and her name is Theresa Hickman.  I have been fortunate to work with Theresa during her time managing the product management teams for General Ledger and Accounts Payable products and her time working in the financials strategy team, she’s very knowledgeable,  dedicated and a big asset to Oracle.  Already she’s doing some good stuff in her new role in Financials Product Marketing.  So check out her Financials Blog, where she covers Oracle product items and general finance topics such as latest news on IFRS.  She also has a twitter account @OracleFMS which is worth following if you even have a passing interest in finance topics.

If you have any other blogs of interest or tweeters, please share them with all the readers in the comments below.

A few GL R12 Ledger FAQ

Here are a few questions about R12 I have been asked a number of times, and if a few people asked me, I am guessing that even more people are searching from Google, (or maybe even Yahoo or Bing) looking for answers.

1) What is a Ledger?  What happened to my Sets of Books?

Your 11i Set of Books is now an R12 ledger, any 11i sets of books you had will be a ledger after you run the R12 upgrade.

2) Why did you change the name?

I am not fully aware of the history of the decision, but a Ledger is a much better description and matches the business terminology more closely.  Also with the introduction of Ledger Sets in R12, we’d have had a clumsy  ‘Set of Books Sets’ term to deal with.

3) Does the new table gl_ledgers replace gl_sets_of_books table.

Yes.

4) So what about my custom reports that query gl_sets_of_books table or gl_sets_of_books_v view

No need to change those.  For backward compatibility we created a view gl_sets_of_books which references the gl_ledgers table.  gl_sets_of_books_v is also modified to reference gl_ledgers table.

5) What happens to the sob_id, are these primary keys preserved?

Yes, the sob_id from 11i will become the ledger_id you see in R12

6) I see Ledger_id in the gl_interface table, do I have to update all my feeder programs that write to that to populate ledger_id instead of sob_id?

No.  GL_INTERFACE is backward compatible, the sob_id column is still there and ledger_id is optional, if Journal Import does not find any value in ledger_id it will use the sob_id

I have not got into any of the powerful new functionality that is introduced as part of the Ledger Architecture, or discussed what you can do with Ledger Sets, those items are for another day.  If you want to read about those now you should look at the document below.

Oracle Financials and Oracle Procurement Functional Upgrade Guide: Release 11i to Release 12 (Part No. B31543-01)

Financial Services Accounting Hub(FSAH) is now called Financials Accounting Hub (FAH)

The Financial Services moniker was always misleading because there is nothing specific to the Financial Services industry in the product, now this has been fixed and the official name is Financials Accounting Hub. So that one is cleared up.

I have had a number of people asking for more details on this product, you can start with Oracle’s data sheet or the link above to the oracle.com FAH site. There is a nice article introducing FSAH and SLA on the Oracle Consulting Solutions site by Sven van Leemput, this is a a good read. There is also presentation on slideshare from capgemini and kpn telecom about their experience with the Accounting Hub, nice to see some practical examples, even if it is at a high level. I have not done a metalink search recently, but I am sure there is plenty of information there too for those with access to metalink and of course there are the OTN forums.

Anyone else have any good sources of information – please share them via the comments.

FSAH and AGIS Intercompany Implementation thoughts

Written by David Haimes

As Intercompany transactions are very likely to cross systems they are a good candidate for integration in a ‘Hub’ of some sort.

In R12 the Financials Services Accounting Hub (FSAH) allows integration of third party systems to Oracle and is incredibly powerful and flexible.

Let’s use a simple example:

Company A and B both use two different Ledgers. A Sales Invoice is issued by Company A (to Company B) for $5,000

The accounting needs to be created as below, they need to be booked with the same accounting date in the same period.

In Company A

Debit Intercompany AR $5,000
Credit Intercompany sales $5,000

In Company B

Debit Expense or inventory (per content), $5,000
Credit Intercompany AP, $5,000

So there’s a number of options that come to mind (in no particular order).

1) Using Oracle Accounting Hub you can account for transactions form third party systems, it uses the Subledger accounting engine to process accounting events defined for the third party system. If your invoice systems are third party applications, you could create 2 events (one for each company/ledger/party to the transaction) for the sales invoice and get the full accounting out of the single system integration.

2) Enter these transactions in AGIS, the specific accounting will be entered/generated and approvals from company A and B obtained before AGIS either books it direct to GL or generates the Invoice for company A and B if required.

3) It may not be ideal to force users to navigate to a different screen (or change some import process, EDI, XML feed etc) to issue Intercompany invoices from other invoices as in 2) above. So continue to enter in your regular sales invoice system but run a process which detects an invoice is Intercompany and cancels it, then generates a transaction for it in AGIS (via the Open Interfaces) or FSAH.

I don’t think any one of these is right for all situations, detailed analysis of the particular implementation environment and requirements needs to be done to figure out the best approach. If you have any thoughts, better suggestions or experience then please share them in the comments.

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.