OBIA Group Accounts

Oracle Business Intelligence Applications (OBIA) is really cool. They actually give you a data warehouse, pre-built ETL's that you can configure and get your data warehouse up and running for E-Business, JD Edwards and Peoplesoft. If you had to do it from scratch, it would take forever. In any case, the first thing you will notice that out of the box is that the grouping of accounts is done at the natural account level. So..a little background. General Ledger is made up of several segments. At a minimum, you will need two, a company segment and a natural account. But in reality, most companies have five or six. For example,
Segment1 - Company
Segment2 - Natural Account
Segment3 - Department
Segment4 - Line of Business.
Segment5 - Sub Account

Typically, revenue is reported by line of business and cost is reported by department. So the grouping of accounts would span segments.
Revenue - Segment2, Segment4 and Segment5
Cost - Segment2. Segment 3 and Segment5.

But, the out of the box ETL can do it on one segment- the natural account. So the first thing you would have to do is extend the ETL for the grouping to span segments. Oracle Metalink has a nice note with a how-to on this. It can't get better than this.

You can find it on metalink.oracle.com.
OBIA: How to Create Group Accounts Based On More Than One Segment [ID 1409595.1]  An enhancement request has been logged for this as well.
BUG:9202898 - FILE_GROUP_ACCT_CODES_ORA.CSV - USING 4 CONCATENATED SEGMENTS

Or, we can show you how to do it...There are a couple of neat things you can do proactively on top of this to build dashboards that your CFO or others can use.