ODI SIL interface not populating data in custom extension columns
Last updated on OCTOBER 23, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.2 and later
Information in this document applies to any platform.
On : 126.96.36.199.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.
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