My Oracle Support Banner

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

Last updated on NOVEMBER 28, 2023

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.