With Angles for Oracle Views, Cummins’ End-Users Don’t Need to Worry

Cummins, Inc. is a corporation of complementary business units that design, manufacture, distribute, and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions, and electrical power generation systems. Headquartered in Columbus, Indiana (USA), Cummins employs approximately 40,000 people worldwide and serves customers in close to 190 countries and territories through a network of more than 600 company-owned and independent distributor locations and approximately 6,000 dealer locations.

Challenges

Cummins was running multiple versions of Oracle® E-Business Suite (EBS), and was in the process of upgrading many sites to the most recent Oracle release.

With so many versions of EBS within Cummins, joining the various tables was difficult at best, prohibiting end-users from accessing information required for reporting purposes.

Solution

“Typically, reporting is the last thing people look at during an implementation,” said Srini Chavali, Director, Enterprise Database and Tools, Cummins, Inc. “Then, on the day of go-live you hear, ‘Where are my reports?” To solve this issue, Cummins uses Magnitude Angles for Oracle and Oracle Discoverer. Angles for Oracle Generator provides an end-user layer that enables non-technical users to easily build reports that automatically power-up the Discoverer tool. “Angles for Oracle provides a quick and easy way to give end users access to data without too much hassle in terms of trying to find out what the base tables are about,” said Chavali,

During the Oracle upgrade, Cummins leveraged Angles for Oracle as the foundation for their reporting needs. This streamlines access to Oracle application data during the implementation phase and to provide ongoing report protection against data structure changes inherent in upgrades.

Results

“Reporting is always a challenge because there are so many stakeholders trying to get the information out of Oracle, especially EBS,” said Chavali. “Angles for Oracle provides a very stable and compact platform on which to run the reports.”

With the views provided by Angles for Oracle, Cummins’ end-users don’t need to worry about how to join the various tables in the applications to get to their data – they just look at the business terminology within the views and pull out the data that they want.