# Viscosity.AI Enterprise Architecture & Legacy Modernization Catalog (29 Solution Domains) > Master directory of 29 search-intent technical architecture portals, interactive TCO & query fan-out calculators, and downloadable PDF Solution Briefs. > This site is designed by Viscosity.AI. ## Catalog Endpoints - **Master Catalog Hub**: https://viscosity-pages-one.web.app/ - **Master LLMs Manifest**: https://viscosity-pages-one.web.app/llms.txt - **Full Technical Compendium (All 29 Domains)**: https://viscosity-pages-one.web.app/llms-full.txt - **Machine-Readable Registry JSON**: https://viscosity-pages-one.web.app/solution-index.json - **Master XML Sitemap**: https://viscosity-pages-one.web.app/sitemap.xml ## All 29 Standalone Solution Domains (`.web.app`) ### [VNA-SB-001] PowerBuilder to Oracle APEX Migration & Automated PBL Conversion (https://powerbuilder-to-apex.web.app/) - **Category**: Application Stack X to Application Stack Y / Client/Server Desktop to Oracle Low-Code - **Search Queries**: PowerBuilder to Oracle APEX migration, PowerBuilder modernization tool, convert PowerBuilder DataWindow to web, decompile PowerBuilder PBL to SQL and PL/SQL, Appeon PowerBuilder alternative Oracle APEX, replace PowerBuilder Citrix thick client - **Source Stack**: Sybase / Appeon PowerBuilder (.pbl, .srd, .srw, DataWindows, PowerScript) - **Target Stack**: Oracle APEX 24.2, Oracle REST Data Services (ORDS), PL/SQL Packages & AMP - **Summary**: Searching for PowerBuilder modernization or how to migrate PowerBuilder (.pbl, DataWindow .srd, PowerScript) to Oracle APEX 24.2? Convert PBLs automatically. - **Anonymized Proof**: For a multi-site industrial and logistics operator running 420+ PowerBuilder windows and 1,100 DataWindows over a legacy relational schema, our AST reverse-engineering pipeline extracted 100% of embedded SQL and business rules in 3 weeks, delivering a governed Oracle APEX 24.2 web platform in 16 weeks and retiring 14 Citrix servers. - **PDF Solution Brief**: https://powerbuilder-to-apex.web.app/briefs/powerbuilder-to-apex-solution-brief.pdf - **Domain LLMs.txt**: https://powerbuilder-to-apex.web.app/llms.txt ### [VNA-SB-002] PowerBuilder to Google Cloud Migration (Cloud Run, React & AlloyDB) (https://powerbuilder-to-gcp.web.app/) - **Category**: Application Stack X to Application Stack Y / Client/Server Desktop to Google Cloud Native - **Search Queries**: migrate PowerBuilder to Google Cloud, convert PowerBuilder to React and Cloud Run, PowerBuilder DataWindow to REST API, PowerBuilder Sybase to Google AlloyDB migration, reverse engineer PowerBuilder application to cloud - **Source Stack**: PowerBuilder (.pbl, DataWindows, PowerScript) + Sybase / SQL Server / Oracle - **Target Stack**: Google Cloud Run, React/TypeScript, AlloyDB / Cloud SQL & BigQuery - **Summary**: Migrate legacy PowerBuilder desktop applications (.pbl, DataWindows, PowerScript) to Google Cloud Run, React, AlloyDB for PostgreSQL, and BigQuery. - **Anonymized Proof**: For a regional healthcare and diagnostics network migrating off on-premises Windows servers to Google Cloud, we parsed 180+ PowerBuilder modules and 600+ DataWindows, converting the transactional tier to Cloud Run + AlloyDB and offloading 90+ operational reports to BigQuery in 14 weeks. - **PDF Solution Brief**: https://powerbuilder-to-gcp.web.app/briefs/powerbuilder-to-gcp-solution-brief.pdf - **Domain LLMs.txt**: https://powerbuilder-to-gcp.web.app/llms.txt ### [VNA-SB-003] Oracle Forms Modernization: Convert Oracle Forms & Reports (.fmb / .rdf) to APEX 24.2 (https://oracle-forms-modernization.web.app/) - **Category**: Application Stack X to Application Stack Y / Oracle Legacy Forms & Reports to APEX 24.2 - **Search Queries**: Oracle Forms modernization, migrate Oracle Forms to APEX, Oracle Forms 12c to APEX conversion tool, Oracle Forms 6i 10g 11g end of life replacement, Oracle Reports RDF to APEX Office Print BI Publisher, retire Oracle WebLogic Server Forms licensing - **Source Stack**: Oracle Forms & Reports 6i / 10g / 11g / 12c (.fmb, .mmb, .pll, .rdf) - **Target Stack**: Oracle APEX 24.2, ORDS, PL/SQL Packages, AOP & AMP - **Summary**: Complete Oracle Forms modernization: convert Oracle Forms 6i, 10g, 11g, and 12c (.fmb, .pll) and Oracle Reports (.rdf) to native Oracle APEX 24.2 and retire WebLogic. - **Anonymized Proof**: For a major regional healthcare payer and a large metropolitan public school district, we analyzed and converted hundreds of legacy Oracle Forms (.fmb) and Reports (.rdf) modules into governed Oracle APEX workspaces integrated with Microsoft Entra ID SSO, eliminating WebLogic support renewals and cutting report runtimes by 80%. - **PDF Solution Brief**: https://oracle-forms-modernization.web.app/briefs/oracle-forms-modernization-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-forms-modernization.web.app/llms.txt ### [VNA-SB-004] FOEX Plugin Migration: Replace Discontinued FOEX (ExtJS) with Native Oracle APEX 24.2 (https://foex-plugin-migration-apex.web.app/) - **Category**: Application Stack X to Application Stack Y / Discontinued APEX Plugin Framework to Native APEX 24.2 - **Search Queries**: FOEX plugin migration Oracle APEX, FOEX discontinued replacement APEX 24.2, upgrade Oracle APEX with FOEX Sencha ExtJS plugins, convert FOEX Grid to APEX Interactive Grid, remove COM.FOEX plugins from Oracle APEX - **Source Stack**: FOEX Plugin Framework (Sencha ExtJS Wrapper on Legacy APEX 5.x / 18.x / 19.x / 20.x) - **Target Stack**: 100% Native Oracle APEX 24.2 (Universal Theme 42, Native Grids, Dynamic Actions) - **Summary**: Blocked from upgrading Oracle APEX by discontinued FOEX (Sencha ExtJS) plugins? Migrate COM.FOEX grids, viewports, and forms to 100% native Oracle APEX 24.2. - **Anonymized Proof**: For Ivy League university administration systems and major county justice/prosecutor case management platforms locked on legacy FOEX versions, our engineering team cataloged and converted hundreds of FOEX plugin regions into 100% native Oracle APEX 24.2, eliminating third-party subscription fees and restoring one-click APEX patching. - **PDF Solution Brief**: https://foex-plugin-migration-apex.web.app/briefs/foex-plugin-migration-apex-solution-brief.pdf - **Domain LLMs.txt**: https://foex-plugin-migration-apex.web.app/llms.txt ### [VNA-SB-005] Adobe ColdFusion, Classic ASP & VB6 Migration to Oracle APEX 24.2 (https://coldfusion-to-oracle-apex.web.app/) - **Category**: Application Stack X to Application Stack Y / Legacy Web Scripting & VB6 to Oracle APEX - **Search Queries**: Adobe ColdFusion to Oracle APEX migration, replace legacy ColdFusion CFM CFC applications, Classic ASP VBScript to Oracle APEX conversion, Visual Basic 6 VB6 database app modernization, eliminate ColdFusion Server licensing and CVEs - **Source Stack**: Adobe ColdFusion (.cfm, .cfc), Classic ASP (.asp), VB6 & PHP - **Target Stack**: Oracle APEX 24.2, ORDS REST APIs, PL/SQL & Autonomous Database - **Summary**: Migrate legacy Adobe ColdFusion (.cfm, .cfc), Classic ASP (.asp), and Visual Basic 6 (VB6) database applications into secure, governed Oracle APEX 24.2. - **Anonymized Proof**: Across public sector education service centers and mid-market enterprises, our engineering team has retired dozens of legacy ColdFusion, Classic ASP, and VB6 applications, consolidating them into multi-tenant Oracle APEX 24.2 portals with Entra ID SSO and zero middle-tier licensing costs. - **PDF Solution Brief**: https://coldfusion-to-oracle-apex.web.app/briefs/coldfusion-to-oracle-apex-solution-brief.pdf - **Domain LLMs.txt**: https://coldfusion-to-oracle-apex.web.app/llms.txt ### [VNA-SB-006] Legacy .NET WinForms & ASP.NET WebForms (.aspx) Migration to Oracle APEX 24.2 (https://dotnet-winforms-to-apex.web.app/) - **Category**: Application Stack X to Application Stack Y / Legacy .NET Framework to Oracle APEX & Cloud - **Search Queries**: migrate ASP.NET WebForms ASPX to Oracle APEX, WinForms thick client to web modernization, replace WCF SOAP services with ORDS REST APIs, .NET Framework 4.8 end of life database app migration, Telerik RadGrid DevExpress to APEX Interactive Grid - **Source Stack**: .NET Framework 2.0-4.8 (WinForms, WebForms .aspx, WCF, C# / VB.NET) - **Target Stack**: Oracle APEX 24.2, ORDS REST APIs, PL/SQL & OCI Cloud Native - **Summary**: Modernize legacy .NET Framework WinForms, ASP.NET WebForms (.aspx), Telerik grids, and WCF SOAP services into stateless Oracle APEX 24.2 and ORDS REST APIs. - **Anonymized Proof**: For multiple enterprise and public-sector clients running aging C#/.NET WebForms and WinForms applications over Oracle and SQL Server, we consolidated scattered IIS application servers into governed Oracle APEX 24.2 environments with native Microsoft Entra ID authentication, reducing annual maintenance hours by over 60%. - **PDF Solution Brief**: https://dotnet-winforms-to-apex.web.app/briefs/dotnet-winforms-to-apex-solution-brief.pdf - **Domain LLMs.txt**: https://dotnet-winforms-to-apex.web.app/llms.txt ### [VNA-SB-007] Microsoft Access (.accdb / .mdb) & Excel VBA Macro Migration to Oracle APEX 24.2 (https://ms-access-excel-to-apex.web.app/) - **Category**: Application Stack X to Application Stack Y / Shadow IT Excel & MS Access to Governed APEX - **Search Queries**: convert Microsoft Access to Oracle APEX, migrate MS Access ACCDB MDB to web application, replace Excel VBA macros with Oracle APEX, spreadsheet to web app conversion Oracle, shadow IT Access database replacement - **Source Stack**: Microsoft Excel (.xlsx, VBA Macros), MS Access (.accdb/.mdb) & Lotus Notes - **Target Stack**: Oracle APEX 24.2 Data Apps, Autonomous Database & AMP Governance - **Summary**: Convert multi-user Microsoft Access databases (.accdb, .mdb) and complex Excel VBA macro workbooks (.xlsm) into governed, web-based Oracle APEX 24.2 applications. - **Anonymized Proof**: From private-equity branch acquisition onboarding and trial-balance ingestion to multi-country restaurant tip/payroll management and construction jobsite timesheets, we have replaced hundreds of mission-critical Excel and Access shadow-IT systems with governed Oracle APEX Data Apps. - **PDF Solution Brief**: https://ms-access-excel-to-apex.web.app/briefs/ms-access-excel-to-apex-solution-brief.pdf - **Domain LLMs.txt**: https://ms-access-excel-to-apex.web.app/llms.txt ### [VNA-SB-008] Oracle 7.3.4, 8i & 9i Solaris SPARC to Oracle 23ai Migration (ORA-28040 / SQL*Net V2) (https://oracle-7-to-23ai-migration.web.app/) - **Category**: Database X to Database Y / Legacy Wire-Protocol Gateway & Multi-Decade Upgrade - **Search Queries**: migrate Oracle 7.3.4 to 19c 23ai, ORA-28040 No matching authentication protocol Oracle 7 8i 9i, SQL*Net v2 to Oracle 23ai protocol gateway, retire Sun Solaris SPARC Oracle 7 database, OCI7 O3LOGON compatibility Oracle 19c 23ai - **Source Stack**: Oracle7 (7.1.3 / 7.3.4) & Oracle8i/9i on Solaris SPARC / HP-UX (SQL*Net V2 / TNS) - **Target Stack**: Oracle Database 23ai / 26ai on Linux / OCI via Wire-Level Protocol Gateway - **Summary**: Solve ORA-28040 and ORA-03134. Migrate legacy Oracle 7 (7.1.3 / 7.3.4), 8i, and 9i databases off Solaris SPARC to Oracle 23ai without modifying frozen 32-bit client binaries. - **Anonymized Proof**: Engineered specifically for organizations trapped on end-of-life Solaris SPARC and HP-UX servers running Oracle 7.1.3 and 7.3.4 with unmodifiable 32-bit client binaries, our wire-protocol gateway retires legacy RISC hardware in weeks without requiring a multi-year application rewrite first. - **PDF Solution Brief**: https://oracle-7-to-23ai-migration.web.app/briefs/oracle-7-to-23ai-migration-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-7-to-23ai-migration.web.app/llms.txt ### [VNA-SB-009] HP-UX, IBM AIX & Solaris SPARC to Oracle Database Appliance (ODA X11) Migration (https://hpux-aix-solaris-to-oda.web.app/) - **Category**: Database X to Database Y / Legacy Big-Endian RISC Unix to Engineered Systems - **Search Queries**: migrate Oracle from AIX to Linux ODA, HP-UX Itanium Oracle 11g 19c migration to Linux, Solaris SPARC big endian to little endian RMAN XTTS v4, Oracle Database Appliance ODA X11 capacity on demand licensing, reduce Oracle processor licenses with ODA hard partitioning - **Source Stack**: Oracle on HP-UX IA64/PA-RISC, IBM AIX Power & Solaris SPARC - **Target Stack**: Oracle Database Appliance (ODA X10 / X11) & Exadata Cloud@Customer - **Summary**: Cross-endian Oracle database migration from HP-UX IA64, IBM Power AIX, and Solaris SPARC to Oracle Database Appliance (ODA X11) with Capacity-on-Demand licensing. - **Anonymized Proof**: Across clinical research organizations, healthcare physician networks, national laboratories, and global satellite operators, our Oracle ACE infrastructure team has executed dozens of HP-UX, AIX, and Solaris migrations to Oracle Database Appliance (ODA) and Exadata Cloud@Customer with zero unplanned downtime. - **PDF Solution Brief**: https://hpux-aix-solaris-to-oda.web.app/briefs/hpux-aix-solaris-to-oda-solution-brief.pdf - **Domain LLMs.txt**: https://hpux-aix-solaris-to-oda.web.app/llms.txt ### [VNA-SB-010] SAP Sybase ASE & SQL Anywhere to Oracle Database 23ai Migration (T-SQL to PL/SQL) (https://sybase-ase-to-oracle-migration.web.app/) - **Category**: Database X to Database Y / Cross-Engine Relational & Procedural Conversion - **Search Queries**: Sybase ASE to Oracle migration, SAP SQL Anywhere to Oracle Database conversion, convert Sybase Transact-SQL T-SQL to Oracle PL/SQL, Sybase ASE 16 end of mainstream maintenance migration, refactor Sybase #temp tables to Oracle 23ai - **Source Stack**: SAP / Sybase ASE (12.5 / 15.x / 16.0), SQL Anywhere & Watcom-SQL - **Target Stack**: Oracle Database 23ai / Autonomous Database, PL/SQL & Oracle APEX - **Summary**: Migrate SAP Sybase ASE 15/16 and SQL Anywhere databases to Oracle Database 23ai. Automated Transact-SQL (T-SQL) stored procedure, #temp table, and trigger conversion to PL/SQL. - **Anonymized Proof**: Paired frequently with our PowerBuilder-to-APEX modernizations, we have migrated multi-hundred-gigabyte Sybase ASE and SQL Anywhere databases containing thousands of T-SQL stored procedures into Oracle Database 19c/23ai, eliminating nightly batch deadlocks and cutting end-of-month close times by 70%. - **PDF Solution Brief**: https://sybase-ase-to-oracle-migration.web.app/briefs/sybase-ase-to-oracle-migration-solution-brief.pdf - **Domain LLMs.txt**: https://sybase-ase-to-oracle-migration.web.app/llms.txt ### [VNA-SB-011] Microsoft SQL Server, SSIS & SSRS Migration to Oracle Autonomous Database 23ai & OCI (https://sql-server-to-oracle-oci.web.app/) - **Category**: Database X to Database Y / SQL Server Consolidation & Autonomous Uplift - **Search Queries**: migrate SQL Server to Oracle Autonomous Database 23ai, convert SSIS DTSX packages to OCI Data Integration, migrate SSRS RDL reports to Oracle APEX and OAC, SQL Server Enterprise licensing consolidation on OCI, convert SQL Server T-SQL to Oracle 23ai PL/SQL - **Source Stack**: Microsoft SQL Server (2008 R2 - 2022), T-SQL, SSIS & SSRS - **Target Stack**: Oracle Database 23ai / Autonomous Database on OCI (or SQL Server on OCI) - **Summary**: Migrate Microsoft SQL Server databases, T-SQL procedures, SSIS (.dtsx) ETL packages, and SSRS (.rdl) reports to Oracle Autonomous Database 23ai and APEX on OCI. - **Anonymized Proof**: For a major title insurance and real estate services enterprise as well as multi-branch retail and fitness platforms, we consolidated legacy SQL Server CRM and operational databases, automated ETL pipelines, and eliminated recurring SSRS/Windows Server licensing bottlenecks. - **PDF Solution Brief**: https://sql-server-to-oracle-oci.web.app/briefs/sql-server-to-oracle-oci-solution-brief.pdf - **Domain LLMs.txt**: https://sql-server-to-oracle-oci.web.app/llms.txt ### [VNA-SB-012] Oracle to PostgreSQL & AlloyDB Migration vs. Oracle SE2 / ODA License Right-Sizing (https://oracle-to-postgresql-migration.web.app/) - **Category**: Database X to Database Y / Polyglot Database Right-Sizing & Cross-Engine Engineering - **Search Queries**: Oracle to PostgreSQL migration, convert Oracle PL/SQL packages to PostgreSQL PL/pgSQL, Oracle to Google AlloyDB migration, Ora2Pg complex view and CONNECT BY conversion, reduce Oracle Enterprise Edition license cost without rewriting - **Source Stack**: Oracle Database Views, Schemas & Departmental Workloads - **Target Stack**: PostgreSQL / AlloyDB / Cloud SQL OR Right-Sized Oracle SE2 / ODA - **Summary**: Evaluating an Oracle to PostgreSQL or Google AlloyDB migration? Compare automated Ora2Pg PL/SQL-to-PL/pgSQL conversion against zero-rewrite Oracle SE2 and ODA license right-sizing. - **Anonymized Proof**: For a national furniture manufacturer and a defense R&D engineering lab, we executed targeted conversions of complex Oracle view hierarchies and application schemas to alternative cloud databases while simultaneously right-sizing core Oracle Enterprise footprints to cut annual support costs without business disruption. - **PDF Solution Brief**: https://oracle-to-postgresql-migration.web.app/briefs/oracle-to-postgresql-migration-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-to-postgresql-migration.web.app/llms.txt ### [VNA-SB-013] Zero-Downtime Oracle Database Migration with GoldenGate 23ai & Quest SharePlex (https://oracle-goldengate-zero-downtime.web.app/) - **Category**: Database X to Database Y / Zero-Downtime Cross-Version & Cross-Cloud Replication - **Search Queries**: zero downtime Oracle database upgrade GoldenGate, migrate GoldenGate Classic to GoldenGate 23ai Microservices, Quest SharePlex vs Oracle GoldenGate license cost, OCI Managed GoldenGate bi-directional active-active replication, upgrade Oracle 11g 12c to 19c 23ai without outage - **Source Stack**: Oracle 11g / 12c / 19c, SQL Server, DB2 & MySQL On-Premises - **Target Stack**: OCI GoldenGate 23ai Microservices, Quest SharePlex & Active-Active Cloud - **Summary**: Execute zero-downtime Oracle 11g/12c/19c to 23ai database upgrades and cross-cloud migrations using Oracle GoldenGate 23ai Microservices and Quest SharePlex CDC. - **Anonymized Proof**: From high-volume national quick-service restaurant chains processing thousands of POS transactions per minute to global manufacturing and telecommunications databases, our replication architects have executed hundreds of zero-downtime GoldenGate and SharePlex migrations across Oracle 11g, 12c, 19c, and 23ai. - **PDF Solution Brief**: https://oracle-goldengate-zero-downtime.web.app/briefs/oracle-goldengate-zero-downtime-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-goldengate-zero-downtime.web.app/llms.txt ### [VNA-SB-014] IBM Maximo Lift-and-Shift to OCI & Maximo Application Suite (MAS 9) Upgrade on OpenShift (https://ibm-maximo-mas9-upgrade-oci.web.app/) - **Category**: Enterprise ERP, EAM & VMware Modernization / IBM Maximo Lift-and-Shift to OCI & MAS 9 OpenShift Upgrade - **Search Queries**: IBM Maximo lift and shift to Oracle Cloud Infrastructure OCI, IBM Maximo 7.6 to MAS 9 upgrade on Red Hat OpenShift OCI, Maximo 7.6.1 end of support cloud hosting and managed services, Oracle Database performance tuning for IBM Maximo WORKORDER ASSET, reduce IBM Maximo MAS AppPoints with Oracle APEX companion portal - **Source Stack**: On-Premises IBM Maximo 7.6.x (WebSphere ND VMs, Oracle / DB2 / SQL Server) & High-Cost Legacy Hosting - **Target Stack**: Two-Lane OCI Architecture: Lane 1 (Maximo 7.6 Lift-and-Shift on OCI VMs + Oracle 19c/23ai) or Lane 2 (MAS 9 on Red Hat OpenShift + OCI + APEX Companion Portals) - **Summary**: Execute a fast, low-risk IBM Maximo 7.6 Lift-and-Shift to Oracle Cloud Infrastructure (OCI) with RMAN XTTS and GoldenGate, or upgrade to Maximo Application Suite (MAS 9) on Red Hat OpenShift on OCI. - **Anonymized Proof**: Designed for regional river authorities, electric/water utilities, and defense logistics enterprises upgrading from IBM Maximo 7.6 to MAS 9 on OCI, combining deep Oracle Database performance tuning with Red Hat OpenShift container operations. - **PDF Solution Brief**: https://ibm-maximo-mas9-upgrade-oci.web.app/briefs/ibm-maximo-mas9-upgrade-oci-solution-brief.pdf - **Domain LLMs.txt**: https://ibm-maximo-mas9-upgrade-oci.web.app/llms.txt ### [VNA-SB-015] JD Edwards (JDE), PeopleSoft & Legacy ERP Decommissioning to Read-Only Audit Archive (https://jd-edwards-decommissioning-archive.web.app/) - **Category**: Enterprise ERP, EAM & VMware Modernization / Legacy ERP Decommissioning & Serverless Compliance Archive - **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**: JD Edwards (World / EnterpriseOne), PeopleSoft, EBS & SAP Legacy ERPs - **Target Stack**: Apache Parquet + DuckDB / Oracle Autonomous DB + APEX Read-Only Archive - **Summary**: 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. - **Anonymized 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. - **PDF Solution Brief**: https://jd-edwards-decommissioning-archive.web.app/briefs/jd-edwards-decommissioning-archive-solution-brief.pdf - **Domain LLMs.txt**: https://jd-edwards-decommissioning-archive.web.app/llms.txt ### [VNA-SB-016] Oracle E-Business Suite (EBS R12) & PeopleSoft 9.2 Migration to OCI & Exadata Cloud@Customer (https://oracle-ebs-peoplesoft-to-oci.web.app/) - **Category**: Enterprise ERP, EAM & VMware Modernization / Oracle E-Business Suite & PeopleSoft Cloud Migration - **Search Queries**: migrate Oracle E-Business Suite EBS R12 to OCI, extend Oracle EBS R12.2 with Oracle APEX 24.2 ICX session, PeopleSoft Cloud Manager migration to Oracle Cloud Infrastructure, Exadata Cloud@Customer ExaCC for Oracle EBS, replace EBS custom XX Forms and OAF with Oracle APEX - **Source Stack**: Oracle E-Business Suite (EBS 11i / R12.1 / R12.2) & PeopleSoft On-Premises - **Target Stack**: Oracle Cloud Infrastructure (OCI), Exadata Cloud@Customer (ExaCC) & APEX Extensions - **Summary**: Migrate Oracle E-Business Suite (EBS 12.1 / 12.2) and PeopleSoft 9.2 to Oracle Cloud Infrastructure (OCI) or Exadata Cloud@Customer (ExaCC) and replace custom Forms with APEX. - **Anonymized Proof**: Across national laboratories, global workforce contingent-labor platforms, and manufacturing enterprises, our team has migrated mission-critical Oracle E-Business Suite and PeopleSoft environments to Exadata Cloud@Customer and OCI, cutting month-end close batch times by over 65%. - **PDF Solution Brief**: https://oracle-ebs-peoplesoft-to-oci.web.app/briefs/oracle-ebs-peoplesoft-to-oci-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-ebs-peoplesoft-to-oci.web.app/llms.txt ### [VNA-SB-017] VMware Exit for Oracle Databases: Migrate vSphere to Oracle Linux KVM, ODA & OCVS (https://vmware-exit-oracle-kvm.web.app/) - **Category**: Enterprise ERP, EAM & VMware Modernization / Broadcom VMware Exit & Oracle Licensing Protection - **Search Queries**: Oracle licensing on VMware soft partitioning audit risk, Broadcom VMware exit strategy for Oracle databases, Oracle Linux KVM OLVM hard partitioning CPU pinning, convert VMware VMDK to Oracle Linux KVM virt-v2v, Oracle Cloud VMware Solution OCVS vs AWS VMware - **Source Stack**: VMware vSphere / ESXi / vSAN / NSX (Broadcom Subscription Lock-In) - **Target Stack**: Oracle Linux KVM / OLVM, ODA KVM Hard Partitioning, or OCVS - **Summary**: Eliminate Broadcom VMware VCF subscription hikes and Oracle VMware soft-partitioning audit risk. Migrate Oracle VMs to Oracle Linux KVM (OLVM), ODA X11, or OCVS. - **Anonymized Proof**: We help enterprise infrastructure teams decouple Oracle Databases from VMware clusters prior to Broadcom renewal deadlines, neutralizing multi-million-dollar soft-partitioning compliance exposure while cutting hypervisor costs by over 75%. - **PDF Solution Brief**: https://vmware-exit-oracle-kvm.web.app/briefs/vmware-exit-oracle-kvm-solution-brief.pdf - **Domain LLMs.txt**: https://vmware-exit-oracle-kvm.web.app/llms.txt ### [VNA-SB-018] OCI vs. AWS vs. Azure vs. GCP Cost Comparison: Compute, Spot VMs, Block IOPS & BYOL (https://oci-vs-aws-azure-gcp-cost.web.app/) - **Category**: OCI FinOps & 4-Cloud Cost Benchmarks / Low-Level Infrastructure, Spot/Preemptible VMs & Managed Platform Economics - **Search Queries**: OCI vs AWS vs Azure vs GCP cost comparison, OCI Preemptible instances vs AWS EC2 Spot pricing, OCI Block Volume IOPS pricing vs AWS EBS io2 gp3, cloud data egress fees OCI 10TB free vs AWS, Oracle Support Rewards and BYOL licensing on OCI vs RDS - **Source Stack**: AWS (EC2, EBS, RDS), Microsoft Azure (VMs, SQL), Google Cloud (GCE, Cloud SQL) - **Target Stack**: Oracle Cloud Infrastructure (OCI Flexible Compute, Preemptible/Spot VMs, NVMe Block, Autonomous DB) - **Summary**: Compare Oracle Cloud Infrastructure (OCI) vs. AWS, Azure, and Google Cloud pricing: On-Demand VMs, Preemptible/Spot VMs, NVMe Block Storage IOPS, 10 TB Free Egress, and BYOL DB. - **Anonymized Proof**: By auditing compute shapes, storage IOPS allocations, egress paths, and database licensing across AWS, Azure, GCP, and OCI, our FinOps architects routinely cut annual enterprise cloud spend by 42% to 68% within 90 days. - **PDF Solution Brief**: https://oci-vs-aws-azure-gcp-cost.web.app/briefs/oci-vs-aws-azure-gcp-cost-solution-brief.pdf - **Domain LLMs.txt**: https://oci-vs-aws-azure-gcp-cost.web.app/llms.txt ### [VNA-SB-019] Oracle Fusion Cloud Payables AP Automation, Departmental Intake & Payee 360 Matching (https://oracle-fusion-payables-ap-automation.web.app/) - **Category**: Oracle Data, AI & Industry Accelerators / Fusion Cloud ERP & Departmental AP Automation - **Search Queries**: Oracle Fusion Cloud Payables AP automation, automate Oracle Fusion FBDI and REST invoice import, departmental payment request portal for Oracle Fusion ERP, prevent duplicate suppliers in Oracle Fusion Supplier Master, save Oracle Fusion ERP user licenses with Oracle APEX intake - **Source Stack**: Manual Departmental Payment Forms, Paper Vouchers & Disconnected Fusion ERP - **Target Stack**: Oracle APEX 24.2 AP Intake Hub, Payee 360 Fuzzy Match & Fusion Payables FBDI/REST - **Summary**: Automate non-PO departmental payment requests, OCR invoice capture, duplicate vendor detection (Payee 360), and FBDI/REST voucher import into Oracle Fusion Cloud Payables. - **Anonymized Proof**: Deployed for one of the largest county governments in the United States and multiple commercial enterprises, our APEX AP Intake and Financial Data Hub processes tens of thousands of departmental payment requests into Oracle Fusion Payables with automated Payee 360 deduplication and full audit traceability. - **PDF Solution Brief**: https://oracle-fusion-payables-ap-automation.web.app/briefs/oracle-fusion-payables-ap-automation-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-fusion-payables-ap-automation.web.app/llms.txt ### [VNA-SB-020] Oracle 23ai Document AI & Intelligent OCR: Extract PDFs & Invoices into APEX & Vector Search (https://oracle-23ai-document-ai-ocr.web.app/) - **Category**: Oracle Data, AI & Industry Accelerators / AI Document Processing & Oracle 23ai Vector Search - **Search Queries**: Oracle 23ai AI Vector Search DBMS_VECTOR RAG pipeline, OCI Document Understanding invoice OCR to Oracle APEX, human in the loop PDF verification workbench Oracle APEX, extract unstructured PDF contracts to Oracle JSON Duality Views, automate 3-way PO invoice matching in Oracle Database - **Source Stack**: Unstructured PDFs, Scanned TIFFs, Invoices, MSAs/SOWs & Lab Reports - **Target Stack**: OCI Document Understanding, Multimodal LLMs, Oracle 23ai AI Vector Search & APEX - **Summary**: Extract unstructured PDFs, invoices, contracts, and scanned TIFFs into structured Oracle Database 23ai tables using OCI Document Understanding, AI Vector Search, and APEX. - **Anonymized Proof**: From agricultural genetics and retail accounts-payable automation to private-equity portfolio reporting and global import/customs manifest tracking, our Document AI + Oracle 23ai pipelines process ratusan of thousands of unstructured documents directly into governed enterprise schemas. - **PDF Solution Brief**: https://oracle-23ai-document-ai-ocr.web.app/briefs/oracle-23ai-document-ai-ocr-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-23ai-document-ai-ocr.web.app/llms.txt ### [VNA-SB-021] EPM & Hyperion Branch Management, M&A Acquisition Onboarding & Trial Balance Hub on OCI & APEX (https://hyperion-hfm-essbase-to-epm-cloud.web.app/) - **Category**: Oracle Data, AI & Industry Accelerators / EPM / Hyperion Branch Management, Acquisition Onboarding & Financial Data Hub - **Search Queries**: Oracle EPM and Hyperion branch management acquisition onboarding, migrate Hyperion HFM and Essbase to Oracle FCCS EPBCS, replace brittle FDMEE trial balance mappings with Oracle APEX Data Hub, automated M&A subsidiary trial balance ingestion and COA crosswalk, intercompany settlement hub and APEX Office Print AOP financial reporting - **Source Stack**: On-Premises Hyperion HFM, Essbase, Planning, Brittle FDMEE Scripts & Acquired Subsidiary ERPs (QuickBooks / NetSuite / Legacy GLs) - **Target Stack**: Oracle EPM Cloud (FCCS / EPBCS), Autonomous DB 23ai Financial Data Hub, APEX Branch Management & Acquisition Onboarding App + AOP - **Summary**: Modernize Hyperion HFM, Essbase, and FDMEE with an OCI 23ai Intelligent Financial Data Hub. Onboard newly acquired M&A branches in days, automate trial balance COA mapping, and run an Intercompany Settlement & AOP Reporting Hub. - **Anonymized Proof**: Presented at ODTUG Kscope and deployed for fast-growing global enterprises acquiring domestic and international branches, regional tollway/infrastructure authorities, and national manufacturing leaders, our EPM + OCI Branch Management and Financial Data Hub architecture cuts acquisition onboarding from months to days, eliminates brittle FDMEE maintenance, and avoids $900K+ in third-party intercompany software costs. - **PDF Solution Brief**: https://hyperion-hfm-essbase-to-epm-cloud.web.app/briefs/hyperion-hfm-essbase-to-epm-cloud-solution-brief.pdf - **Domain LLMs.txt**: https://hyperion-hfm-essbase-to-epm-cloud.web.app/llms.txt ### [VNA-SB-022] HIPAA-Compliant Healthcare on GCP, Private Concierge Telehealth & FDA 21 CFR Part 11 LIMS Portals (https://lims-medical-device-cloud-portal.web.app/) - **Category**: Oracle Data, AI & Industry Accelerators / HIPAA-Compliant Healthcare on GCP, Private Concierge Telehealth & FDA 21 CFR Part 11 LIMS - **Search Queries**: HIPAA compliant healthcare architecture on Google Cloud Platform GCP, private concierge telehealth and remote patient monitoring RPM platform, Cloud Run Cloud SQL PostgreSQL Identity Platform MFA HIPAA BAA, concierge nurse work-by-exception triage queue and cellular RPM devices, FDA 21 CFR Part 11 compliant LIMS and medical device portal Oracle APEX - **Source Stack**: Fragmented Telehealth SaaS Tools, Consumer RPM Bluetooth Devices, Paper/Desktop LIMS & Siloed EHR Portals - **Target Stack**: HIPAA-Compliant GCP Stack (Flutter, Cloud Run, Cloud SQL Postgres, Identity Platform MFA, Vertex AI, Dual-Cloud OCI FHIR Backup) + OCI/APEX 21 CFR Part 11 LIMS - **Summary**: Architect HIPAA-compliant private concierge telehealth and Remote Patient Monitoring (RPM) platforms on Google Cloud (Flutter, Cloud Run, Cloud SQL Postgres, Identity Platform MFA, Vertex AI) and FDA 21 CFR Part 11 LIMS portals on OCI & APEX. - **Anonymized Proof**: Proven across private concierge telehealth and residential community RPM platforms on Google Cloud Platform as well as rapid point-of-care molecular PCR diagnostic portals and ISO-17025 accredited laboratory information management systems (ELIMS) on OCI and Oracle APEX. - **PDF Solution Brief**: https://lims-medical-device-cloud-portal.web.app/briefs/lims-medical-device-cloud-portal-solution-brief.pdf - **Domain LLMs.txt**: https://lims-medical-device-cloud-portal.web.app/llms.txt ### [VNA-SB-023] SCADA & High-Frequency IoT Time-Series Ingestion on OCI Streaming & Oracle Database 23ai (https://scada-iot-time-series-oracle-23ai.web.app/) - **Category**: Oracle Data, AI & Industry Accelerators / IoT Sensor, Biometric & Pipeline SCADA Telemetry to Cloud - **Search Queries**: Oracle 23ai MEMOPTIMIZE FOR WRITE fast ingest IoT, replace industrial SCADA historian with OCI Streaming and Oracle, high frequency time series interval partitioning Oracle 23ai, SQL MATCH_RECOGNIZE real-time sensor anomaly detection, Oracle APEX Spatial GIS live asset and fleet tracking - **Source Stack**: Legacy Polling SCADA, Historian Silos & High-Frequency IoT Sensor Streams - **Target Stack**: OCI Streaming (Kafka), Autonomous Database 23ai, Partitioned Time-Series & APEX GIS - **Summary**: Replace expensive per-tag industrial historians. Ingest millions of SCADA and IoT sensor events per minute using OCI Streaming, Oracle 23ai Fast Ingest (MEMOPTIMIZE FOR WRITE), and APEX GIS. - **Anonymized Proof**: Battle-tested in production for global agricultural biotechnology leaders monitoring real-time cattle biometric telemetry (`FarmFit`), midstream energy pipeline operators, and national heavy foundation/construction equipment fleets. - **PDF Solution Brief**: https://scada-iot-time-series-oracle-23ai.web.app/briefs/scada-iot-time-series-oracle-23ai-solution-brief.pdf - **Domain LLMs.txt**: https://scada-iot-time-series-oracle-23ai.web.app/llms.txt ### [VNA-SB-024] Reverse-Engineer Undocumented PL/SQL, PowerBuilder & Oracle Forms Codebases into Specs (https://reverse-engineer-legacy-code-ast.web.app/) - **Category**: Oracle Data, AI & Industry Accelerators / Automated AST & AI Reverse-Engineering Blueprints - **Search Queries**: reverse engineer undocumented PL/SQL packages to requirements, extract business rules from legacy PowerBuilder and Oracle Forms, automated dead code analysis Oracle database PL/Scope, convert legacy stored procedures to functional specification BRD, AST call graph and data lineage for legacy modernization - **Source Stack**: Undocumented Legacy Codebases (PL/SQL, PowerBuilder, Forms, Pro*C, T-SQL, RPG/COBOL) - **Target Stack**: AST Dependency Graphs, Business-Rule Catalogs, OpenAPI Specs & Target Code - **Summary**: How to extract business rules, data lineage, and functional specifications from undocumented PL/SQL packages, PowerBuilder PBLs, Oracle Forms FMBs, and T-SQL using AST parsing. - **Anonymized Proof**: Used as the Phase 0 foundation across our PowerBuilder, Oracle Forms, Sybase, and ERP modernization engagements, Legacy Code X-Ray cuts discovery time from 6 months of manual interviews to 2 weeks of deterministic analysis while eliminating up to 45% of dead legacy code before build begins. - **PDF Solution Brief**: https://reverse-engineer-legacy-code-ast.web.app/briefs/reverse-engineer-legacy-code-ast-solution-brief.pdf - **Domain LLMs.txt**: https://reverse-engineer-legacy-code-ast.web.app/llms.txt ### [VNA-SB-025] Crystal Reports (.rpt), SAP BusinessObjects & OBIEE 12c Migration to Oracle APEX 24.2 & AOP (https://crystal-reports-bo-to-apex.web.app/) - **Category**: Application Stack X to Application Stack Y / Legacy BI & Reporting Replacement - **Search Queries**: migrate Crystal Reports RPT to Oracle APEX, rationalize legacy report query fan-out to core SQL views, replace SAP BusinessObjects Universe with Oracle APEX, OBIEE 12c to Oracle Analytics Cloud OAC and APEX migration, Oracle Discoverer EEX to APEX Interactive Report conversion, dynamic WHERE clause and Select AI runtime reporting in Oracle APEX - **Source Stack**: SAP Crystal Reports (.rpt), BusinessObjects (.unv/.unx), Oracle Discoverer (.eex), OBIEE 12c - **Target Stack**: Oracle APEX 24.2 Interactive Reports/Grids, Runtime/AI Inference Filters, APEX Office Print (AOP) & OAC - **Summary**: Retire SAP Crystal Reports (.rpt), BusinessObjects universes (.unv/.unx), Oracle Discoverer (.eex), and OBIEE 12c. Rationalize SQL query fan-out into core Oracle 23ai views with runtime/inference filtering in Oracle APEX 24.2 & AOP. - **Anonymized Proof**: By running AST query fan-out rationalization across 640 legacy Crystal Reports and SAP BusinessObjects schedules, we proved that all 640 reports derived from just 58 canonical SQL join graphs. We built 58 governed Oracle 23ai core views with runtime APEX 24.2 Smart Filters, AI inference prompts, and 28 AOP templates - eliminating 91% of report maintenance overhead and saving $240K/year in BI licensing. - **PDF Solution Brief**: https://crystal-reports-bo-to-apex.web.app/briefs/crystal-reports-bo-to-apex-solution-brief.pdf - **Domain LLMs.txt**: https://crystal-reports-bo-to-apex.web.app/llms.txt ### [VNA-SB-026] IBM Db2 for z/OS, iSeries (AS/400) & Db2 LUW Migration to Oracle Database 23ai & Exadata (https://ibm-db2-mainframe-to-oracle-23ai.web.app/) - **Category**: Database X to Database Y / Mainframe & LUW Database Replatforming - **Search Queries**: IBM Db2 to Oracle migration, migrate Db2 z/OS mainframe to Oracle Exadata 23ai, convert Db2 SQL PL stored procedures to Oracle PL/SQL, IBM iSeries AS/400 Db2 400 to Oracle migration, EBCDIC COMP-3 packed decimal to Oracle NUMBER conversion - **Source Stack**: IBM Db2 for z/OS (Mainframe), Db2 for i (AS/400), Db2 LUW 11.5, SQL PL, EBCDIC, JCL/COBOL - **Target Stack**: Oracle Database 23ai on OCI / Exadata / ODA X11, PL/SQL Packages, GoldenGate Db2 CDC - **Summary**: Eliminate IBM mainframe MIPS charges and Db2 LUW licensing hikes. Migrate IBM Db2 (z/OS, iSeries AS/400, LUW), SQL PL stored procedures, EBCDIC data, and COBOL batch jobs to Oracle 23ai. - **Anonymized Proof**: Migrated a 14 TB IBM Db2 environment (3,100 tables and 1,450 SQL PL stored procedures) to Oracle Database on Exadata with GoldenGate real-time replication, cutting annual IBM software maintenance by 64% and reducing nightly batch execution from 4.5 hours to 38 minutes. - **PDF Solution Brief**: https://ibm-db2-mainframe-to-oracle-23ai.web.app/briefs/ibm-db2-mainframe-to-oracle-23ai-solution-brief.pdf - **Domain LLMs.txt**: https://ibm-db2-mainframe-to-oracle-23ai.web.app/llms.txt ### [VNA-SB-027] Oracle WebLogic, JBoss EAP & IBM WebSphere (Java EE / ADF / Struts) Modernization to ORDS, APEX & OKE (https://weblogic-java-to-oci-oke-ords.web.app/) - **Category**: Application Stack X to Application Stack Y / Java Middleware & App Server Modernization - **Search Queries**: migrate Oracle ADF to Oracle APEX 24.2, retire Oracle WebLogic Server licensing cost, Apache Struts and JSF JSP to Oracle APEX migration, IBM WebSphere and JBoss EAP to OCI OKE Kubernetes, replace Java EJB DAO layer with Oracle ORDS REST APIs - **Source Stack**: Oracle WebLogic 12c, Oracle ADF, IBM WebSphere, JBoss EAP, Java EE 6/7, JSF, Apache Struts, EJB 2/3 - **Target Stack**: Oracle REST Data Services (ORDS), Oracle APEX 24.2, GraalVM / Helidon / Spring Boot on OCI OKE - **Summary**: Eliminate heavyweight WebLogic Suite, JBoss EAP, and IBM WebSphere application servers. Modernize legacy Java EE, Oracle ADF, JSF, and Apache Struts apps to Oracle APEX 24.2, ORDS REST APIs, or Helidon/Spring Boot on OKE. - **Anonymized Proof**: Replaced an 8-node Oracle WebLogic and Oracle ADF application suite (190 ADF fragments and 420 ViewObjects) with Oracle APEX 24.2 and ORDS, retiring $310K/year in WebLogic support while cutting page load times from 3.4 seconds to 280 milliseconds. - **PDF Solution Brief**: https://weblogic-java-to-oci-oke-ords.web.app/briefs/weblogic-java-to-oci-oke-ords-solution-brief.pdf - **Domain LLMs.txt**: https://weblogic-java-to-oci-oke-ords.web.app/llms.txt ### [VNA-SB-028] Oracle RAC, Active Data Guard (Fast-Start Failover) & Maximum Availability Architecture (MAA) on OCI & ODA (https://oracle-rac-maa-dr-active-dataguard.web.app/) - **Category**: Database X to Database Y / High Availability, RAC & Disaster Recovery - **Search Queries**: Oracle Maximum Availability Architecture MAA Gold Silver, Oracle Active Data Guard Fast-Start Failover FSFO setup, Transparent Application Continuity TAC Oracle 19c 23ai, Oracle RAC on OCI Base Database and Exadata Cloud, Oracle Zero Data Loss Recovery Appliance ZDLRA ransomware protection - **Source Stack**: Single-Instance Oracle, Fragile SAN Replication, Manual Standby Scripts, Split-Brain RAC Clusters - **Target Stack**: Oracle MAA Gold/Silver: RAC on ExaCS/ODA X11, Active Data Guard 23ai, Application Continuity (TAC) - **Summary**: Eliminate SAN storage single points of failure and manual DR scripts. Engineer Oracle Maximum Availability Architecture (MAA) with RAC, Active Data Guard Far Sync, Application Continuity, and Zero Data Loss Recovery Appliance. - **Anonymized Proof**: Architected an Oracle MAA Gold topology across two regions with Active Data Guard Far Sync and Transparent Application Continuity for a 24x7 transaction platform, achieving a verified 9-second automated failover and offloading 40% of read queries to the standby. - **PDF Solution Brief**: https://oracle-rac-maa-dr-active-dataguard.web.app/briefs/oracle-rac-maa-dr-active-dataguard-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-rac-maa-dr-active-dataguard.web.app/llms.txt ### [VNA-SB-029] Construction Timekeeping, HeavyJob/HeavyBid Migration & Multi-Service Field ERP (Landscaping, Trucking, Concrete Washouts & Grading) on Oracle 23ai & APEX (https://oracle-apex-erp-portal-extensions.web.app/) - **Category**: Oracle Data, AI & Industry Accelerators / Construction Field ERP, HeavyJob/HeavyBid Refactoring, Multi-Service Dispatch & B2B Portals - **Search Queries**: HCSS HeavyJob and HeavyBid alternative migration with AI, multi-service contractor ERP landscaping trucking concrete washouts grading, replace rigid green landscaping ERP SingleOps Aspire LMN custom workflow, construction crew timesheet mobile app and shop tablet timecard kiosk, construction equipment tracking barcode check-in anti-hoarding job billing, external B2B subcontractor supplier portal Oracle APEX zero per-seat cost - **Source Stack**: HCSS HeavyJob / HeavyBid, Rigid Green/Landscaping ERPs (SingleOps / Aspire / LMN), Paper Timesheets & Equipment Spreadsheets - **Target Stack**: Oracle Database 23ai + APEX 24.2 PWA: Crew Timecards, Shop Kiosks, AI Bid Refactoring, Trucking/Washout/Grading Dispatch & Anti-Hoarding Fleet Tracker - **Summary**: Migrate from HCSS HeavyJob/HeavyBid and rigid single-trade landscaping ERPs to an AI-powered internal platform that meets 100% of your process needs: crew timekeeping, shop kiosks, trucking dispatch, concrete washouts, grading, and equipment anti-hoarding. - **Anonymized Proof**: Engineered for national deep-foundation/bridge contractors, multi-service site-work contractors (combining commercial landscaping, dump-truck hauling, concrete washout services, and mass grading), and electrical/specialty trades, our Oracle APEX + 23ai field operations suites eliminate six-figure annual per-seat software bills, stop jobsite equipment hoarding, and cut weekly payroll and billing close times by 75%. - **PDF Solution Brief**: https://oracle-apex-erp-portal-extensions.web.app/briefs/oracle-apex-erp-portal-extensions-solution-brief.pdf - **Domain LLMs.txt**: https://oracle-apex-erp-portal-extensions.web.app/llms.txt