Before you can run a Data Visualization report, you must first retire the Oracle E-Business Suite application.
To retire a Oracle E-Business Suite application, perform the following high-level tasks:
In the Enterprise Data Manager, create a customer-defined application version.
Import metadata from the Oracle E-Business Suite application to the customer-defined application version, along with user-defined views.
Create retirement entities. Use the generate retirement entity wizard to automatically generate the retirement entities.
In the Data Archive user interface, create a source connection. For the connection type, choose the database in which the Oracle E-Business Suite application is installed.
Create a target connection to the Data Vault.
Define a new data type mapping to handle VARCHAR2(0) length columns that exist in the views.
In the Data Archive user interface, click
Administration
Data Type Mappings for File Archive
.
Click
New Data Type Mapping
.
For Connection Type, select All Connections.
For Data Type, select VARCHAR2.
For Operator, select Equals.
For Length, enter 0.
For Precision and Scale, enter 0,0.
For File Archive Data Type, select VARCHAR.
For Source Length, enter 40.
Click
Save
.
Run the create archive folder standalone job to create archive folders in the Data Vault.
Create and run a retirement project.
In the Enterprise Data Manager, create constraints for the imported source metadata in the ILM repository. Constraints are required for Data Discovery portal searches. The Oracle E-Business Suite application retirement accelerator includes constraints for some tables in the Oracle E-Business Suite system. You might need to define additional constraints for tables that are not included in the accelerator.
Copy the entities from the pre-packaged Oracle E-Business Suite application version to the customer-defined application version. To copy the entities, perform the following high-level steps:
Right-click the customer-defined application version where the metadata is imported and select
Copy entities from Application Version
. The
Copy Entities from Application Version
window appears.
Select the application version from where you need to copy, which is typically Oracle Applications Retirement 1.0.
Provide the prefix that will be appended before the entity while copying. The Copy All Entities option is not required.
Click
OK
.
After you submit the background job, you can view the job status from the Data Archive user interface. Once the job successfully completes, you can view the copied entities in your customer-defined application version. You can use these entities for Data Discovery.
Before you run the reports, copy the report templates to the folder that corresponds to the Data Vault connection. You can use these pre-packaged Data Visualization reports to access retired data in the Data Vault. When you copy the reports, the system updates the report schemas based on the connection details.
Optionally, validate the retired data.
After you retire and validate the application, use the Data Discovery Portal, Data Visualization reports, or third-party query tools to access the retired data.