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 performing a table-level re-sync.

Environment

Connector: Oracle Fusion Cloud Applications

Resolution

To resolve this issue, ensure the IsPopulate field for the column is set to TRUE in Oracle.

Cause

The IsPopulate field 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.