Oracle BI Applications implementation to improve visibility into Oracle EBS data | Jade

About the Client

McGrath RentCorp is a California corporation headquartered in Livermore, CA with branch offices located throughout North America, Malaysia, Mexico and India. McGrath serve a broad spectrum of industries, including telecommunications, construction, education, petrochemical and environmental. McGrath RentCorp is a diversified business to business rental company with three primary rental divisions: relocatable modular buildings, electronic test equipment and liquid and solid containment tanks and boxes.

Oracle Platforms Used

  • Oracle BI Applications,
  • Informatica,
  • Oracle EBS

Business Requirements

  • Implementation of Oracle BI Financial Analytics & Procurement-Spend Analytics
  • Deliver business critical financial reports like Balance Sheet and P&L Reports as per McGrath custom Account setup
  • Configure GL Account Ranges as per McGrath EBS implementation
  • AR Invoice Aging reporting by Division and Branch/Location
  • Implement overall security model for OBIA
Download Case Study

Business Challenges

RMCS

Multiple ledgers were being used and needed to be configured in OBIA for accurate reporting

RMCS

Financial reporting to be based on complex GL-Account range setup

RMCS

Aging bucket available OOTB were different from business requirement

The Solution

  • Redesigned and customized OOTB Oracle BI Apps to handle multiple ledgers
  • Customized Account Range Key setup files as per EBS COA setup done by customer
  • OBIEE Data Model was customized to accommodate aging buckets

Benefits

  • Financial reporting helped business to track assets and liabilities, revenue through P&L reports and view revenue according to GL-Account and location
  • Procurement & Spend Analytics helped business to monitor procurement and thus control the overall cost
  • Critical Aging report helped business to track money receivable and helped representative in following up long pending receivables
Back to Top ↑