Columns Are Missing From the Destination and Schema Tab
Issue
New columns added to the Oracle BICC extract are missing from the destination and the Schema tab in Fivetran, even after a table-level re-sync.
Environment
Connector: Oracle Fusion Cloud Applications
Resolution
In Oracle BICC data store, set IsPopulate to TRUE for each missing column.
Cause
The IsPopulate field for a column in Oracle BICC determines whether a column is included in the extract output. If the field is set to FALSE, Oracle excludes the column from the extract file. As a result, we can't detect or sync the column.