Case Study
Oracle BI Applications implementation to improve visibility into Oracle EBS data
Download Case StudyAbout 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
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
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
Download Case Study
Related Section
