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

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

• 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

• 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

• 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: