This section describes the Business View Generator used in setting up Oracle Business Intelligence System.
Oracle Business Intelligence System (BIS) uses business views to access information about your business applications. Business Views are created using the Business View Generator. Business Views are set up after you have completed the setup for the other Oracle E-Business Suite products you have installed.
For additional setup information, see the Oracle Business Intelligence System Implementation Guide.
Business Views should be set up after you have completed the setup for the other Oracle E-Business Suite products you have installed. Ensure that:
All the key flexfields have been set up and frozen.
The desired descriptive flexfields have been set up and frozen.
The values for user updateable lookup codes have been set up.
Set the Business View Generator Optimizer Mode profile to the appropriate value.
Changes in the RDBMS optimizer from Oracle 9.2 to 10g and 11g might cause some column names derived from descriptive flexfields to change when regenerating business views after upgrading the RDBMS to 10g or 11g. This scenario can also happen when upgrading from Release 11i (with the 9.2 RDBMS) to Release 12. While there are no issues with the view content, there may be issues with accessing the views from Oracle Discoverer Folders, custom reports, or custom queries due to changed column names.
To address this issue, a new site-level profile called the Business View Generator Optimizer Mode is used.
Before generating the business views, set the profile Business View Generator Optimizer Mode to the desired value. See the table below as a guide to what values to use.
| Scenario | Business View Generator Optimizer Profile Value |
|---|---|
| New Oracle E-Business Suite installation or system on RDBMS version 9.2 | Unset (null) |
| View was previously generated on a 9.2 system that has been upgraded to 10g or 11g. | 9i (and regenerate the view) |
| View has never been generated on 9.2, but has been generated on 10g | 10g |
| View has never been generated on 9.2, but has been generated on 11g | 11g |
You run the Business View Generator to include information specific to your setup in the Business Views templates and to generate your Business Views.
To run the Business View Generator, perform the following:
Connect to Oracle E-Business Suite and assume the Business Views Setup responsibility.
Note: We recommend you restrict the access to this responsibility to the system administrators performing your installation.
In the Navigator, choose Reports > Run menu options to open the Submit Requests window.
Run the concurrent program Generate Business Views by Applications for each licensed application product at your site.
If all the products are licensed, alternatively, you can run the Generate All Business Views program.
Concurrent programs are also available to generate Business Views by descriptive flexfield, key flexfield, lookup, or view name. You should regenerate Business Views by lookup type, descriptive flexfield, or key flexfield (as appropriate) if any new lookups or flexfields have been defined since the views were last generated.
Note: Due to the large number of Business Views delivered with Oracle Business Intelligence Systems, the execution of these concurrent programs could be a lengthy process (approximately 13 hours).
In the Navigator, choose Reports > View to open the View Requests window.
Verify that all the submitted programs completed successfully and that all the views were generated without errors by clicking the View Output button for each program.