You can generate the reports in the Data Visualization area of Data Archive. Each report contains multiple search parameters, so that you can search for specific data within the retired entities. For example, you want to review payment activities related to a specific invoice for a certain supplier and supplier site. You can run the Invoice History Details report and select a specific value for the supplier and supplier type.

When you install the accelerator, the installer imports metadata for the reports as an entity within the appropriate application module. Each report entity contains an interim table and potentially multiple tables and views. You can view the report tables, views, and their columns and constraints in the Enterprise Data Manager. You can also use the report entity for Data Discovery.

Some reports also contain user-defined views. The user-defined views are required for some reports that include tables that have existed in different schemas in different versions of Oracle E-Business Suite. Some of the user-defined views are required because of the complexity of the queries that generate a single report. Finally, some of the user-defined views are required because some of the queries that generate the reports refer to package functions that Data Vault does not support.

You can run a script to create a user-defined view that is required for a report. Contact Informatica Global Customer Service to acquire the scripts for the user-defined views in each report.