Agility by Design – an Oracle E-Business Suite Blog and Technical Tips 

If you currently find your Oracle Applications employing hundreds of roll up groups and cross validation rules to appropriate data to the right places for reporting and maintenance purposes, it may be time to consider restructuring your Chart of Accounts (COA) to utilize the practicality, efficiency, and agility of putting your values into ranges for each segment. Using logical ranges for the values within each segment gives meaning to an individual value or group of values based simply on its number. For example, if you have a project segment set up in your accounting flexfield, you may have all projects with values 55000 – 56000 represent a particular type of project (ie waste reclamation projects), then you would know by simply seeing the number 55440 that the project (called Great Lakes Research) is a water reclamation project. But ranges have even more practical uses when it comes to maintenance and reporting, allowing you to streamline your operational performance and increase efficiency. If your values are in logical ranges, reporting on specific types of values becomes as simple as setting up ranges for different business functions. >>MORE