How To - General Part 3

---

How to find a form name and version?
Having the Oracle Application started, a lot of useful information can be found starting from the Help menu of the application.
To find the current form name and its version, go to Help->About Oracle Applications…
Here, scroll down to Current Form section. Bellow is an example for Sales Orders form:
----------------------------------------
Current Form
----------------------------------------
Form Application : Order Management
Form Name : OEXOEORD
Form Path : /opt/oracle/apps/appl/ont/11.5.0/forms/US/OEXOEORD.fmx
Form Version : 11.5.555.1159.2
Form Last Modified : $Date: 2003/11/20 13:02 $

---

How to find a patch set version of an application?
Details about the patch level of the applications can be found querying the fnd_product_installations table.
The example below is for the Order Management module:

SELECT fat.application_name,
fpi.status,
fpi.patch_level
FROM fnd_application_tl fat,
fnd_product_installations fpi
WHERE fat.language = 'US'
AND fat.application_id = fpi.application_id
AND(fpi.status != 'N' OR fpi.patch_level IS NOT NULL)
AND fat.application_name IN
(SELECT fat1.application_name
FROM fnd_application_tl fat1,
fnd_application fa
WHERE fa.application_id = fat1.application_id
AND fa.application_short_name IN ('ONT'))

---

How to search for a Form Function in a responsibility?
Once logged on in Oracle Applications under a specific responsibility, you must have the Navigator in focus and then press Ctrl+L.

---

Ways to get profile values
Once logged on into Oracle Applications, go to Help->Diagnostics->Examine…
Enter the apps password.
In the ‘Examine Field and Variable Values’ form, choose as Block ‘$PROFILES$’ and as Field you can select the needed information like ORG_ID, USER_ID, etc.

Or, you can use the procedure fnd_profile.value:
select fnd_profile.value('ORG_ID')
from dual;

Or, having the Navigator in focus, pres Ctrl+L to search after 'Profile User Values'.

Or, from System Administrator responsibility, having the Navigator in focus, you can search after 'Profile System Values' pressing Ctrl+L.

---

How to find the last query executed in a form?
Once logged on into Oracle Applications, go to
Help->Diagnostics->Examine…
Enter the apps password.
In the ‘Examine Field and Variable Values’ form, choose as Block ‘SYSTEM’ and as Field ‘LAST_QUERY’.
The Value field will be populated with the last query executed.

---