Forms Recognition Import of VendorASSA from ODBC Data Source Returns "Supplier pool would be created with 0 items. Update aborted" - Even Though Table does Contain Records (Doc ID 2109133.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle WebCenter Forms Recognition - Version 10.1.3.5.0 to 11.1.1.9.0 [Release 10gR3 to 11g]
Information in this document applies to any platform.

Symptoms

When attempting to import the VendorASSA pool in Designer, the following message is returned:

Supplier pool would be created with 0 items. Update aborted

The query configured in Designer is:

SELECT * FROM XX_OFR_SUPPLIERS_V

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms