Skip to main content

JD Edwards Licence Audit

The JD Edwards Licence Audit is a generated report, not a grid. It runs against one connected application and assembles a full compliance-and-optimisation deliverable: what is subscribed, what is actually used, where the financial exposure sits, and how to close it. The output is a polished PDF — or Markdown — ready to hand to a steering committee.

It draws on the data Nomasx-1 already collects — Object Usage Tracking, role and permission assignments, the segregation-of-duties matrix and the per-application licence inventory — and turns it into a single narrative document.

JDE-specific

This report targets a JD Edwards EnterpriseOne application and its Oracle technology foundation. The connected application is identified by its Nomasx-1 apps_id.

At a glance​

Nomasx-1 · ReportsAudit Licences JD EdwardsCompliance + optimisation analysisfor one application.PDFmarkdownPARAMETERSApplicationrequiredTarget connectornomasx1SchemapublicAudit date label · Client nameoptionalRun & downloadFormat

The deliverable​

A confidential, branded document of roughly thirty to forty pages — PDF for the steering committee, Markdown when you want to edit or embed it. The cover carries the title Audit Licences JD Edwards – {client}, the subtitle Analyse de conformité et plan d'optimisation des licences Oracle, and a Client / Date / Author / Version block; every page is footed Confidentiel.

The report is generated in French by default (the working language of the audit); switch the Language parameter to English for a fully English deliverable.

It is an internal compliance-and-optimisation document — the basis for your own decisions and for preparing a contract renewal, not a declaration to hand to the vendor.

Headline KPIs and inline charts​

The executive summary opens on a KPI band and a small set of inline SVG charts, so the message reads in seconds before the reader dives into the detail:

  • Stat band — active users, never-used accounts, quantifiable financial risk (€) and unassigned roles.
  • Active-users donut — used vs never-used across the audited population.
  • Components-by-usage bar — the Oracle components in use ranked by consumption.
  • Financial-risk-by-component bar — the euro-denominated exposure sized per component.

The charts render inline in both PDF and Markdown output — no external image assets, no dependency on a chart engine at render time.

What the report contains​

Nine sections, each built from the data Nomasx-1 has collected:

  1. Synthèse — executive summary: context and objectives, the principal findings each with a risk level, the estimated financial exposure, and the key recommendations.
  2. Périmètre de l'audit — audited components, what is out of scope, the JD Edwards environments table (production vs non-production), and the technical architecture: software versions, a server inventory, and an architecture diagram the report generates automatically.
  3. Méthodologie — the tools and data used, the analysis rules (usage is measured from real consumption, not from authorisations), and a data-sources table that dates every input.
  4. Licences acquises — the subscribed inventory: Oracle Database Enterprise Edition (NUP), the options and packs, the components detected in use, the règle des minimas and the NUP minimum computed from the processor count; then the JD Edwards Oracle Technology Foundation and the application modules.
  5. Utilisation et conformité — the core of the report:
    • JD Edwards modules cross-referenced OUT × transactions — real consumption versus write activity — with a drill-down on low-usage modules (which user touched which object);
    • authorisations versus real usage per module (authorised users vs OUT vs transactions vs number of roles), which surfaces access far wider than actual use;
    • the optimisation analysis (see below);
    • the Oracle Technology Foundation user analysis (declared / active / disabled, technical accounts, role assignments) and the Oracle database user count.
  6. Risque financier — the calculation method (Oracle public price list plus three years of support arrears), each identified risk costed line by line, a consolidated figure, the prioritised levers, and an analysis of any Oracle quotes currently in negotiation.
  7. Plan de remédiation — concrete clean-up: deactivating never-used accounts, and rationalising roles and access (dropping unassigned roles, reviewing excessive role stacking, aligning access to real use).
  8. Recommandations et plan d'action — every action ranked by priority, effort and financial impact, an indicative four-phase schedule, and the follow-up indicators to track afterwards.
  9. Annexes — the detailed list of users to deactivate (with creation and last-update dates, and the validation cautions to apply before disabling) and a glossary.

The optimisation analysis​

Beyond pure compliance, the report mines the detailed OUT extract — one row per user × module × object — to size licences to real need rather than to the blanket "full use" grant:

  • the distribution of modules-per-user (most users touch only a handful of modules);
  • the most frequent module combinations, which cluster around a commercial / logistics core;
  • two usage profiles — Standard (the core) and Étendu (the core plus at least one specialised module);
  • a proposed split into differentiated bundles to take into a contract renewal.

This is what turns the audit from a compliance snapshot into a cost-optimisation lever — the section the renewal negotiation is built on.

Running the report​

The report lives under Reports in the Nomasx-1 sidebar, on the framework's Run a report and download the result as PDF or markdown page. Pick Audit Licences JD Edwards from the list, fill the parameters, choose a Format, then Run & download.

ParameterRequiredDefaultWhat it sets
ApplicationYes—The application to audit. Picked by name from the registered applications (Settings → Global → Applications) — the run form resolves the name to the underlying apps_id.
Target connectorNonomasx1Dropdown of the SQL connectors on the install.
SchemaNopublicDropdown of the schemas of the picked target connector.
LanguageNoFrançaisReport language — Français or English.
Audit date labelNocurrent month + yearThe label printed on the cover page (e.g. Mai 2026).
Client nameNothe application nameThe client name on the cover page.

Every dropdown resolves server-side against live catalogs — Application against the applications registry, Target connector against the configured SQL connectors and Schema against the schemas of the picked connector. Cascading defaults mean picking a connector re-lists its own schemas.

Format — PDF for the steering-committee deliverable, markdown when you want to edit or embed the content. The run streams the file straight back to the browser.

Every month, by e-mail — Jobs → Licence audit report renders the same PDF for one or several applications and mails it to the auditors' role; scheduled on the 1st of the month once enabled. See Nomasx-1 jobs.

Before you run​

The audit reads the data Nomasx-1 has already collected for the application — it does not collect on the fly. For an accurate picture, make sure the latest collection has run first. The report draws on:

  • Object Usage Tracking — the synthesis (distinct users per module), the detail (users / objects / dates) and the fine detail (one row per user × module × object) that drives the Utilisation et conformité and optimisation sections.
  • Modules with transactions — users who generated at least one write per module.
  • The JD Edwards user list — declared, active and disabled users, with creation and last-usage dates.
  • Roles, user-role assignments and access rights per role, plus the JDE menus (object → module mapping) that link usage to modules.
  • The database options and packs inventory — Oracle components in use versus subscribed.
  • The licence inventory and pricing (Licenses and Settings → Pricing), otherwise the financial figures drift from the real price book.

A run against an application with no collected usage still produces the document, but the usage and financial sections will read as empty rather than wrong.

Tips & best practices​

  • Run it after a fresh collection. The audit is a snapshot of the current tables — schedule it right after the nightly collection so the figures match reality.
  • Set the Audit date label and Client name for an external-ready cover page; leave them empty for an internal draft.
  • Use markdown to iterate, PDF to deliver. The Markdown output is the same content without the cover styling, handy for review before the final export.
  • Read it next to the source screens. Every figure traces back to a screen — Object Usage Tracking, Conflicts, Licenses — so a reviewer can drill from the audit into the live data.