It's 11i... Do You Know Where Your Children Are?

PDFPrintE-mail

After spending enormous amounts of time and money, not to mention the tremendous emotional and social resources, it’s hard to imagine that conscientious parents wouldn’t be able to answer that question. But every so often it happens. Kids grow up, change, and become difficult to manage. The controls that were originally in place don’t apply, and as the children reach adulthood and some level of maturity, there is a need to develop new approaches for governance.

Similarly, companies have invested enormous resources in their ERP systems, nurturing them and adding to them over time as the needs of the business changed. The original Oracle E-Business Suite implementation, for example, was designed with the best of intentions.

The team, along with the busload of consultants, tried to build a system that would last the company for years and through generations of change. They provided each location the ability to govern its own system and configure it for flexibility to meet the operational needs of that entity. As with children, providing a good foundation prepares the organization for change, but it is difficult to predict the external factors that influence the adaptation and performance of the company over time.

Fast Forward into the Future

Before the internet and high speed connectivity, IT managers were in charge of local databases and were able to keep an eye on what was happening and to maintain IT controls to ensure application security and data integrity. The concept of an enterprise system existed only in the spreadsheets used to consolidate the company’s financial information. Fast forward a few years. Now, with thousands of systems upstream and downstream from the ERP system, with 24 x 7 accessibility requirements, and with a need to streamline costs and operations, maintaining controls over multiple systems is virtually impossible. In order to share data enterprise-wide, have consistent business practices, and have a global view of the business, it is necessary to re-think the underlying ERP architecture and the configurations that support a rapidly-changing business environment.

The changes are primarily reflected in the need to share data everywhere including having an integrated supply chain, having a seamless way of interacting with customers, and having global transparency in financial reporting to comply with IFRS standards. Cost-cutting measures also focus on the need to share data by centralizing operations within a shared services center and to foster growth by acquisitions and divestitures. Sharing data is difficult when there are disparate systems that only support a regional operation. Aligning operations with inconsistencies, different meanings of data, or even different patch levels requires a huge manual effort for reconciliation, translation, and maintenance.

In other words, it’s 11i. And your data is where, exactly? Many companies think that moving to R12 or to Fusion will solve many of the challenges they face with integrating their data and globalizing the systems that support the enterprise. However, it’s a long haul, and even small successes in getting R12 to work don’t mitigate the need for global standards, data quality, and control. In order to recognize the value of a technology upgrade the business needs to change, and in order to support a changing business there is a need for rapid reconfiguration of Oracle’s E-Business Suite.

Like Talking to Teenagers

Gingerly broaching the subject with business users elicits one big, long, collective groan or steadfast resistance. (Yes, it’s just like talking to a teenager). IT has been in charge of implementation projects that span multiple years and cost millions of dollars. I’ve been at companies that have taken 30 to 50 person-years to agree on a chart of accounts, and even then, allowed each part of the organization to have control of one or more segments. Another company that I’ve worked with has 1500+ systems that basically provide the same ERP functionality. It’s no wonder that the business users don’t want to have IT involved in another project to reimplement. This is a business problem and needs to be solved by the business users.

More than implementing a new technology, changing the business processes forces the enterprise to evaluate the value of each of its parts and to work together to develop synergies. Starting from the very basics – business groups, org units, and flexfields – decisions have to be made that will provide visibility on all aspects of the business to the C-level executives and yet provide efficiencies to operations. Many of those decisions require a global view of the enterprise and a local view of the business requirements. Changing to a Fusion or Services-Oriented Architecture does little to drive concurrence between different parts of the business. Implementing R12 by itself doesn’t force adoption of standards or facilitate sharing of data, just as giving your teenagers a cell phone doesn’t mean that you know where your children are.

In our disparate data example, you might be tempted to point to the data and say that it’s the data that’s the problem. If you do, you’re likely to solve this problem by throwing a bunch of warm bodies at it who will clean up reports, monitor access levels and permissions, and scrub, scrub, scrub away at the data endlessly. If instead you identify the disparate instances as the problem, you’ll get to the root cause, and now you’ll be able to take some more meaningful action.

Providing a set of standards and governance policies is a foundation for the communication and sharing of data. Embracing change is an enabler of enterprise growth, and transforming supporting ERP systems before considering a change to a new technology is the underpinning of success and of recognizing value in an earlier investment of millions of dollars and person-years of effort.

Do You Know Where Your Data Is?

Is there a single source of truth? Is the data reliable and consistent? And, do you know where your children are?

Add comment


Security code
Refresh

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Enter your email address to sign up for our Newsletter

Sign up now

captcha
TEChanges - Agility by Design

May Puzzle

David is often referred to as Rainman due to his peculiar ability to effortlessly figure out a certain date's day of the week. He recently displayed this talent when I asked him if there was a conflict with the upcoming Fuzzy Dice Conference and our weekly court-ordered community service. He asked the date of the convention. It was April 20th, 2012.

"Oh, that’s a Friday," he said, effortlessly. "And your sentences have you committed for the next few dozen Wednesdays so you'll be able to go." And of course he was right.

One day a few weeks ago I asked out loud in the office about the date June 5th. And of all people, my brother Tommy piped up and said "Oh, that's a Tuesday."

"That's right," said David.

Well how about Otcober 3rd?

"That's a Wednesday," said Tommy. Then I asked about Christmas Day 2012.

"Oh, that's a Tuesday." David nodded in agreement.

Do we now have two rainmen? Or had Tommy figured something out?

Show solution...

Solution

Here's what was going on. Tommy was using something called anchor dates. And these dates apply to each and every year. April 4th, or 4/4 we’ll call it from now on, June 6th or 6/6, 8/8, 10/10, 12/12, are all the same day of the week, each and every year.

So too are 5/9 and 9/5, May 9th and September 5th. So too are 7/11 and 11/7, and all the above dates are the same day of the week, as is the last day in February, Leap Year or not. And they’re all the same day as January 4th, it would otherwise be January 3rd, but this was a leap year, and that’s changes the anchor day from January 3rd to January 4th.

Tommy also knew that New Year's Day was a Sunday. He was sobered up by then. And he knew it was a Sunday because Christmas was a Sunday in 2011, so New Year's Day is a Sunday, so the Anchor Day for 2012, January 4th, has to be a Wednesday!

So if that's a Wednesday, then 4/4, 6/6, 8/8, 10/10, 12/12, 5/9, 9/5, 7/11, 11/7, and February 29th are all the same day of the week, and they're all Wednesdays. So when I ask for example, about October 3rd, he knew October 10th was a Wednesday, 10/10. So 10/3 must also be a Wednesday. 12/12 is a Wednesday in 2012, so it’s 12/26, which is two weeks later. So 12/25, or Christmas Day, must be a Tuesday.

Success Tips for Oracle Project Management

  • Create a standard for documentation at the beginning of your project, and hold team members accountable for completing documentation requirements as well as keeping them at and above the standards required.
  • Before promulgating user documentation or training, it’s also a good idea to choose a representative from the among the business users base to review materials first.
  • If you are not sure about the resources and budget required, obtain several estimates from people that have experience with the same size and scope of your project.
  • Be explicit, before beginning the project, what internal resources are required for execution. This includes people, infrastructure, hardware, and software.
  • Help the project champion understand the impact your project will have on the organization and how its successful completion will make him or her an internal hero or heroine for supporting it.
  • Break up your project into smaller projects (try for projects that can be completed in 4-6 months, especially early on) to get success and demonstrate momentum.
  • Make sure that your testing includes reports, upstream and downstream interfaces, customizations, enhancements, and workflows.
  • Ensure that comprehensive transition reports and meetings between departing and incoming personnel are completed.
  • Instead of spending time and resources implementing third-party reporting, consider consolidating multiple instances, moving to a global chart of accounts (CoA), and/or standardizing on a consistent calendar.
  • Include governance, risk, and compliance management as part of the project plan.
  • Finally, celebrate the successes. Too many projects focus on defects, failures, or small cost over-runs without looking at the big picture and what was accomplished.

The Analyst Corner

John Van Decker, Research VP of Gartner, states:

"A single chart of accounts allows consistency in financial reporting across the enterprise by standardizing on common metrics and reporting structures, reduces dependencies on a separate financial consolidation system, and significantly reduces the costs incurred with ongoing, complex conversions and translations."