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.

Financial Services Accounting Hub (FSAH)

Financial Services Accounting Hub or FSAH (pronounced F-saa apparently) is a great product and is not only for Financial Services companies either, I understand we’ll sell it to anyone.

From a (very) high level perspective it allows you to use Oracle SLA and GL to perform the accounting for third party applications. Companies the Financial services industry tend to build a lot of highly complex applications (e.g. loan systems, trading systems) in house, but they want the final accounting of transactions form these disparate system to end up in the same place and it will be nice if they can re-use the same accounting rules too. Continue reading “Financial Services Accounting Hub (FSAH)”

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 “AGIS Out of the Box”

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 “Multi-Org Access Control”

Intercompany Invoicing in AGIS

One of the key features introduced with the new Advanced Global Intercompany (AGIS) in R12 of Oracle E-Business Suite is the ability to create documentation for Intercompany transactions. The correct documentation is required in many countries for Intercompany trading, this essentially means I need to provide a Receivables Invoice for the Legal Entity Providing the goods or service and a payables invoice for the receiving Legal Entity. These invoices should have any taxes that are applicable in the jurisdictions, for that type of service.

We do not firce you to create invoices for all Intercompany Activity, you can still create just a GL Journal entry if you prefer. The AGIS transactions flow is illustrated in the diagram below.

invoice-required.jpg

You can see that we check if invoices are required and there are two places that we look for that. Continue reading “Intercompany Invoicing in AGIS”

Why do I need another period ?

In R12 we introduced AGIS periods that control the transactions entered in AGIS, this is a feature that is often misunderstood. The usual question is – Why do I want another period? I’ll give some ideas why you might want one, but if you decide you don’t need one, don’t worry we made it optional so you don’t have to use it. If you decide to use it just pick one of your GL Calendars to use for your Intercompany periods, if you never enter a calendar in the system options periods will not be enabled and you can enter transactions whenever you want with no interference from the system.

So, I ask again – Why do I want another period ? Continue reading “Why do I need another period ?”