Media
3 items
Description
JDE productivity tools: YYYYMMDD↔CYYDDD date conversion, DS batch import, and field ID display for JDE HTML5. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ JDE Tools — Date Converter, DS Batch Import & Field ID Revealer ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ A Chrome extension built exclusively for Oracle JD Edwards EnterpriseOne (JDE) HTML5 client users — including business operators, ERP administrators, and JDE developers. If you work with JDE every day, you have almost certainly run into these three frustrations: First, JDE stores dates in its own CYYDDD format, completely different from the YYYYMMDD format used everywhere else. Knowing that "126120" means April 30, 2026 is not at all intuitive — yet you need to read, enter, and communicate these dates constantly. Second, when you need to enter dozens or hundreds of values into a Data Selection (DS) screen for a batch job, JDE gives you no choice but to type them in one by one. There is no bulk-entry mechanism built into the standard product. Third, when customizing JDE, building Orchestrations, or calling the AIS (Application Interface Services) API, you need to know the technical field ID (AIS ID or Alias) of each input field. Finding them requires digging through Chrome DevTools or a separate development tool. JDE Tools solves all three problems with a single lightweight extension. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Feature 1 — YYYYMMDD ↔ CYYDDD Date Converter ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ▌ Understanding the JDE Date Format JDE stores dates in a Julian format called CYYDDD: C → Century code: 0 = 1900s, 1 = 2000s YY → Two-digit year (2026 = 26) DDD → Day of year (January 1 = 001, December 31 = 365 or 366) Examples: 20260101 → 126001 (January 1, 2026, day 1 of the year) 20261231 → 126365 (December 31, 2026, day 365 of the year) 126120 → 20260430 (Century 1, year 26, day 120 = April 30, 2026) JDE users deal with this conversion dozens of times a day — entering dates into batch jobs, querying records, reading reports, and communicating results to colleagues. Every manual conversion wastes time and introduces the risk of error. This extension makes the conversion instantaneous and automatic. ▌ Popup Converter Click the toolbar icon to open the popup. Type any date and the format is detected automatically. 8-digit input → recognized as YYYYMMDD → displays CYYDDD result 6-digit input → recognized as CYYDDD → displays YYYYMMDD result The "Today" button converts today's date in a single click. The "Copy" button copies the result to your clipboard immediately. The C / YY / DDD components are explained individually so you can understand exactly what each digit means. The day of the week is shown alongside the converted date. Recent conversion history is saved automatically for quick reuse. The converter also handles slash and hyphen date formats: 26/04/30, 2026-04-30, 26.04.30, and similar patterns are all recognized and converted to CYYDDD automatically. ▌ Right-Click Context Menu Conversion Select any date number on any web page by dragging, then right-click. A "Convert Date: [selected text]" menu item appears. Click it and: ✔ A toast notification appears at the top-right of the screen, showing the conversion result for 3 seconds. ✔ The converted value is automatically copied to your clipboard. ✔ No popup needed — conversion is done instantly, right on the page. This works on any web page: JDE screens, emails, documents, spreadsheets, internal portals, and more. If the selected text cannot be converted, a clear error toast explains why. ▌ Toolbar Badge The Chrome toolbar icon displays today's CYYDDD date as a badge. Glance at the icon and you always know today's JDE date — no calculation needed. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Feature 2 — DS (Data Selection) Batch Import ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ▌ The Problem with JDE Data Selection When running a JDE batch job (UBE — Universal Batch Engine), you frequently need to define the scope of data to be processed using the Data Selection (DS) screen. This screen lets you specify conditions such as: "Process only the following business units," or "Run for these specific address book numbers." The standard JDE workflow requires you to enter each value individually, one line at a time. For 10 values, that is manageable. For 50, 100, or 500 values, it can take half an hour of repetitive clicking and typing — a genuine productivity bottleneck for any JDE power user. ▌ How DS Batch Import Works ① Open the JDE Data Selection screen. (Click the "Data Selection" button on a batch job version prompt.) ② Right-click anywhere on the page and select "JDE DS Batch Import" from the context menu. ③ In the popup dialog, enter your values one per line, or click "Open CSV" to load them from a file. The tool auto-detects which column in the CSV contains your values. ④ Click "Start Import." Values are submitted to JDE one by one via the same server API that JDE uses internally. Progress is shown in real time: how many have been processed, how many were skipped, and the total. ⑤ When complete, verify the DS conditions in JDE and run your batch job. ▌ Key Capabilities • Handles hundreds of values in a single operation • Real-time progress display: processing / skipped / complete • If an error occurs partway through, "Re-import" resumes from the point of failure — no need to start over • Cancel at any time during the import • Direct CSV file loading from your desktop • Full multilingual UI (18 languages) ▌ Who Benefits Most Finance teams processing month-end journal entries for selected accounts. Logistics teams running batch jobs for specific order numbers. HR teams targeting a list of employee IDs for period-end processing. IT administrators re-running failed batch jobs with a curated subset. Anyone who has ever spent 20 minutes manually entering values into a JDE DS screen will immediately understand the value of this tool. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Feature 3 — JDE Field ID Revealer ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ▌ Why Field IDs Matter JDE HTML5 screens contain dozens of input fields, grid columns, dropdown menus, and buttons. Every one of them has a technical identifier that JDE developers and administrators need regularly: • Writing or modifying Orchestrations (JDE Orchestrator) • Calling the AIS (Application Interface Services) REST API • Building custom JDE forms or business function calls • Debugging data issues ("Which DB column does this field map to?") • Writing technical documentation for JDE customizations In standard JDE, the only way to find a field's AIS ID or Alias is to open Chrome DevTools, navigate the DOM tree, and look for the relevant attribute — a tedious process that interrupts your workflow. The Field ID Revealer overlays all IDs directly on the JDE screen, right next to the fields they belong to, with no DevTools required. ▌ How to Use Method A — Via Popup: Click the toolbar icon, open the popup, and select a display mode from the "Field IDs" dropdown. Method B — Via Right-Click Menu: Right-click on any JDE HTML5 page and select "JDE Field ID: Show / Hide." One click to show, one more click to hide (toggle behavior). ▌ Display Modes AIS ID + Alias (default): Shows both the AIS ID and Alias for every field — maximum information. AIS ID only: Shows only AIS IDs — less visual clutter. Alias only: Shows only Alias (ddinfo) values. Off: Removes all overlaid labels. ▌ What Gets Labeled • Form input fields (text boxes, dropdowns, radio buttons, action buttons) • Grid column headers — IDs are fetched from the JDE server API for accuracy, matching exactly what the AIS API expects. • Top menu bar links — their JDE internal action IDs are shown. ▌ Smart Auto-Reapply Once you turn on Field ID display, it stays on as you navigate through JDE screens. Each time JDE loads a new form, the extension detects the page change and automatically reapplies the labels. There is no need to click "show" again after every screen transition — a significant time saver during extended development or debugging sessions. The last display mode you used is remembered and restored the next time you toggle the feature on. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Multilingual Support — 18 Languages ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Every part of the user interface is fully translated into 18 languages: the popup UI, DS batch import dialog, all error messages, and all toast notifications. Supported languages: Korean · English · Japanese · Chinese (Simplified) · Chinese (Traditional) French · German · Spanish · Portuguese · Russian · Arabic · Hindi Indonesian · Italian · Mongolian · Thai · Turkish · Vietnamese Switch languages at any time from the language menu in the popup. Your selection is saved and applied immediately everywhere in the extension. JDE is deployed in organizations around the world. Whether your team is in Seoul, Tokyo, São Paulo, Paris, or Jakarta, every user can work in their own language. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Privacy & Security ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ JDE Tools does not transmit any user data to external servers. • No remote server communication of any kind • No remote code execution — all JavaScript is bundled within the extension package installed on your device • All date conversion logic runs locally in your browser • The only data stored: your language preference, date conversion history, and field ID display mode — saved to browser local storage only, never sent anywhere • No personally identifiable information (PII) is collected • No third-party libraries — built entirely on standard Chrome Extension Manifest V3 APIs JDE systems run on corporate internal infrastructure and often contain sensitive business data. You can install this extension with confidence that it will never touch your JDE data. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Permissions — Why Each One Is Needed ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ • contextMenus Adds "Convert Date," "JDE DS Batch Import," and "JDE Field ID: Show / Hide" items to the right-click context menu. • scripting Injects the toast notification, DS import dialog, and field ID labels into the active web page when a menu item is clicked. Only locally bundled code is ever injected — no remote scripts. • activeTab Identifies the currently active tab so that injected scripts are targeted at the correct page when triggered by a user action. • storage Saves your language preference, date conversion history, and field ID display mode to browser-local storage. • Host permissions (all http/https URLs) JDE HTML5 is deployed by each organization on its own servers — there is no fixed domain name. To work with any organization's JDE environment, the extension must be able to run on any URL. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Compatibility & Requirements ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ • Browser: Google Chrome (latest version recommended) • Required environment: Oracle JD Edwards EnterpriseOne HTML5 client (The classic JDE Java or Windows fat client is not supported.) • Built on Manifest V3, fully compliant with Chrome's latest security and performance standards. The date converter and field ID features work safely on any web page — if JDE structures are not detected, the extension does nothing and produces no errors. The DS batch import feature only activates on JDE Data Selection screens. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Getting Started ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ① Install the extension from the Chrome Web Store. ② Optionally assign a keyboard shortcut to open the popup: Visit chrome://extensions/shortcuts and set a shortcut for "Open JDE Tools popup." ③ Click the toolbar icon, select your preferred language. ④ Open your JDE HTML5 client and start working smarter. ───────────────────────────────────────────────── Stop wasting time on repetitive JDE tasks. One extension. Three powerful tools. Built for JDE. ─────────────────────────────────────────────────