How To Configure an Enterprise Capture Database Lookup From Two Joined Tables
Last updated on JULY 07, 2017
Applies to:Oracle WebCenter Enterprise Capture - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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.
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