Given a table's name, fetch its polymorphic subtypes if they exist. The value for the 'QualifiedSubtype' output parameter can then be used in the 'IncludePolymorphicSubtypes' connection property.

Stored Procedure-Specific Information

Certain entities exposed by the Oracle Fusion Cloud SCM API are polymorphic.

Depending on the value/class of their discriminator fields, their subtypes are decided.

These subtypes then can have different child entities. Such child entities are only reported by the CData SSIS Components for Oracle Fusion Cloud SCM when these are supplied in the 'IncludePolymorphicSubtypes' connection property.

The value returned in the output parameter 'QualifiedSubtype' can be used in the 'IncludePolymorphicSubtypes' connection property.

Schema name can be supplied either in the 'SchemaName' input parameter or by qualifying the procedure name with it.

You must supply the table name you want to identify subtypes for.

EXEC FetchTableSubtypes TableName = 'TestEFF';
EXEC Manufacturing.FetchTableSubtypes TableName = 'TestEFF';
EXEC FetchTableSubtypes SchemaName = 'Manufacturing', TableName = 'TestEFF';

Input

Result Set Columns