Sunday, January 10, 2016

Financial Accounting Hub (FAH)


What is Financial Accounting hub (FAH)
The Financial Accounting Hub is an integration tool which enables customers to integrate data from Non-Oracle source systems or sub-ledgers such as Billing/Banking, any 3rd Party Accounting or Insurance systems.  Specific rules can be applied to the data as it passes through the hub into the Oracle General Ledger. Oracle Financials Accounting Hub enables the transformation of information from disparate systems into a centrally and consistently maintained accounting repository. The core strengths of Oracle Financials Accounting Hub include its ability to create a single source of accounting truth for multiple external and legacy systems using business user-defined accounting rules. 
Oracle Financials Accounting Hub allows the integration of External Application by centralizing the definition and maintenance of accounting rules in a business user orientated repository. Accounting journals are created with a rules transformation engine, validated, and stored in an auditable format in a single location.  FAH acts as the accounting engine for any sub-ledger (Oracle or non-Oracle), create adjusting journal entries, and provide drill back from General Ledger (GL) to FAH,

How Does FAH Works:
FAH is an uptake of SLA. It is basically standalone Subledger Accounting (SLA), it allows to use Oracle SLA and GL to perform the accounting for third party / External applications.

Using Accounting Method Builder (AMB) Tool, FAH Efficiently Create Accounting for Multiple Heterogeneous Source Systems Oracle Financials Accounting Hub provides a flexible rules builder for business users to create accounting rules once and deploy them many times across different external and legacy systems. Legacy systems that do pre-accounting can pass journals through the hub to validate and store the accounting in the accounting repository for a single, reliable, enterprise wide view.




Financial Accounting Hub (FAH) V/S Sub-Ledger Accounting (SLA)

  • The Financial Accounting Hub (FAH) is very similar to the Subledger Accounting product (SLA). In fact, looking merely at the functionality, there's no difference between FAH and SLA.
  • The only distinction between both products is that with SLA you get seeded event models for all Oracle Subledger modules that require accounting and if desired one can use the components from these seeded event models to create your own customized Subledger Accounting Method.
  • While with a FAH organizations get the possibilities to register external applications as Subledger, from which they can build their own event model, and use the SLA functionality to create accounting for the events originating from their external applications.


FAH Event Model:
FAH/SLA uses an Event Model consisting of Event Entities with underlying Event Classes, and at the lowest level we have the Event Types which in their turn belong to the Event Classes.
The accounting is entirely event-driven meaning that for each Event Type you can define how you would like the accounting to be created. This is done using Journal Line Types, Journal Entry Descriptions and Account Derivation Rules which tie together in a Journal Lines Definition. Conditions can be applied at various levels, and optionally you can use Mapping Sets and/or Supporting References.
For each Event Type such a Journal Lines Definition can be build. These Journal Lines Definitions roll up into an Application Accounting Definition.  The Application Accounting Definitions are grouped together under a Subledger Accounting Method, which is the component that gets tied to the ledger (In R12 a ledger consists of calendar, currency, chart of accounts and Subledger Accounting Method).




FAH transaction Flow:

FAH allows to use Oracle SLA and GL to perform the accounting for third party applications. Using Accounting Method Builder (AMB) Tool, The Application Accounting Events, Accounting events of source External application are mapped and stored in the SLA tables. External/Source Application’s accounting event’s for, accounting attributes and transactions supporting references are kept in FAH transactions objects.  When user submits accounting program,

  • Accounting program fetches the applicable accounting events from SLA Tables depending the External application and Event model.
  • The Configured Accounting definition rules are then applied and Loaded FAH transactions objects
  • journal entries for the External Application are then created and stored in the SLA Tables.
  • SLA journal entries for External application are transferred to GL using standard Oracle Transfer to GL Program.

1 comment:

  1. Hi,

    We would like to automate SOURCE SYSTEM REGISTRATION (SLA registration) in FAH.

    Take the details as input in txt file or excel and create source system in SLA system.

    I would like to know how it can be done using PLSQL code /API.

    Please suggest/help



    Thanks & Regards,

    Prasad S Billahalli

    ReplyDelete