The power and water division of a major industrial manufacturer sought to bring sorely needed order and efficiency to a lengthy and chaotic month-end closing process.
Our client’s four-day month-end closing process required manually running ten to fifteen different programs for each subledger and each general ledger set, for each organizational unit configured in EBS. This meant that all these programs had to be run nearly 150 times for each month-end close. It was a labor-intensive undertaking, driven by phone calls, emails, and trust. The six people required for its completion worked very long hours for several days each month while spending the remainder largely idle. Moreover, a lack of visibility meant that there was no way to identify process bottlenecks or performance issues.
We used Oracle SOA Suite to create an accurate and reliable process for orchestrating the numerous program executions. We automated most of these, and harnessed Oracle BPM to both route exceptions to the appropriate individuals for resolution and to provide a single location for accessing and addressing them.
We built in broad flexibility for handling exceptions, including the ability to skip over them when deemed appropriate, and provided a deep link from BPM back into EBS to expedite fixes required there.