This is a guest post from Sangeeta Sameer, who worked for Oracle for 6 years before moving on to work for GE where has held a number of senior positions. She has also joined the board of the OAUG Multinational Special Interest Group.
At the Collaborate 2014 Conference, David Haimes and I presented a custom solution to enable balancing by 2 segments of the Chart of Accounts in Release 12.1.3 of Oracle e-Business Suite. The attached PowerPoint and Paper that we presented describes in detail the requirements and the custom solution.
So when David asked me to write a guest post about this topic, I thought about what else I would include in the paper if we were writing it again. While the paper talks about the requirement to create a balanced Trial Balance by 2 segments, it does not expand on why we need a balanced Trial Balance by 2 segments. Global corporations like General Electric (GE) need better granularity and accountability for the financial performance of their geographical divisions and lines of businesses by being able to create a Balance Sheet at both a Legal Entity/Statutory level and Business Unit/Management Entity level. GE is a Global conglomerate that has diverse businesses operating in a large number of countries. GE needs the ability to create a balanced Trial Balance by the Legal Entity (LE) and the Management Entity (ME) segments in the Chart of Accounts.
The ability to automatically balance by more than one segment is not a new requirement for GE, and I think it would be a requirement for other multinational companies as well. This requirement is explained quite well in Oracle Fusion Applications Enterprise Structures Concepts Guide 11g Release 5 (11.1.5) – Part # E22899-05. See the section titled “Legal Entity and Its Relationship to Balancing Segments”. While Fusion Applications are able to balance by up to 3 segments in the Chart of Accounts, Oracle e-Business Suite (EBS) Applications are able to balance by one segment only.
In prior EBS Release 11i implementations at GE, the requirement to balance by 2 segments was satisfied by developing custom solutions that needed to be re-visited for Release 12. For example, one of the solutions in 11i was for a custom program to bring balancing entries into the Interface Table. With the introduction of SLA in Release 12, this 11i solution was no longer a good one for R12. The solution described in the attached Paper and PowerPoint is a much more robust solution, and is live in Production for 2 different ERP Projects at GE.
The OAUG Multinational Special Interest Group (SIG) is organizing a webinar on June 11th at 10.30 am Pacific (1.30 pm Eastern) on this topic. David and I will repeat the presentation from Collaborate 2014, and look forward to sharing this solution again. The webinar will be one hour long, including 20-25 minutes for Q&A.
The link to register for this webinar is:
https://www4.gotomeeting.com/register/790696327
Woah! I’m really digging the template/theme of this blog.
It’s simple, yet effective. A lot of times it’s difficult
to get that “perfect balance” between superb usability
and appearance. I must say that you’ve done a very good job with this.
Additionally, the blog loads very fast for me on Safari.
Excellent Blog!
LikeLike
Hi Sangeeta (and David),
Thank you very much for sharing this solution. It seems like a good solution for the company I am working at. I am wondering if you can share some of the more technical details? For example, how are the balancing rules defined for the secondary balancing segment? Is AGIS used for the primary balancing segment?
It’s been a while since this post and it also doesn’t look like this blog has been updated in a while. So, my expectations for a response are low but thought I would give it a try.
Thank you,
Jason
LikeLike
Jason,
There are technical details posted in the whitepaper – it is linked in the post – here it is again for your reference – https://davidhaimes.files.wordpress.com/2014/06/2-segment-balancing-paper.pdf
LikeLike
Hi Jason,
It is a nice feature. Is there any plan to incorporate the Two balancing segment feature into the on-premise EBS R12.2.X product?
LikeLike
No plans to move this to product – Cloud Financials has this out of the box, so that is the best option.
LikeLike