Only changes in column datatypes result in migration issues. Adding a column to a database regardless of its type will not affect existing reports.
When a datatype has been changed, a REPT 0499 error will occur when the report is opened. This error occurs when the datatype of a field in the database does not match the datatype of the same field in the report. To resolve this error, use the following steps:
Open the report in Reports Builder.
In the Data Model view, click a query.
Right-click, and choose Data Wizard from the menu.
On the Data page of the wizard, add a space to the end of the query.
Click Apply to reparse the query and update the datatypes in the report.
Click Finish.
Repeat steps 2 through 6 for each query in the Data Model.
Note: If the report uses external queries, they will also have to be updated.
Copyright © 1984, 2005, Oracle. All rights reserved.