ODI SIL interface not populating data in custom extension columns

(Doc ID 2318155.1)

Last updated on OCTOBER 23, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.10.2 version, DataWarehouse

Extension columns not populating in ODI interface

We have made some customizations to the PARTY_PER_DS/PARTY_PER_D table. We copied the interfaces into a custom folder in ODI. We added 3 extension columns to the D table (X_EXEC_FLG, X_STAFF_FLG, X_STAFF_AUTH_FLG). These columns are populating as we expect through the SDE interface. On the SIL interface, these same columns are not populating and we can't find a reason why. I have attache the session log from ODI. The columns have been added to the SIL interface. If we look at the steps in the Operator tab in ODI, we can see the step Create Flow table includes the X_ columns, but the next step Insert Rows into Flow table the X_ columns are not included. We have regenerated the scenarios many times but can't find a reason why the extension columns aren't populating.
 

Changes

 

Cause

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 hundreds of Community platforms