The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

Update to EBS Electronic Technical Reference Manual (eTRM)

Rekha Ayothi
Product Management

The Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) is a repository of Oracle E-Business Suite database object definitions and their dependency information.

The eTRM contains a detailed description of database tables, views, and packages for each of the EBS products. Apart from database design documents, you can find primary and foreign key relationships between database objects in eTRM.

The eTRM does not include EBS database object changes for each of the RUPs or minor releases. If you need to review the differences in EBS database objects between releases you can use the EBS Data Model Comparison Reports.

Oracle Electronic Technical Reference Manual

What has Recently Changed?

The eTRM was available as an online utility from My Oracle Support. As of this update, eTRM is only available via offline access. You can now download and stage the contents of the eTRM locally.  Then you can view the local contents as a set of static pages.

The downloadable eTRM is available for Oracle E-Business Suite Release 12.2 and 12.1 only. It does not include older releases EBS releases such as 12.0 and 11i.

How do I Download eTRM?

The following is a summary of the steps required to download and stage eTRM on a local machine.

  1. Open the URL https://etrm.oracle.com in browser.
  2. Enter your My Oracle Support credentials to login.
  3. My Oracle Support Document 2736939.1 - Oracle E-Business Suite Electronic Technical Reference Manual (eTRM), Release 12.1 and 12.2 will be displayed.Oracle Electronic Technical Reference Manual (MOS Note: 2736939.1)
  4. Follow the instructions in Section 2 Downloading the eTRM to download and unzip eTRM patches to your local machine.
  5. Open the index.html file in your browser to access eTRM from local machine.

Once downloaded and staged, you can access the eTRM anytime from your staged location. 


Related Articles

Join the discussion

Comments ( 17 )
  • Raivis Thursday, April 8, 2021
    what's the reason not to host those static pages?
  • Mark Thursday, April 8, 2021
    Thanks for the info. I noticed too on ETRM. Do you have any idea how to get the database tables and columns details for older versions
  • Roy Thursday, April 8, 2021
    Have you tried downloading the eTRMs and unzipping them?
    I have tried, but unfortunately I am not able to unzip file nr. 2 of 6.
    Should this be done on unix/linux, or can it be installed on a windows PC?
  • Rekha Ayothi Thursday, April 8, 2021
    Hi Mark,

    Currently, you can download eTRM for EBS R12.2 and R12.1. It is not available for older releases of EBS.

    EBS 11i and 12.0 are in Sustaining Support and customers still on these older release versions are recommended to upgrade to latest EBS releases.

  • Mark Thursday, April 8, 2021
    Hi Rekha,

    Thanks for the info. Any ideas how to get data definitions for E-Business Suite 11i.

  • Rekha Ayothi Thursday, April 8, 2021
    Hi Roy,

    You can download and unzip the 6 zip files which are part of the patch, into any machine. It could be Unix/Linux or Windows machine.

    You can also host the eTRM within your organization in a common machine/ server - this way it need not be downloaded several times within your organization by individuals.

    If you are facing issues with certain zip files, try to re-download them before unzipping it. If issue persists, please file a Service Request with My Oracle Support, one of our Support Engineers will assist you.

  • Glenn Ruhl Friday, April 9, 2021
    I understand that 11i and 12.0 are in Sustaining Support, but how are the customers who are still using these versions supposed to get the eTRMs for those versions? Sustaining Support is not total desupport; those customers, as well as internal Support, still need access to those eTRMs.
  • Dean Harding Friday, April 9, 2021
    Our DEV team asked me to request that more advance notice be given before removing important resources like this. The site access was taken down before the notice.
    To make matters worse, I have downloaded the etrm patches but like others I am unable to unzip file 2 and 3 without errors. Latter files may have issues too. I opened SR 3-25635623871 yesterday after lots testing but no progress so far.
    We'd appreciate your attention so we can get access again. Thanks!
  • Susan Gardner Monday, April 12, 2021
    The process to download and unzip the eTRM files was problematic and took many hours. When I was finally able to access the downloaded eTRMs, I noticed the Search functionality is missing. Oracle made this change with ZERO advance notice. As a result, I was unable to access the TRMs for several days. Why oh why, Oracle, did you make this more difficult for your customers? Thanks a lot, Oracle. :-(
  • Patti Tipton Monday, April 12, 2021
    Hi, we need the search line that was available in the previous version.
    This is needed for support and clients.
  • Lynn Huang Monday, April 26, 2021
    After download and extraction, I can't find the index.html file to open the browser. There were warnings that missing files during the extraction.
  • AnLee Cox Monday, April 26, 2021
    Search is essential, will this be included in near future versions?
  • Bill Zheng Monday, April 26, 2021
    Hi, it takes hours download and unzip, now the search tab is missing. Please put it back...thank you.

  • Tom Tuesday, April 27, 2021
    Sorry to say but it's just a shame that Oracle removed those static repositories. FOr sure not pro-customer behaviour.

  • Rekha Ayothi Thursday, May 6, 2021

    I understand the concerns raised here. Let me try to answer your queries:

    On Why this change? Why not host the static pages of eTRM?
    The eTRM was built on a set of tools and technology that are no longer supported. To continue to provide the content to customers, we have exported the eTRM to a set of static HTML documents. The eTRM is delivered in a downloadable format as this is the best way for Oracle to continue to provide the content.

    Regarding Search option:
    Search option is not available with the downloadable format of eTRM.

    If you are facing issues with extraction of certain zip files, try to re-download them before unzipping it.
    If issue persists, please file a Service Request with My Oracle Support, one of our Support Engineers will assist you. File the SR against Oracle Applications DBA product.

  • Ben Everett Tuesday, June 8, 2021
    But I don't want to have to download the whole thing. That's kind of absurd. Please bring back the old web page where we could search for tables and a get a list of fields for just the tables we want.
  • Michelle Thomson Thursday, June 17, 2021

    Just to let everyone know I raised an SR with Oracle support they have now logged the following bug :


    I would encourage anyone who wishes to pursue this change to ask their Oracle support representive to register your customer details against the bug to ensure it gains the visibility that it requires.

    Thanks, Michelle
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.