Even with Support Invisible columns enabled in the Oracle endpoint (Advanced settings), invisible columns cannot be replicated.
Resolution:
- Stop all parent and child tasks related to the task in which invisible columns are not replicated
- Add the table to the parent task
- Reload metadata for missing tables to the parent task
- Resume the parent task from timestamp (from the time it was stopped, verify the exact moment in the task logs)
- Add the same table to the child task
- Reload the metadata of the missing tables to the child task
- Resume the child task from timestamp (the moment the parent task was stopped)