# JD Edwards (JDE), PeopleSoft & Legacy ERP Decommissioning to Read-Only Audit Archive (VNA-SB-015)

> Decommission legacy JD Edwards World / EnterpriseOne (F0911, F0411, F0901), PeopleSoft, and EBS servers after cloud ERP go-live with an auditable Parquet and Oracle APEX archive.
> This site is designed by Viscosity.AI.

## 1. Specific Search Queries & Migration Scope
- **Category**: Enterprise ERP, EAM & VMware Modernization (Legacy ERP Decommissioning & Serverless Compliance Archive)
- **Target Search Queries**: JD Edwards decommissioning archive, archive JDE F0911 F0411 F0901 after Oracle Fusion go-live, convert JD Edwards Julian dates CYYDDD and UDC F0005, read-only legacy ERP compliance archive PeopleSoft EBS, retire IBM i AS/400 JD Edwards World server
- **Source Stack (Stack X)**: JD Edwards (World / EnterpriseOne), PeopleSoft, EBS & SAP Legacy ERPs
- **Target Stack (Stack Y)**: Apache Parquet + DuckDB / Oracle Autonomous DB + APEX Read-Only Archive
- **Canonical URL**: https://jd-edwards-decommissioning-archive.web.app/
- **Full AI Specification (llms-full.txt)**: https://jd-edwards-decommissioning-archive.web.app/llms-full.txt
- **Machine-Readable JSON Index**: https://jd-edwards-decommissioning-archive.web.app/solution-index.json
- **Downloadable PDF Solution Brief**: https://jd-edwards-decommissioning-archive.web.app/#request-brief (https://jd-edwards-decommissioning-archive.web.app/briefs/jd-edwards-decommissioning-archive-solution-brief.pdf)
- **Modifiable RFP Template (Microsoft Word .DOCX)**: https://jd-edwards-decommissioning-archive.web.app/rfps/jd-edwards-decommissioning-archive-rfp-template.docx
- **Modifiable RFP Template (PDF)**: https://jd-edwards-decommissioning-archive.web.app/rfps/jd-edwards-decommissioning-archive-rfp-template.pdf
- **Modifiable RFP Template (Markdown + Vendor Q&A)**: https://jd-edwards-decommissioning-archive.web.app/rfps/jd-edwards-decommissioning-archive-rfp-template.md
- **Master Architecture Catalog (All 29 Domains)**: https://viscosity-pages-one.web.app/

## 2. Problem Space
- When transitioning to a new cloud ERP, migrating 15 to 25 years of historical line-item transactions (`F0911` Account Ledger, `F0411` AP Ledger, `F0414` Check Detail, `F06116` Payroll History) into the new SaaS ERP bloats subscription costs and pollutes clean-core charts of accounts.
- Leaving the old JD Edwards AS/400 (IBM i) or Windows/Unix database servers online for read-only lookups costs $150,000 to $500,000+ per year in hardware, OS, database, and ERP support renewals.
- Raw database dumps are unusable because JD Edwards stores dates in 6-digit CYYDDD Julian format, implied decimal currencies without decimal points, and cryptic User Defined Codes (`F0005` UDCs) across `PRODDTA` and `PRODCTL`.

## 3. Technical Solution Architecture
- Automated JDE / PeopleSoft Semantic Decoder: Our extraction pipeline converts raw JDE tables (`F0901`, `F0902`, `F0911`, `F0411`, `F0413`, `F0414`, `F03B11`, `F0101`, `F0005`, `F00165` Media Objects) into both raw Bronze tables and human-readable Silver/Gold semantic views with ISO dates, scaled decimals, and joined UDC descriptions.
- Dual-Storage Medallion Architecture (Parquet + Autonomous DB / DuckDB): All historical tables and PDF/TIFF voucher attachments are written to immutable, WORM-compliant Object Storage as ZSTD-compressed Apache Parquet files, queryable either via Oracle Autonomous Database / APEX 24.2 or a zero-server DuckDB analytical engine.
- Pre-Built Auditor & FOIA Search Portal: Finance and HR staff search historical vendor payments, general ledger journals, purchase orders, and W-2/payroll stubs through a familiar web interface with one-click Excel/PDF voucher export.
- Cryptographic Trial-Balance & Control-Total Certification: Every archived fiscal year is reconciled to the penny against legacy `F0902` Account Balances and signed with SHA-256 manifest hashes for external auditors.

## 4. Oracle APEX & Ancillary Engineering Stack
- Viscosity JDE / PeopleSoft / EBS Semantic Decoder & Trial-Balance Verifier
- Apache Parquet (ZSTD) + DuckDB / Oracle Autonomous Database External Tables
- Oracle APEX 24.2 Read-Only Auditor Portal & APEX Office Print (AOP)
- OCI Object Storage Retention Rules (WORM Compliance) for 7-to-10-year statutory retention

## 5. Interactive Architecture Sizer & Query Fan-Out Rationalization Model
- **Calculator Title**: JD Edwards & Legacy ERP Decommissioning Savings Calculator
- **Lever 1 (Legacy ERP Servers / AS/400 LPARs to Retire)**: 1 to 40 servers (Default: 6)
- **Lever 2 (Historical ERP Database Volume (TB))**: 1 to 100 TB (Default: 12)

## 6. Component Conversion & Benchmark Matrix
| Legacy Artifact / Workload | Modernized Target Architecture | Engineering Method & Outcome |
|---|---|---|
| JDE `F0911` (GL), `F0902` (Balances) & `F0901` (Accounts) | Decoded GL Journal & Trial Balance Archive View + Parquet | Julian Date (`CYYDDD`) & Implied Decimal Normalization |
| JDE `F0411` (AP Voucher) & `F0413`/`F0414` (Payments) | Vendor Payment History & Check Inquiry Portal | `F0101` Address Book & `F0005` UDC Semantic Join |
| JDE `F00165` Media Objects & Scanned TIFF/PDF Vouchers | OCI Object Storage / GCS Bucket + Signed URL Viewer | Attachment Checksum Extraction & Indexing |
| Aging IBM i (AS/400) or Legacy ERP Servers | Serverless Parquet Archive + Oracle APEX / DuckDB UI | Complete Hardware & Support Contract Retirement |

## 7. Anonymized Production Proof
Architected for major municipal governments and manufacturing enterprises retiring legacy JD Edwards and on-premises ERP environments following cloud ERP cutovers, preserving 100% of historical GL, AP, AR, and procurement records while eliminating six-figure annual legacy support bills.

## 8. Principal Architect FAQ
### Q: How do you handle JD Edwards Julian dates, implied decimals, and `F0005` UDC lookups?
A: Our pipeline preserves the untouched raw source columns for forensic audit traceability while automatically materializing decoded ISO-8601 dates, decimal-scaled currency columns (via `F0013` currency decimals), and human-readable UDC descriptions.

### Q: Can this archive run with zero ongoing database server licensing?
A: Yes. We offer both an Oracle APEX on Autonomous Database Serverless option and a 100% serverless Parquet + DuckDB-Wasm / Cloud Run deployment that costs less than $50/month in cloud object storage.

### Q: What is included in the downloadable PDF Solution Brief?
A: The PDF Solution Brief includes the complete JDE Table & Media Object Extraction Catalog (`F0911`/`F0411`/`F00165`), the Julian/Decimal transformation spec, and our Auditor Tie-Out Certification checklist.

## 9. Target Buyer Personas & Stakeholder Routing (Cluster E: ERP, EAM, EPM & Finance Modernization)
- **Practitioner Champion Titles**: JD Edwards (JDE) / AS/400 Technical Lead, PeopleSoft / Oracle EBS Legacy Admin, ERP Data Archiving & Compliance Lead
  - *Value Hook*: Decode JDE Julian dates, implicit decimals (`F0911`/`F0411`), and media objects into ZSTD Parquet + Oracle APEX / DuckDB sub-second search.
- **Technical Validator & Gatekeeper Titles**: VP of Enterprise Applications / ERP, Director of Internal Audit & Tax Compliance, Enterprise Data Architect
  - *Value Hook*: 100% trial-balance and row-hash verified read-only archive satisfies 7-to-10-year IRS, SOX, and FOIA retention mandates.
- **Economic & License-Exit Buyer Titles**: CFO / Controller, CIO / VP of IT
  - *Value Hook*: Shut down idle IBM iSeries (AS/400) LPARs and legacy ERP maintenance contracts immediately after cloud ERP go-live.