Oracle BI Applications implementation to improve visibility into Oracle EBS data

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.

Business Challenges

  • Multiple ledgers were being used and needed to be configured in OBIA for accurate reporting
  • Financial reporting to be based on complex GL-Account range setup
  • Aging bucket available OOTB were different from business requirement
  • Dependency on Oracle on-demand for environment and migration

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