UDC Integrity Inspector

Find UDC inconsistencies / missing UDC codes in JDE

UDC's are at the core of all JDE data. But since there is no referential integrity enforcing the consistency, these codes are usually referenced incongruously, especially in older installations. There is no standard process for finding such inconsistencies, hence this software solution. Clean system is a pre-requisite to successful business.

Current version: 1.1

Order or Inquire

Download

  • Product Brief
  • More Details
  • System Requirements
  • Licensing
Cleaning up your data is well worth the effort: it will significantly minimize the number of nasty surprises in your system at every level of its usage. Do not assume your data is clean: even the standard Demo data is shipped with a huge number of inconsistencies.

This screenshot illustrates the main functionality:

Results Screen

A typical consistency report produced by this tool will look like this (multiple tables can be selected for each run, this sample is for F0101 table alone):

===================================================================
===================================================================
UDC Integrity Inspector report. Executed 2014-12-09 @ 19:37:01 in DV910 as JDE
===================================================================
===================================================================



########## Processing [F0101] with 56 UDC columns #==========>
==> ABATE [H01|AR]
[ ]
==> ABAC01 [01|01]
[910]
[940]
[930]
[920]
[950]
==> ABSYNCS [90CA|SY]
[0]
==> ABPERRS [90CA|SS]
[0]
==> ABCAAD [90CA|SE]
[0]
<========# finished [F0101] #########################]


This sample shows missing UDC codes used in 5 different columns of F0101 table, as well as the column names in the table and the UDC system and product codes linked to them, facilitating an easy way to fix such issues.

This tool is completely client-less: it can communicate directly with any JDE Enterprise Server from any computer. The server needs to have XML kernels configured correctly, if you have any issues, please contact us for help to set this up.

A free Limited Trial can be downloaded, please use it to see how easy it is to keep your system clean!

OS: MS Windows - Any Version/Edition
CPU: Any Intel or AMD CPU
JDE Releases: Any Release from XE and up
Client Machine Software Requirements: Windows
Client Machine Hardware Requirements: Will benefit from any additional capacity above minimal

Per User+Computer, built-in OverTheWEB licensing engine