Hi-Definition Data Transformation Problems > Align EBS Accounting to Your Business > Simplify FSGs and Other Reports

Writing reports is a major effort because your accounting structure has grown and the values are not in ranges anymore.

Profile

A large manufacturing company implemented Oracle E-Business Suite eight years ago, and the chart of accounts has grown dramatically since the implementation. The company did not initially design the chart of accounts to accommodate the addition of numerous accounts in specific ranges, so new accounts were added haphazardly in random places in the chart wherever room could be found. Over time, reports became much more difficult to create because accounts that should have been grouped were dispersed throughout the accounting flexfield – they became unable to use logical ranges to simplify report writing, and the cost in employee time and wages of creating reports rose to extremely high levels. The company needed a way to reduce the dispersion of the accounts and return to writing reports based on logical ranges.

Solution

The company used FlexField software to restructure and expand their accounting flexfield to match the current and future needs of the company. They also created a master row set in FSG for their reports. Though the new master report set took 2 weeks to develop, now they are able to create new reports on demand in just an hour. Using FlexField software, they lengthened the current segments to accommodate more values and mapped the dispersed accounts to new values to create new logical ranges for all their segments. After the change, they significantly simplified report writing and reduced the cost of reporting by 60%.