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


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”

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.


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”

Using BIP for Interactive Reconciliation Reports

Written by Bidisha Silveira

I’m going to give a little more detail on how the Interactive Financial reports David described here were put together. In 4 simple steps (with pictures!)

Step 1:

The Reconciliation Data Extract background program is submitted which collects all the data and generates an xml file

Step 2:

To view the reconciliation data we use a page built in OAFramework. The BI Publisher region to view the formatted report is embedded in this page.

When you click submit the xml file generated from Step 1 along with details of the layout template and the type of output required (eg Excel or html or pdf) is passed to the BI Publisher engine. The BI Publisher engine processes this information and displays the formatted output on the current page.

Recon 1

Now you are ready to go. The first report displays the summary of the Payables and Continue reading “Using BIP for Interactive Reconciliation Reports”

Welcome Rohit and Bidisha

rohit2.jpgI am very happy to say we have some new contributors to the blog, who I hope will be posting now ad again to help keep this blog fresh.

Rohit Kathuria is a product manager here at Oracle, working specifically on the Advanced Global Intercompany System (AGIS) product in R12.

Rohit was the main author of this article on Intercompany Balancing and I hope he’ll be blogging here about some common questions and gotchas that come to him from the field and interesting enhancements or features that are added.

He was a Company Secretary by profession and a post graduate in commerce. His home town is Bareilly, a small town in Uttar Pradesh. Like Anthony from the AppsLab team he enjoys Table Tennis.

Bidisha Silveira is too shy to let me put a picture of her, she is one half of a husband and wife team working in Apps development in our UK development centre (if it was in the US it would be a center). She has worked on my team for a number of years and knows the real nitty gritty technical details of AGIS. She’s writing the follow up piece to my overview of how we used BI Publisher to create interactive online reports, which I promised to Tim back in December

New Grant based Security in AGIS


Managing a large number of responsibilities can become a complex, time consuming and expensive activity. It is also very frustrating for users if they have to constantly switch responsibility if they have a number of roles, this is a big issue in 11i Global Intercompany System as you could only have one Balancing Segment Value (BSV) per GIS responsibility and there can be a large number of BSV often with one person responsible for entering and approving intercompany transactions for many bsv. For example there may be a controller responsible for approving all transactions for the dozens of EMEA subsidiaries.

When we created the new Advanced Global Intercompany Product in R12 we set out to address this issue and came up with a whole new transaction security model. Continue reading “New Grant based Security 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 ?”

Friday Night Writes

My primary reason for starting this blog was to discuss issues customers asked me a lot at about at Open World and on various forums. My rationale being that if I blog about our products we might help people understand them and a) Make informed choices implementing them, get more value from them and maybe log less support calls and bugs for us to look at; b) Learn how people use our apps, or why they can’t use them and be in a position to engineer better apps. What I didn’t have in mind was being able to sound off about whatever I want to on a Friday night and people actually read it and link to it from other blogs, which is dangerous because it just encourages me. I was also encouraged this week reading Meg’s girl on a rant, nice to see other people getting things off their chest too. The last few days I’ve been thinking about what I wrote about Google last week. Why? Because on Monday I was asked by Terrance if I could go to the Google office and talk to them about Intercompany. Doh! My first question was, Continue reading “Friday Night Writes”

What Exchange Rate to use for Intercompany

Leslie posted some excellent comments, which touched on the exchange rates to use on intercompany transactions, a very interesting and complex topic. I have discussed this at length with Seamus Moran many times, he has educated and enlightened me and I use an example of his here.

Consider Top Hat Global Corp

Intercompany Reconciliation Reports just got Interactive

In R12 the Advanced Global Intercompany System was introduced and one of the main goals was to make the reconciliation process more efficient. Intercompany is often the top barrier to a fast period close, because you have to be sure you eliminated it all to zero, so your parent company does not report a profit from trading internally. Fail to do this and you might go to jail, I have no legal training but when it comes to accounting irregularity I understand claiming it was an honest mistake is not much of a defense. Continue reading “Intercompany Reconciliation Reports just got Interactive”