How to - General Part 2

---

How to switch off the custom code?

In the Oracle Forms [under any responsibility]
Go to Help --> Diagnostics --> Custom Code --> Off

---

How to find the invalid objects?

Select object_name, owner from dba_objects where status like ‘INVALID’;

---

How to enable the HTTP Trace for HTML Applications ?

ieHTTPHeaders Trace : Gives information on the HTTP request that is being sent to the server from the browser.

Usage : Can be used to debug the HTML based error message.


Please follow the below instructions to get the ieHTTPHeaders trace.

You can download the free tool from this url: - http://www.blunck.se/iehttpheaders/iehttpheaders.html

This tool provides a plugin to Internet Explorer so that the http calls can be logged.

After installing the http headers trace,
Enable the trace exactly before the issue occurs
Trace can be enabled by View -> Explorer Bar -> ieHTTPHeaders.
Trace can be disabled by View -> Explorer Bar -> ieHTTPHeaders.

---

How to get the instance details like SID, Host Name, Apps Version and Database version from the back end?

select i.instance_name, i.host_name, f.release_name release, i.version from v$instance
i,fnd_product_groups f where upper(substr(i.instance_name,1,4)) =
upper(substr(f.applications_system_name,1,4));

---

How to find the file version from the back end?
Use the below command to get the version of the file that resides in the APPS server, this makes things easier without using the UNIX command

select FILENAME , VERSION from AD_FILE_VERSIONS a, AD_FILES b where a.FILE_ID=b.FILE_ID and FILENAME like '';

It lists the various versions of Oracle Applications files (real files, not "pseudo-files"), that have ever been patched or executed in the Oracle Applications installation.
So The query result will be having more than one record, the highest version in that will be the correct file version of the file that resides in the APPS Server.
For more info, search in eTrm for the tables AD_FILE_VERSIONS , AD_FILES.

---