How to Check Oracle Forms and Reports Version

How to Check Oracle Forms and Reports Version? Oracle Forms and Reports are key components of enterprise applications, used for building and deploying data-driven applications. Knowing the exact version is crucial for troubleshooting, applying patches, and ensuring compatibility with other Oracle products.

In this article, we’ll explore several reliable methods to check the Oracle Forms and Reports version across different versions (6i, 10g, 11g, and 12c).

---

1. Using Command-Line Utilities (Recommended Method)

Oracle Forms and Reports provide built-in command-line tools that display version information:

Check Oracle Forms Version

Run the following command from the Oracle Forms installation directory:

sh

frmcmp | grep Forms

or

sh

frmcmp batch=yes | more

This will display the installed Forms version.

Check Oracle Reports Version

For Oracle Reports, run:

sh

rwrun | more

This command prints the Reports version and other details.

---

2. Checking the Oracle WebLogic Administration Console (For 11g and 12c)

If you’re using Oracle Forms and Reports 11g or 12c, you can check the version via the WebLogic console:

• Open a web browser and go to the WebLogic Administration Console:

arduino

http://<hostname>:7001/console

• Log in with your WebLogic Administrator credentials.
• Navigate to Deployments → Installed Applications.
• Locate Forms or Reports and check the displayed version.

---

3. Using OPatch to Check Installed Oracle Components

If Forms and Reports were installed as part of Oracle Fusion Middleware (11g, 12c), you can check their versions using opatch:

1. Navigate to the OPatch directory:

sh

cd $ORACLE_HOME/OPatch/

2. Run the following command:

sh

./opatch lsinventory | grep Forms

or

sh

./opatch lsinventory | grep Reports

This method is particularly useful for checking patch levels and installed components.

---

4. Checking Version from the Forms Runtime Environment

If you have a running Oracle Forms application, you can check the version directly from the application window:

1. Open any running Form.
2. Click on Help → About Oracle Forms.
3. A window will display detailed version information.

---

5. Checking the Registry File (For Older Versions Like 10g and Below)

For Oracle Forms 10g and earlier versions, version information is stored in a registry file.

1. Navigate to:

sh

$ORACLE_HOME/forms/java/oracle/forms/registry/registry.dat

2. Open the file and search for:

pgsql

oracle.forms.version

This will display the Forms version installed.

If your version is Oracle Forms 14.1.2.0.0 , read what’s new on this version

Oracle Forms Official Support

---

Methods That Do NOT Work (Common Misconceptions)

❌ frmweb -version → Incorrect. frmweb is the runtime process and does not return version info.
❌ rwcon60 -version → Only works for very old versions (6i). Not valid for 10g and newer.
❌ SQL Queries (v$option) → This only lists database features, not Forms or Reports versions.

---

Conclusion

Whether you’re working with an older version (Forms 6i, 10g) or newer releases (11g, 12c), these methods will help you accurately determine the installed version.

• For newer versions (11g, 12c) → Use command-line tools (frmcmp, rwrun) or WebLogic console.
• For older versions (10g, 6i) → Use the registry file (registry.dat) or the Forms runtime “About” menu.
• For patch verification → Use OPatch (opatch lsinventory).

By following these steps, you can efficiently manage your Oracle Forms and Reports environment and ensure smooth upgrades and troubleshooting.

Have you ever thought about MODERNIZING?