The Financial Services moniker was always misleading because there is nothing specific to the Financial Services industry in the product, now this has been fixed and the official name is Financials Accounting Hub. So that one is cleared up.
I have had a number of people asking for more details on this product, you can start with Oracle’s data sheet or the link above to the oracle.com FAH site. There is a nice article introducing FSAH and SLA on the Oracle Consulting Solutions site by Sven van Leemput, this is a a good read. There is also presentation on slideshare from capgemini and kpn telecom about their experience with the Accounting Hub, nice to see some practical examples, even if it is at a high level. I have not done a metalink search recently, but I am sure there is plenty of information there too for those with access to metalink and of course there are the OTN forums.
Anyone else have any good sources of information – please share them via the comments.
Filed under: Oracle Financials | Tagged: financials, Oracle, Oracle Applications, Oracle ERP, Oracle Financials, SLA
Stumble It!
[...] 27, 2009): New post with links to more information on the Accounting Hub. Possibly related posts: (automatically [...]
Hello David:
What is the relationship between FSAH and HFM from Hyperion? Both seem to be fighting in the same space since both
1. consolidate
2. apply series of rules
3. are used for reporting.
I am not an expert on HFM(it’s on my list to investigate further, it is tough to keep pace with the acquired technologies and functionalities) but I certainly think the spaces are distinct.
Here’s my take. The three points you list may be correct, but it is what the consolidate, apply rules to and report on that is different.
1)Consolidate
FAH – consolidates transactions from multiple transaction systems into a single accounting system.
HFM – consolidates accounting entries from multiple accounting systems
2)Apply Rules
FAH – rules are rleated to how to account for a transaction based on it’s attributes
HFM – Rules are around how to consolidate, e.g. % ownership, etc
3)Used for reporting
FAH – Subledger reports
HFM – Financial reports, consolidate income statement etc.
David,
Thanks a ton for the information on AGIS. I am currently working on an AGIS implementation and have to confess that I use your blog as my ‘bible’ on the product. The UG comes next :)
Apologies for posting this question on the FCH topic, but didnt know if you responded to comments on AGIS threads anymore.
On GIS, we had the ability to derive the recipient’s accounting from the initiator’s accounting (copy from functionality). This seems to be missing in the AGIS product. I believe i have looked all the options under the SLA engine (Trn A/Cing defns) for a method to do this without much success. Is this functionality available in AGIS? If not, what is the rationale in removing a functionality in the newer version of the product?
rgds
Hari
Hi Hari,
Thanks for the kinds words on my blog, I do try to answer comments on all posts quickly and certainly monitor them daily, so feel free to comment on any post.
As for the move to SLA Transaction Account Builder in AGIS, this was a decision to take advantage of the very powerful rules definition and derivation available in SLA and also to have a more standardized and centralized way to define rules for accounting. We did not want to upgrade or create a new account derivation featue that users have to know about.
I will ask around about how to get the effect you’re asking about to see if there is a way it can be done – or any other readers feel free to share your experience in these comments…..
Hi,
I am very well aware of the Oracle SLA module(Subledger Accounting). I was also going thru the Oracle FAH (financial accounting hub) but surprisingly I find that it is exactly similar to the SLA in every single feature, I mean regarding the AMB, TAB etc. I see all the tools,features like application accounting defn, application method builder, the entity model etc in both the products.
I am not sure what is the difference between these two products. If someone can please point out the difference, no matter how subtle that would be really helpful.
Thanks,Lucky.
Hi Lucky,
The technology leveraged by FAH and SLA is indeed exactly the same. The difference is within the way you’re allowed to use the technology.
SLA offers seeded Event Models (including Event Class Options) and Application Accounting Definitions for E-Business Suite subledger applications. With SLA you can build customized Subledger Accounting Methods (including customized JLTs, ADRs, JLDs, AADs,…) for E-Business Suite subledger applications, while you are not allowed to make any changes to the seeded Event Models / Event Class Options. In case you do come across a requirement in this last area (e.g. an additional Source is needed), then Custom Source functionality can be used for that.
FAH requires an additional license, and basically FAH is standalone SLA: you get the SLA technology but you don’t get any seeded building blocks, because FAH is intended to create accounting based on data which resides in external (non-E-Business Suite) applications. So with FAH you create the Event Model(s) and AAD(s) for external applications entirely from scratch.
Summary: SLA deals with the E-Business Suite subledger applications, while FAH deals with external applications.
Hope that clarifies.
Regards,
Sven
Hi David,
Thanks for taking time to answer my question.
We are on 12.0.6 and my requirement is to have a liability line for each expense and tax line with some segment values coming from the expense line distribution account.
I was able to achieve having one liability line for each expense line and tax line using SLA (custom account derivation rules, custom JLD,custom AAD and custom SAM) . I was able to derive
some segments of the liability lines associates with expense lines sucessfully but not able to get the same values on the liability lines associated with the tax lines.
I created one AP invoice with 3 lines and associated 3 VAT Tax codes with different tax percentages for each expense line , which creates 3 different tax distributions in AP before the “create
accounting process”
On the AP Invoice distributions.
No. Type Entity Account Cost Center Interco Project Equity
1 Charge XCOA xxxxxxx 72OXLFTG 0000 XXXXXX0001 C001
2 Charge XCOA xxxxxxx 72OXLFTG 0000 XXXXXX0001 C002
3 Charge XEID pppppppp 72OXLFTG 0000 XXXXXX0004 C008
4 Tax XCOA zzzzzzzz 00000000 0000 XXXXXX0001 C001
5 Tax XCOA zzzzzzzz 00000000 0000 XXXXXX0001 C002
6 Tax XEID zzzzzzzz 00000000 0000 XXXXXX0004 C008
After running the create accounting process, with custom ADR, I was able to get the project and equity segments from the expense lines to the liability lines associated with the expense
lines.
No. Type Entity Account Cost Center Interco Project Equity
1 Charge XCOA xxxxxxx 72OXLFTG 0000 XXXXXX0001 C001
2 Liability XCOA yyyyyyyy 00000000 0000 XXXXXX0001 C001
3 Charge XCOA xxxxxxx 72OXLFTG 0000 XXXXXX0001 C002
4 Liability XCOA yyyyyyyy 00000000 0000 XXXXXX0001 C002
5 Charge XEID pppppppp 72OXLFTG 0000 XXXXXX0004 C008
6 Liability XEID yyyyyyyy 00000000 0000 XXXXXX0004 C008
I want to derive project and equity segments from the expense lines to the liability lines associated with the tax lines but it is not working though both tax liability and expense liability lines
use the sama JLT (from xla_distribution_links table) as shown below.
7 Tax XCOA zzzzzzzz 00000000 0000 XXXXXX0001 C001
8 Liability XCOA yyyyyyyy 00000000 0000 0000000000 0000
9 Tax XCOA zzzzzzzz 00000000 0000 XXXXXX0001 C002
10 Liability XCOA yyyyyyyy 00000000 0000 0000000000 0000
11 Tax XEID zzzzzzzz 00000000 0000 XXXXXX0004 C008
12 Liability XEID yyyyyyyy 00000000 0000 0000000000 0000
Thanks for your help,
Shree.
Hi :
We have already implemented 12.0.4 and autoaccounting in AR is set up to use ‘Standard Line’ derivation for the natural account segment. This means for inventory based items the account segment is derived from sales account set up at item master. However for certain types of credit memos (Warranty Return) we want to use a different account. We were able to achieve this by setting up an ADR and using in SLA configuration. However by using this the Trxb=n distribution has a different account than the SLA and GL. We want Trxn dist = SLA = GL. Can this function be achieved by using Transaction Account Builder??? I heard Transaction Account Builder cannot be used in Receivables. It is only used in AGIS ??
Thanks
Murali Angappa
Hi Murali,
TAB is a feature offered by SLA and to use it in a module (e.g. Receivables), the module needs to uptake the TAB feature. AGIS was indeed the first module to make use of the TAB feature and as far as I know no other modules have in the meantime started using the feature (you could ask your Support Engineer to confirm this directly with Receivables Development ).
But why do you need TRX = SLA = GL?
Regards,
Sven
Nice post,good information. Thanks a lot =)
I am Amane Matsumoto. I am from Japan.
I am makie-shi (Japanese lacquer artist) and shoka(Japanese calligrapher).
I have spent my life working on traditional Japanese lacquer(urushi).
I am the Kyoto style artist and I have samurai soul.
I can make samurai maetate of Japanese helmets ,inro ,saya of Japanese sword
,gold Japanese lacquer boxes and so on.I have the highest skill in Japan.
Japanese lacquer art is made with gold ,silver ,platinum and so on.
The subjects I pick are very often nature.
I admire Mr.Lawrence Joseph Ellison in every way.
I am very happy that he research and learn
about Japanese culture and arts like Zen.I think he is a true samurai.
I’d like to ask him to become my patron.
He must have been extra busy , but if he would not mind helping me get through
this tough competition, that would be tremendously appreciated.
I sent my work(sho) and the photograph of my work(urushi)to Oracle head office.
But I hardly ever get back his reply.
It may be that he doesn’t get my photos and works.
Could you help me?
I’m at a loss. But I can not want to give up.
I would like to contact him.
I would like to go to America to meet him.
I’d like to ask him to become my patron.
I wish I could contact him somehow or other.
Could you help me?
Thank you so much for your kind reply.
Hi David
New to this so I’m not sure how to start a new discussion. Hopefully you see this.
I have a scenario where I have 3 custom applications in FSAH and use xla_events_pub_pkg.create_bulk_events to create my custom events.
What I have to do at the movent is use this API and the xla_events_int_gt interface table to create my events and then I need to do a select from xla_events to update my source table with the event_id I just created with the API.
Question: Can I read from the xla_events_int_gt table or do I need to read from xla_events or have you come across any other way to do this?
Thanks in anticipation
Hi Nicki,
Personally I’ve only seen xla_events being used, and not the GT table.
An alternative you could explore is to register a view as your Transaction Object.
In this view you join your source table with xla_entity_events_v (join on the source_id_… column(s)).
xla_entity_events_v already contains the event_id from xla_events so this way you avoid having to write back the event_id directly on the source table.
Hope this helps.
Regards,
Sven
Brilliant idea. Thanks so much, I’ll try and update just for info.
Hi David,
Have you seen instances where SLA and FAH have been used together ? Where EBIZ subledgers are flowing thru SLA, and external entities flow thru FAH ?
Are / is there a toolkit that you can take rules from SLA and export them to FAH ?
Mark
Hi Mark,
Yes SLA and FAH are being used simultaneously. They both use the exact same technology and tables meaning you don’t need to perform any special / additional steps in order to use them together compared to if you would be using either of them standalone.
There are seeded import/export concurrent programs – see page 131 of the Subledger Accounting Implementation Guide: http://download.oracle.com/docs/cd/B34956_01/current/acrobat/120xlaig.pdf but if you are thinking of exporting rules from SLA to FAH then that’s not necessary because both the SLA and the FAH rules are by default sitting together in the same place.
Regards,
Sven