Results 1 to 5 of 5

Thread: How to generate report on license numbers and modules used

  1. #1

    Question How to generate report on license numbers and modules used


    I am a project manager at our Town corporation. I've already asked our JDE Systems analyst/amin and they do not have an answer for this.

    We'd like to run a report or SQL query to get this type of information if possible:

    1.) All modules/components installed (i.e. GL, AP, AR, GL, Contract Management, AM, etc) and sub-components
    2.) Of the modules installed (by matching against other tables) determine if they have ever been used (i.e.: someone ever created a record(s) in that module/sub-component)
    3.)Licenses available VS Used by Users for each component.
    4.) When was the last time a module was used (not for each user, but by anyone).

    Is this available as a canned report or has someone the SQL query(s) to pull this report?

    Much appreciated.

    Thank You


  2. #2
    Great query . I would like to know of such a canned report if possible . Pls share if anyone has any info .

  3. #3
    Nice thread.
    I believe you have to scan transaction tables for each module to find if any users has a entry for last 12 months

    Love to see if anyone has done that as there are many modules and tons of transaction tables for each module etc.



  4. #4
    My perspective on your questions:
    1. The modules are all installed in JDE E1 when it comes to applications. I don't know what you mean by sub-components - if you are referring to things like orchestrator, BSSV, UXOne... in the Tools layer, there would be additional installs.
    2. Since modules are generally defined by system codes (characters 2 & 3 in table names), have your DBA run a query to list the tables and record counts for all tables in JDE_PRODUCTION (whatever your PD database is called). There may be some tables that are preloaded with records, but generally, the tables should be empty if not used. So, for example, if F34 tables are mostly empty, no one has used MRP.
    3. I don't know the details of licensing and, I believe, there can be different models so you would want to refer to your contract with Oracle.
    4. For system codes that have row counts, pick a table or two with larger counts. Run a query on that table looking at audit fields - usually UPMJ and UPMT/TDAY to see when last updated.
    Current: E1 9.2, TR, Win2012 R2, SQL Server 2014 R2, Weblogic, OneView, Embedded BIP
    Upgrade: E1 9.1, TR, Win2008 R2, SQL Server 2008 R2, WebLogic, OneView, Embedded BIP
    Original: E1 8.0, SP 24.1.2, Win2003, SQL Server 2005 SP3, all fat client

  5. #5
    Thank you JMast for the response. This will be helpful.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.