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.

Author: David Haimes

I'm Senior Director in the Oracle Research and Development Organization, with close to 20 years working in various roles on the development of the Financial Management product suite.  Since the summer of 2016 my focus is exclusively on working with customers and longer-term design work, particularly around next-generation functional and technical architecture. My task is to figure out NOW what the financial management system of the next 3, 5 or more years should look like and start working toward it.  At the moment the majority of my time is spent working on Blockchain or Distributed Ledger Technologies (DLT), leading the effort for all of SaaS applications.  I'm also interested in AI, Machine Learning and new UX and interaction paradigms such as chat bots. I started out in Oracle UK and found my way out to Oracle's Redwood Shores, California HQ in May 2000.  My previous role was product owner for Fusion Accounting Hub, General Ledger, Intercompany and Legal Entity products in Oracle Fusion Financials and eBusiness Suite General Ledger. I have also worked on EMEA Globalizations, Federal and Public Sector Financials, XML Payments and a variety of projects on other products down the years.

20 thoughts on “Financial Services Accounting Hub (FSAH)”

  4. 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

    Like

    Reply

  6. 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.

    Thanks

    Darma
    (fellow Brit now in the US!)

    Like

    Reply

  7. Darma,

    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.

    Thanks,
    David

    Like

    Reply

  8. 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.
    ex:
    structures:
    Primary book
    BR_COMPANY >>> Balancing Segment
    BR_ACCOUNT>>> Natural Account Segment
    BR_COST_CENTER>>> Cost Center Segment
    BR_INTERCOMPANY>>> Intercompany Segment
    BR_PROJECT
    BR_RESERVE

    Secondary book
    BR_PLANT >>> Balancing Segment
    BR_ACCOUNT >>> Natural Account Segment
    BR_COST_CENTER >>> Cost Center Segment
    BR_PRODUCT
    BR_INTERPLANT >>> Intercompany Segment
    BR_TRANSACTION
    BR_PROJECT
    BR_RESERVE

    HOW TO CREATE MAPPING WITH 2 Balancing Segment DIFERENT

    Thanks,
    Marcelo

    Like

    Reply

  10. 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

    Like

    Reply

  11. 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
    Marcelo

    Like

    Reply

  13. BULK API FOR CREATE EVENTS

    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?

    Like

    Reply

    1. 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

      Like

      Reply

    2. Hi Raju,

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

      Dinesh

      Like

      Reply

  15. 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)
    xxx.xxx.60000.01.xxxxx cost is classifed as G&A
    xxx.xxx.60000.02.xxxxx cost is classifed as a selling exp

    Could OFAH be used to maintain a rule like this?

    Thanks in advance – Brandi

    Like

    Reply

  16. Hello Friends,

    I dont know whether its right to post this here but as I am struck I would like to seek your assistance in this, we are currently in hiring stage for an Oracle Apps Financial HUB consultant for one of my clients in Riyadh, Saudi Arabia. Can any one help me where can I get these resources from?

    Looking forward for your valuable suggestions.

    Regards,
    Adnan Khan

    Like

    Reply

Leave a comment