Use these instructions to upgrade the source.
Perform the upgrade steps. As part of the Upgrade process, you would have exported your connections, dropped and replaced the ODI repository, and then imported the connections back again.
Do not run any load plans during this process and deactivate the load plan schedules.
Oracle BI Applications release 11.1.1.10.1 supports multiple Fusion releases, thereby allowing the source to be either Fusion 9 or Fusion 10. When you upgrade from BI Applications Release 11.1.1.9.2 to 11.1.1.10.1, you need to set the DSN for the logical schemas DS_<modelCode>_SDS
and DS_<modelCode>_SDS_DW
(for example, DS_EBSR122_SDS
, DS_EBSR122_SDS_DW
) if SDS is deployed for a previously registered source.
To upgrade Fusion V1 adaptor ODI artifacts to use Fusion 9 adaptor:
Note:
If you do not import the connections from BI Applications Release 11.1.1.9.2 repository, then the rewiring process will not work. In this case, you will need to run the Fusion Upgrade load plan and not the Source Upgrade load plan.Note:
Execute the standalone scripts from BI Oracle Home.After you have performed these steps, you can verify that the process ran fine:
When you see the context, you should see all the physical Fusion Connections mapped to Fusion 9 logical schemas. Nothing should still point to Fusion V1 schemas.
DSN against Fusion 9 should be the same DSN as earlier.
In Generated Load plan, you should see all scenarios corresponding to Fusion 9 and not Fusion V1.
All existing load plan schedules should be moved to the newly generated load plans.
In W_ETL_LOAD_DATES
table, you should see entries for Fusion 9 only and not V1 anymore.