Skip to main content
Kofax

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

308340

Question / Problem: 

How to determine SQL*Flow Application Function for a given form?

Answer / Solution: 

Run the script attached get_wf_info.sql in the MarkView database schema.

This will prompt for 4 different values. Here is how you can find out the values.

FormName:

  • Logon to Oracle Apps
  • Navigate to the form in question
  • Choose Help - About Oracle Apps from the menu to see the form name
  • Example = APXINWKB

BlockName:
  • Logon to Oracle Apps
  • Navigate to the form in question
  • Navigate to the block in question
  • Choose Help - Diagnostics - Examine (supplying APPS password if prompted)
  • The current block will be listed in the pop-up window in the Block field
  • Example = INV_SUM_FOLDER

ResponsibilityID:
  • Logon to Oracle Apps
  • Navigate to the form in question
  • Navigate to the block in question
  • Choose Help - Diagnostics - Examine (supplying APPS password if prompted)
  • Enter Block: $PROFILES$ (tab)
  • Enter Field: RESP_ID (tab)
  • The Value will be displayed in the Value field
  • Example = 20284

ApplicationID:
  • Same steps as for ResponsibilityID except
  • Enter Field: RESP_APPL_ID (tab)
  • The Value will be displayed in the Value field
  • Example = 200

Applies to:  

Product Version Category
MarkView for Oracle All  

 

Author:  Aidan Sullivan

Created On: 7/12/2019

Based on original CRM article 3731