A useful tool for Applications DBAs and anyone for that matter who works with the e-Business suite is that online electronic reference manual or eTRM.
The latest details are available on the Oracle Support site URL listed below:
In addition, reference note ETRM DIRECT ACCESS DOCUMENT [ID 150230.1] will link you to the eTRM directly as long as you have a valid Oracle Metalink or MyOracle Support account. Now, lets take a quick look at what the eTRM can do for you in terms of working with the EBS Suite for Oracle Applications.
In a nutshell, the eTRM is an online way to examine the structure of data dictionary objects for the Oracle Applications e-Business Suite. Below is the welcome screen to show the details.
Let's walk through an example in which we want to find out what the different views and tables exist for the FND objects within R12. We do a search on tables and views for FND as shown in the following example.
This gives us a detailed listing for the FND_USER table as shown below.
From here we can look at sample queries and dependencies for the FND_USER table.
Now we can move back to examine more definitions for the APPS schema.
If we look at the FND_PRODUCT_INSTALLATIONS definition we can obtain useful queries as shown below.
By choosing the link to APPLSYS.FND_PRODUCT_INSTALLATIONS we can query and list our details for product versions installed.
In fact, we can grab a nice query to paste into SQL*PLUS or TOAD to show us the details:
This tool helps eliminate the complex guesswork of where dependencies lie and thereby simplifies the work for the busy Apps DBA and developer.
Finding details on configuration for the Apps DBA is excellent with the eTRM if for instance we look at the following section
Looking for patch information and detailed configuration information can be time consuming and tedious work. Now with eTRM, literally you can let your fingers do the walking.
I can grab the query listed below and paste into SQL*PLUS or TOAD to obtain the patch listing in seconds.
And the results from the query are listed below: