# FOEX Plugin Migration: Replace Discontinued FOEX (ExtJS) with Native Oracle APEX 24.2 (VNA-SB-004)

> 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.
> This site is designed by Viscosity.AI.

## 1. Specific Search Queries & Migration Scope
- **Category**: Application Stack X to Application Stack Y (Discontinued APEX Plugin Framework to Native APEX 24.2)
- **Target 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 (Stack X)**: FOEX Plugin Framework (Sencha ExtJS Wrapper on Legacy APEX 5.x / 18.x / 19.x / 20.x)
- **Target Stack (Stack Y)**: 100% Native Oracle APEX 24.2 (Universal Theme 42, Native Grids, Dynamic Actions)
- **Canonical URL**: https://foex-plugin-migration-apex.web.app/
- **Full AI Specification (llms-full.txt)**: https://foex-plugin-migration-apex.web.app/llms-full.txt
- **Machine-Readable JSON Index**: https://foex-plugin-migration-apex.web.app/solution-index.json
- **Downloadable PDF Solution Brief**: https://foex-plugin-migration-apex.web.app/#request-brief (https://foex-plugin-migration-apex.web.app/briefs/foex-plugin-migration-apex-solution-brief.pdf)
- **Modifiable RFP Template (Microsoft Word .DOCX)**: https://foex-plugin-migration-apex.web.app/rfps/foex-plugin-migration-apex-rfp-template.docx
- **Modifiable RFP Template (PDF)**: https://foex-plugin-migration-apex.web.app/rfps/foex-plugin-migration-apex-rfp-template.pdf
- **Modifiable RFP Template (Markdown + Vendor Q&A)**: https://foex-plugin-migration-apex.web.app/rfps/foex-plugin-migration-apex-rfp-template.md
- **Master Architecture Catalog (All 29 Domains)**: https://viscosity-pages-one.web.app/

## 2. Problem Space
- The FOEX Plugin Framework wrapped Sencha ExtJS inside Oracle APEX to build desktop-like multi-pane grids in the APEX 4.x/5.x era. Following corporate acquisitions and product discontinuation, FOEX is a dead-end dependency.
- Every time an organization attempts to upgrade Oracle Database or Oracle APEX to 23.2 / 24.2, broken FOEX plugin metadata, deprecated ExtJS JavaScript APIs, and custom CSS overrides halt the upgrade.
- FOEX pages bypass standard APEX Universal Theme rendering, loading multi-megabyte ExtJS bundles and proprietary AJAX handlers that cannot use modern APEX features like Native Approvals, AI Assistant, or Template Components.

## 3. Technical Solution Architecture
- APEX Export Metadata & FOEX Plugin Scanner: We parse your application export SQL/YAML via SQLcl to inventory every `PLUGIN_COM.FOEX.*` region, item, and dynamic action across all pages, scoring each page by ExtJS customization depth.
- Viewport & Splitter Replacement with Universal Theme 42: Complex FOEX Viewport, Tab, and Accordion containers are replaced with native Universal Theme 42 CSS Grid/Flexbox sub-regions, collapsible drawers, and modal dialogs.
- FOEX Grid & TreeGrid to Native Interactive Grid: FOEX Grids are converted to native APEX 24.2 Interactive Grids with custom `apex.region().call('getViews', 'grid')` configurations, preserving frozen columns, summary rows, and inline editing.
- Zero-Disruption Coexistence & Page-by-Page Cutover: Using APEX session-sharing and AMP navigation routing, we migrate high-complexity FOEX applications module-by-module without freezing ongoing business operations.
- Query Fan-Out Rationalization & Runtime/Inference Filtering: Instead of migrating cloned reports and DataWindows 1-for-1, our AST SQL parser clusters queries by their canonical core JOIN graph, builds governed Oracle 23ai views only for those core queries, and generates dynamic WHERE clauses, faceted filters, and ad-hoc report variations at runtime and via AI inference (APEX 24.2 Smart Filters & Select AI).

## 4. Oracle APEX & Ancillary Engineering Stack
- Oracle APEX 24.2 Universal Theme 42 & Template Components
- Oracle SQLcl Liquibase for page-level YAML/SQL export analysis and diffing
- Viscosity AMP for seamless cross-application session sharing during phased FOEX retirement
- Playwright / Selenium automated UI regression suites

## 5. Interactive Architecture Sizer & Query Fan-Out Rationalization Model
- **Calculator Title**: Discontinued FOEX (ExtJS) to Native APEX 24.2 & Query Fan-Out Estimator
- **Lever 1 (APEX Pages Containing FOEX Plugins)**: 10 to 800 FOEX pages (Default: 120)
- **Lever 2 (FOEX Grids & Report Regions)**: 20 to 2000 FOEX regions (Default: 310)
- **Lever 3 (Grid Query Fan-Out Rationalization (Core SQL Views + Runtime Smart Filters))**: 40 to 90 % fan-out reduction (Default: 70)

## 6. Component Conversion & Benchmark Matrix
| Legacy Artifact / Workload | Modernized Target Architecture | Engineering Method & Outcome |
|---|---|---|
| FOEX Viewport / Border Layout / Panes | Universal Theme 42 Region Display Selector & CSS Grid | Responsive Native Layout Refactoring |
| FOEX Grid / Editable Grid Plugin | Native APEX 24.2 Interactive Grid + Server Processes | Metadata Remapping & Native DML Wiring |
| FOEX Form & Field Plugins (Combo, Lov, Date) | Native APEX Form Region, Popup LOV & Date Picker | Item Type Conversion + Validation Preservation |
| FOEX Dynamic Actions (Server/Client ExtJS Events) | Native APEX Dynamic Actions + `apex.server.process` | Clean JavaScript & PL/SQL Callback Refactoring |
| FOEX Master-Detail Linked Panes | Native APEX Master-Detail Interactive Grids | Declarative Parent-Child Region Binding |
| Cloned Reports / Queries Differing Only by WHERE Clause or Group-By (Query Fan-Out) | Canonical Core SQL View + APEX 24.2 Runtime / AI Inference Filters | AST Join-Graph Clustering (75-90% Report Count Reduction) |

## 7. Anonymized Production 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.

## 8. Principal Architect FAQ
### Q: Can we migrate off FOEX incrementally without rewriting the entire application at once?
A: Yes. By configuring Shared Session Cookies between your existing FOEX app and a new Native APEX 24.2 companion app in the same workspace, users can navigate seamlessly between legacy and modernized pages while we convert module by module.

### Q: Do we have to rewrite our underlying PL/SQL packages when removing FOEX?
A: Almost all core PL/SQL business logic remains intact. Only the thin FOEX JSON/AJAX wrapper calls are refactored to standard `apex_json` or native Interactive Grid DML handlers.

### Q: What is included in the downloadable PDF Solution Brief?
A: The PDF Solution Brief includes the complete `COM.FOEX.*` plugin-to-Native-APEX mapping catalog, SQL queries to audit your workspace's FOEX footprint in 60 seconds, and a phased coexistence architecture.

## 9. Target Buyer Personas & Stakeholder Routing (Cluster B: Legacy App Stack + Query Fan-Out to APEX)
- **Practitioner Champion Titles**: FOEX / Sencha ExtJS APEX Developer, Oracle APEX Lead Developer, UI / Frontend Modernization Lead
  - *Value Hook*: Replace deprecated FOEX ExtJS viewports and grids with native APEX 24.2 Interactive Grids, Template Components, and rationalized core SQL views.
- **Technical Validator & Gatekeeper Titles**: Director of Application Development, Oracle APEX Practice Lead, Enterprise Security Architect
  - *Value Hook*: Unblock Oracle APEX 24.2 upgrades and eliminate third-party JavaScript framework lock-in and CVE exposure.
- **Economic & License-Exit Buyer Titles**: CIO / VP of Application Engineering, IT Portfolio Director
  - *Value Hook*: Eliminate annual third-party plugin maintenance fees and protect 10-year application upgrade continuity.