MarkView Oracle Integration - Could not determine workflow function for form (XXX) and block (YYY)

Question / Problem: 

Could not determine workflow function for form (XXX) and block (YYY)When navigating to a MarkView Form in Oracle Applications, the message appears when the form starts up.

Answer / Solution: 

The Kofax Forms for Oracle Applications use data setup in database tables to determine what SQL*Flow application function to use for the current form and block. It can also be sensitive to the Oracle Application ID and Responsibility of the currently logged on user. The API SF_Forms_API.GetWorkflowInfo is used for this purpose and this queries the underlying table SF_FORM_BLOCK_FUNCTION.

The attached script, get_wf_info.sql, will prompt for an Application ID, Responsibility ID, Form Name, and Block Name. You should run this as the APPS user to simulate what the forms are doing. If no values are returned for Form Name, etc., then the data setup is incorrect.

Related article: How to determine SQL*Flow Application Function for an Oracle EBS form?

Applies to: