What a difference a year makes


Written by David Haimes

This blog turned one year old this week, so a short review of the year is in order.

I started this blog after Open World 2007, mostly as a way to put answers ‘out there’ to the questions I was being asked multiple times during the conference. I was hoping to do a couple of posts a week and have managed a total of 74, or 1.4 per week, which considering I have got a lot more responsibility at work than 12 months ago I’m pleased with. Most of all I enjoyed the conversations, there have been 400 comments including one from Charles Phillips (indirectly) but I didn’t hear form Larry when I posted a picture of his Yacht which incidentally gave me by far my highest day of hits, the majority coming from Digg.

What has pleasantly surprised me about blogging is how much I have learned in the past year from the comments on the blogs and from following the plethora of other excellent Oracle bloggers that a year ago I didn’t really know existed. I’ve also spent a lot of time on twitter, following a lot of interesting, entertaining, knowledgeable and helpful people many of whom are also bloggers.

So all in all a good first year and now I look forward to the next one and wonder what the stars have in store for me over the next 12 months…

One Laptop per Child – the perfect gift

XO Laptop
XO Laptop

Written by David Haimes

I blogged some time ago about the One Laptop per Child Foundation and how myself and others had taken part in the give one get one program last year. I think the XO laptop is an amazing machine and more importantly I fully support the goals of the foundation.

I got an email and a message to thank me for giving the laptop and as it suggests I will tell 100 people (I hope I have that many readers) and be taking my XO laptop to work this week so I can show people the machine and spread the word about the excellent work the foundation is doing – feel free to drop by my office to check it out. If you want to give then you can do this at www.amazon.com/xo

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.