My Oracle Support Banner

BICC Mappings in ODI Will Not Load Data to ADW After BICC Object Structure Changes (Doc ID 2718083.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.200618 and later
Oracle Data Integrator - Version 12.2.1.4.200618 and later
Information in this document applies to any platform.

Goal

When Business Intelligence Cloud Connector (BICC) is used as source in Oracle Data Integrator (ODI), when BICC releases a new release there is a possibility that the structure of the objects changes (like adding more new columns). When that occurs, the ODI models need to be reversed and all mappings resynced to reflect the BICC changes. Otherwise, the data load will fail. 

Does Oracle Data Integrator (ODI) 12.2.1.4.0 provide any out of the box solution to automatically reverse engineer and update the mappings which use BICC as a source?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.