Getting Started in MOSC

MOSC Banner

virtual column OGG capture process not working

edited Oct 16, 2026 2:14PM in Getting Started in MOSC 1 commentAnswered

One of the tables containing a virtual column is sourced from an Oracle DB running on OCI, with BQ as the target.

We encountered a data quality issue: the virtual column data was not received in the target. in testing, used the following configuration in the extraction, but the capture process did not retrieve any data:
Table Configured in Extract Process:
TABLE Schema.Table_Name, FETCHCOLS (Column1, Column2, Column3, Column4);

I wanted to capture all the data in columns the table, including both the regular and virtual columns. Does anyone have an idea why the capture process is not working in this case?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center