Guest Post: Custom Balancing by 2 segments in EBS R12


Sangeeta Sameer, IT Leader – Finance, Renewables ERP at GE Power & Water

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: