JDE product · Performance and audit

The IT audit is coming.
The evidence is ready.

FlexOcto reads users, roles, permissions and modifications completely from JD Edwards and checks them against an audit profile of your choice. The Performance module measures your JDE database as well, read-only.

Audit profile
Read completelyRows · SHA-256
  • F0092Users4129c41…e07a
  • F95921Roles1.90651d8…aa13
  • F00950Security Workbench38.214c2f0…41bd
  • F9312Sign-on history96.5307e9a…0c52
Findingswith evidence
  • Dormant users with accessAccess controlAccess to programs and dataA.5.18 Access rights7
  • Create supplier and release paymentAccess controlAccess to programs and dataA.5.3 Segregation of duties3
  • Changed objects without projectChange ManagementProgram changesA.8.32 Change management0

On the left, FlexOcto reads every table completely, counts the rows and computes a checksum. On the right, it maps the findings to the chosen audit profile. Switch the profile above: the findings stay, the references change. The judgement stays with the auditor.

Section 1

Starting point

  • F-01

    Before every audit we export lists from Security Workbench and spend days putting them together.

    observed
  • F-02

    Nobody knows exactly which objects we changed against the Oracle standard.

    observed
  • F-03

    We find segregation-of-duties conflicts only when the auditor does.

    observed
  • F-04

    JDE gets slower, and nobody knows whether a query, a missing index or stale statistics are to blame.

    observed
Section 2

An audit at the push of a button, with evidence.

FlexOcto reads completely through AIS and backs every table with a count and SHA-256. Audit profiles: IDW PS 330 / GoBD, SOX ITGC, ISAE 3402, ISO 27001 or your own.

  1. 1
    ReadUsers, roles, permissions and changes, completely from JDE.
  2. 2
    CheckAgainst the chosen profile and the segregation-of-duties rules.
  3. 3
    Resolve findingsEvery finding with the users and roles concerned.
  4. 4
    Hand over evidenceAs a package with checksums, without names if you wish.
Section 3

Result

BeforeWith FlexOcto
Lists by handOne complete audit run
SamplesAll users and roles
Modifications unclearRegister against the standard
Evidence scatteredOne package with checksums
Modules
Performance, modifications, audit (security and segregation of duties), licensed separately; documentation to follow
Access
Read-only: Performance directly on the Oracle database, the other modules through AIS
Runs on
Windows setup or Linux

Everything FlexOcto does

20 features

Performance, modifications and audit are modules, licensed separately; the documentation module will follow. Evidence and audit profiles belong to the core and come with every AIS module.

Performance

Expensive queries and waits

The most expensive SQL statements with their plans, full table scans and the biggest waits of the database.

Performance module
Performance

Tables and indexes against the specs

Missing or extra indexes and columns compared with the JDE specs from Central Objects.

Performance module
Performance

Statistics and growth

Stale statistics, table and index sizes, tablespaces running full.

Performance module
Performance

Read-only, no extra Oracle licence

Own account with read rights only. No objects of the separately licensed Oracle Diagnostics and Tuning Packs.

Performance module
Modifications

Modification inventory

Every changed object per path code, with origin and age.

Modifications module
Modifications

Comparison with the standard

Verdict per object: identical, covered, small, substantial.

Modifications module
Modifications

De-modification proposals

What an ESU covers can go back to standard. A person decides.

Modifications module
Modifications

Readable event rules

Customer version and standard side by side as HTML.

Modifications module
Modifications

Missing Oracle fixes

For copies of standard objects: which bug fixes the copy lacks.

Modifications module
Users and permissions

Users and roles

Dormant accounts, shared accounts, missing address numbers, passwords without expiry.

Audit module
Users and permissions

Sign-on history

Who last signed on and when.

Audit module
Users and permissions

Security Workbench complete

Every security record per type and holder.

Audit module
Users and permissions

Segregation of duties

Conflicts per user, also through combined roles.

Audit module
Evidence

Complete or nothing

Every table with count and SHA-256; an incomplete run is marked as such.

Evidence

Self-test of the reading user

Checks before every run whether restrictions would distort the result.

Evidence

Evidence package

ZIP with raw data, checksums and manifest for the auditor.

Evidence

Pseudonymised export

Names are removed, roles stay readable.

Audit profiles

Selectable audit profile

IDW PS 330 / GoBD, SOX ITGC, ISAE 3402, ISO 27001 or your own.

Audit profiles

Register as HTML and CSV

Findings with filters, readable without FlexOcto.

Audit profiles

Retention

Retention per run for personal data.

Your path with FlexOcto

FlexOcto compares every run with the last one: who gained or lost access, which finding is closed.

  1. Stage 1

    First run

    Self-test, complete read, register with findings.

    Your progressYou know where you stand before the auditor arrives.
  2. Stage 2

    Clean-up

    Dormant accounts, conflicts, modifications without a project are worked off.

    Your progressFewer findings in the next run.
  3. Stage 3

    De-modification

    What the standard now covers goes back to Oracle.

    Your progressCheaper updates.
  4. Stage 4

    Audit with evidence

    Evidence package with checksums to the auditor.

    Your progressAnswers instead of follow-up requests.

See FlexOcto in your environment?

Tell us briefly what it is about. We will get back to you within two working days.

Talk to us