Monday, May 12, 2008

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. Hence the concept of an accounting hub.

If you are using FSAH on R12, you can also utilize all the new AGIS features introduced in R12 and that could help you to apply common intercompany processing rules across your entire business too.

I have had a few discussions with customers asking if AGIS could be used as a hub for all intercompany trading across many ERP systems and the answer is very much so, that is something that we had in mind when building the product. You should be able to push transactions from multiple Oracle instances, even on different versions and throw in an SAP or Peoplesoft instance too if you want. There will be some integration work, but we use standard interfaces, services, API and also make use of the Workflow Business Event system to make this process as easy as possible.

UPDATE(April 27, 2009): New post with links to more information on the Accounting Hub.


David Torbett said...

10 year veteran and you still can't spell instances :)

David Haimes said...

Mr Torbett - nice to hear from you, I corrected the spelling mistake. It's a shame you aren't still around at Oracle to catch coding errors...

S. Venkataramanan said...


hina said...

i have knowldge of Oracle 6i and basic accounting... now i have the job as developer of Oracle Financial R12 in a company... can you guide me of any beginners tutorials that guide me as i dont know much about Financial R12. I have studied Oracle FInancial Concepts but i want sumthing that elaborate the Financial module use and setup with example please... i will be really thankful

David Haimes said...

I'm afraid to say there is no shortcut to learn financials - I am still learning after more than 10 years.

I would look at the resources I mention in this post

Also look at the blogroll, has some very good detail on features and steps to implement, but there are other blogs too.

Darma Adiapen said...

Hi David,

Struggling to get an SLA set up that bounces off our Inventory Item Category Key FlexField. Seems none of the seeded sources point to the Flexfield.

Any help would be greatly appreciated.


(fellow Brit now in the US!)

David Haimes said...


Always nice to hear from a fellow expat.

The SLA sources are built and maintained by individual product groups. So the Inventory team would decide what the expose in their source. You can log an SR to request they add them if they are not already there.


Marcelo said...

we created 2 books, 1 fiscal book (BRL) and 1 secondary ledger (US$) with calendars, account structure and different currencies. We are not able to continue the setup because it is requested a mappi
ng from the main ledger for the secondary ledger. The segments with different account plans.
Primary book
BR_COMPANY >>> Balancing Segment
BR_ACCOUNT>>> Natural Account Segment
BR_COST_CENTER>>> Cost Center Segment
BR_INTERCOMPANY>>> Intercompany Segment

Secondary book
BR_PLANT >>> Balancing Segment
BR_ACCOUNT >>> Natural Account Segment
BR_COST_CENTER >>> Cost Center Segment
BR_INTERPLANT >>> Intercompany Segment



David Haimes said...


Are you talking about Mapping sets in GL?

I assume BR_PLANT and BR_COMPANY are two different value sets?

Marcelo said...

Hi David,

Thank you for answering.

I want to create the mapeamento in the setup of SLA.
The mapeamento was requested because I use diferetes Accounting Chart of Accounts
The problem is: they created segments different balanceadores.
In the Primary my Balancing Segment is BR_COMPANY
In the Secondary my Balancing Segment is BR_PLANT

Thank you very much

Marcelo said...

Hi David,

Thank you for answering.

I want to create the mapping in the setup of SLA.
The mapping was requested because I use diferetes Accounting Chart of Accounts
The problem is: they created balancing segments different .
In the Primary my Balancing Segment is BR_COMPANY
In the Secondary my Balancing Segment is BR_PLANT

Thanks again

Abhijit Poddar said...

Appreciate if you have any good document on Financial Services accounting hub.

David Haimes said...

I just wrote a new blog post on this

Raju said...


We are trying to generate reversals by creating data in header and line level transaction objects in Oracle Financial Services
Accounting Hub Implementation Guide - B14420-02, page 3-86 under Accounting
Reversal Examples (Example 1 Line Accounting reversal Only) and then calling
the create event API.

We noticed that if we call the XLA_EVENTS_PUB_PKG.create_event, a new event is created with a entity_id value = entity_id value present in the original event and then on running the create accounting the reverse journal entry is created with accounting appropriately reversed.

However if we call the xla_events_pub_pkg.create_bulk_events then a new event is created with a new entity id which is not equal to the original event and hence when we run create accounting, a new journal entry is created with accounting similar to the original journal and not the expected reversal.

In both cases we have populated a transaction number value equal to the transaction number of the original event in the header transaction object.

Is this an expected behavior for the create bulk events API?

Nicki said...

We had exactly the same problem. You cannot use the bulk create when creating a reversal. You have to use xla_events_pub_pkg.create_event

David said...

I wanted to clarify - what is entity_id in the XLA_Creation package? How is it generated?
Pls tell me.

Dinesh said...

Hi Raju,

Can you mail me the create_bulk_events code you wrote, i am new to Oracle apps.
Thanks in advance..


Brandi said...

Question about functionality of OFAH:

Can I put rules in OFAH that assist me with reporting from the general ledger?

We have a 5 segment account combination. When natural account segment is combined with certain other segments the entire combination is reported as one type of cost, when that same natural account segment is combined with different other segments the entire combination is reported as different type of cost. These segment combination mapping is done in FSG.

Example again (natural account is third segment) cost is classifed as G&A cost is classifed as a selling exp

Could OFAH be used to maintain a rule like this?

Thanks in advance - Brandi

Sridevi K said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.