A day in the life of an Oracle Applications Consultant

Oracle E-Business Suite Electronic Technical Reference Manuals (eTRM)

This post contains a link to the site where Oracle E-Business Suite Electronic Technical Reference Manuals (eTRM) can be found and also has a write up on the site.

In a previous post I highlighted where the Oracle E-Business Suite Documentation CD could be downloaded. If you’ve taken a look at this documentation CD you will have noticed that the Technical Reference Manuals (TRM’s) are not there. This is because Oracle is now maintaining the technical reference manuals online. Presently you can access the Oracle E-Business Suite at this site: Once accessing this site you will be redirected to Metalink where you will need to specify a user name and password.

According to the site: -

eTRM is a pl/sql utility that reads design information in an Oracle database and displays its output in html format. It shows database design and dependency information for the Oracle eBusiness Suite.

The present version of eTRM is 3.0 and according to Oracle: -

Version 3.0 is a complete re-write of the eTRM code. Prior versions ran against an Oracle Designer repository. Version 3 runs in an Oracle Applications instance. This allows it to provide a more complete and accurate picture of the Applications data model. New features include a search engine, improved navigator functionality, pl/sql dependencies and static reports for offline working.

The site allows you to search the Oracle Databases from 11.5.4 to 11.5.9 to examine the FND Model or Oracle Data Dictionary. The information you obtain can then be downloaded in HTML or PDF format. I’m sure the information on the site will be very useful to anyone who would like to understand the technical architecture of Enterprise Resource Planning (ERP) Systems.

Posted by Richard Byrom on 08/02 at 06:22 PM
  1. Oracle Apps  Excuse this fundamental question: Forms 6 or 9 running via Jinitiator on client desktop.  How to obtain User Profile’s Organization that is assigned?  FND_ORG appears only for changing it, FND_PROFILE did not list this option?  Prefer best practice rather than Sql to table or view as in HR_ORG.

    Thanks, Logodox

    Posted by .(JavaScript must be enabled to view this email address)  on  10/06  at  02:18 AM
  2. We are upgrading from 11.0.3 to 11i and I can tell you that while 11i is a much better product, the eTRM Technical Reference is horid. For many of the columns, there is no documented join, so this leaves you with trying to find a view, report, or form to reverse engineer that *might* use the column in question in a join. If you cannot find this, then you are screwed. You cannot place joins into en enterprise environment that you *guessed* on.

    Also, none of the quick codes are documented. This again leaves you reverse engineering a form, or *guessing* which FND lookup it *might* use.

    All of this makes one think that Oracle does not actually want people writing queries.

    The documentation for 11.0.3 was fantastic. We had printed manuals, and all of the joins and quick codes were clearly defined.

    Oracle: kudos to you on your 1ii applications, but you should be truly embarrased by your poorly implemented schema documentation.

    Posted by .(JavaScript must be enabled to view this email address)  on  05/29  at  12:43 AM

Add Comment Information Here

Please note that comments will only be accepted from valid members of this site who provide feedback that is beneficial to readers of the blog. ALL comments (even those from members) will be subject to moderation.


Notify me of follow-up comments?

Submit the word you see below: