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 and later
Oracle Data Integrator on Marketplace - Version and later
Information in this document applies to any platform.


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.


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.