My Oracle Support Banner

"Ghost" Attribute Added by Reverse Engineering to the ODI 12c Model that Does Not Exist in Salesforce (Doc ID 2278545.1)

Last updated on APRIL 21, 2023

Applies to:

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

Symptoms

Using Salesforce with Oracle Data Integrator (ODI) 12c, updating models with reverse-engineering adds attributes which do not exist in Salesforce to some of the Salesforce Models.

For example, in a model there is an attribute (column) called <COLUMN_NAME2> added which does not exist in Salesforce.

If this unwanted attribute is then deleted from the Salesforce Model, an error message is signaled when you right click on the entity (Datastore) and chose "View Data" from the pop-up menu:

To reproduce the behavior:

  1. Reverse-engineer Salesforce objects
  2. Observe that there is a new attribute added to the corresponding Datastores. However, the attribute actually doesn't exist on the Salesforce back-end server
  3. Remove the additional attribute from the Salesforce model in ODI
  4. Right-click on the Model (or Datastore) and select "View Data". Notice the error.

Cause

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.