How To Configure an Enterprise Capture Database Lookup From Two Joined Tables (Doc ID 2095955.1)

Last updated on JULY 07, 2017

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

There is a business requirement to perform a WEC database lookup using lookup profiles. The query needs to be run is a join of two tables that pulls information from both tables.  When creating two separate lookups that cascade in two chaining Recognition Profiles, the field value from the first lookup does not get populated until all of recognition is complete.  Therefore, the needed value is not available to complete the second lookup, even though the field is properly populated when both recognition processes complete.

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