Warning: Excluded by System

Issue

It's not possible to include some tables in the connection schema configuration. The tables are grayed out, and one of the following warnings appears:

• Excluded by System - Datastore not configured for any offering
• Excluded by System - Datastore missing a primary key
• Excluded by System - Column metadata fetch failure
• Excluded by System - Datastore has over 1000 default columns

Environment

All Oracle Fusion Cloud Applications connectors

Resolution

To resolve this issue, refer to the relevant warning reason below:

Datastore not configured for any offering

Fivetran can’t sync datastores that aren’t assigned to an offering in Oracle Fusion. To resolve this warning, configure your datastore to be a part of an offering in Oracle. To learn more, see Oracle's Add a Datastore for an Offering documentation.

Datastore missing a primary key

We require each table to have a primary key to sync it. To resolve this warning, you must enable primary keys for the relevant datastores in the Oracle BICC console. For more information, see our Select primary keys for custom objects documentation.

Column metadata fetch failure

This warning appears when we encounter an internal error while retrieving column metadata. To resolve this issue, contact Oracle support and request access to the datastore’s metadata.

Datastore has over 1000 default columns

Due to query limitations, sync jobs fail when a datastore contains more than 1000 default columns. To work around this limitation, manually select up to 1000 columns from the datastore before syncing.