# Viscosity.AI Enterprise Architecture Catalog Two (12 Specialized Solution Domains: 030 - 041)

> Master directory of 12 specialized industry, legacy rescue, performance tuning, and SLED procurement portals hosted on Cloudflare Pages (.pages.dev).
> Companion to Fleet One (https://viscosity-pages-one.web.app/). This site is designed by Viscosity.AI.

## Catalog Endpoints
- **Master Catalog Hub Two**: https://viscosity-pages-two.pages.dev/
- **Master Catalog Hub One (Domains 001-029)**: https://viscosity-pages-one.web.app/
- **Master LLMs Manifest**: https://viscosity-pages-two.pages.dev/llms.txt
- **Full Technical Compendium**: https://viscosity-pages-two.pages.dev/llms-full.txt
- **Machine-Readable Registry JSON**: https://viscosity-pages-two.pages.dev/solution-index.json
- **Master XML Sitemap**: https://viscosity-pages-two.pages.dev/sitemap.xml

## All 12 Standalone Solution Domains in Fleet Two (`<slug>.pages.dev`)

### [VNA-SB-030] Public Sector & School District Budget Operating System (BOS) on Oracle APEX (https://public-sector-budget-os-apex.pages.dev/)
- **Category**: Industry Operating Platforms (Public Sector, B2B, POS & Transit) / Public Sector Budget & HCM Control
- **Search Queries**: school district budget software oracle apex, public sector budget operating system, hcm salary projection position control apex, automated board budget book aop
- **Source Stack**: Excel Budget Workbooks, Disconnected HCM Exports & Legacy Finance Sheets
- **Target Stack**: Oracle APEX 24.2 Budget Operating System (BOS) + Autonomous DB + AOP Budget Books
- **Summary**: Replace fragile budget spreadsheets with an Oracle APEX Budget Operating System (BOS): automated HCM salary uploads, position control, and AOP board books.
- **Anonymized Proof**: Delivered a continuous-release Budget Operating System (BOS) for a major metropolitan public school district, automating HCM salary uploads, multi-year fund projections, and board-ready financial reporting.
- **PDF Solution Brief**: https://public-sector-budget-os-apex.pages.dev/briefs/public-sector-budget-os-apex-solution-brief.pdf
- **Domain LLMs.txt**: https://public-sector-budget-os-apex.pages.dev/llms.txt

### [VNA-SB-031] B2B E-Commerce to Oracle Fusion ERP Zero-Downtime Pricing Cache & ORDS API Hub (https://b2b-ecommerce-erp-pricing-cache.pages.dev/)
- **Category**: Industry Operating Platforms (Public Sector, B2B, POS & Transit) / B2B Storefront & ERP Integration
- **Search Queries**: oracle fusion erp b2b ecommerce pricing api, zero downtime erp maintenance storefront cache, ords rest api contract pricing, cloudfy magento oracle fusion integration
- **Source Stack**: Direct Synchronous B2B Storefront Calls to Oracle Fusion Cloud ERP / Legacy ERP
- **Target Stack**: OCI Autonomous Transaction Processing (ATP) Pricing Cache + ORDS REST APIs + BI Publisher Sync
- **Summary**: Achieve 100% B2B storefront uptime during Oracle Fusion ERP maintenance windows with a sub-25ms ATP + ORDS customer-specific contract pricing cache.
- **Anonymized Proof**: Engineered a custom B2B pricing REST API and ATP caching layer bridging an enterprise e-commerce storefront with Oracle Fusion Cloud ERP for a healthcare supply chain organization, achieving 100% ordering uptime across ERP patch windows.
- **PDF Solution Brief**: https://b2b-ecommerce-erp-pricing-cache.pages.dev/briefs/b2b-ecommerce-erp-pricing-cache-solution-brief.pdf
- **Domain LLMs.txt**: https://b2b-ecommerce-erp-pricing-cache.pages.dev/llms.txt

### [VNA-SB-032] Multi-Unit Restaurant & Retail POS (MICROS / SQL Anywhere) to Oracle 23ai Reconciliation Hub (https://multi-unit-pos-oracle-sync.pages.dev/)
- **Category**: Industry Operating Platforms (Public Sector, B2B, POS & Transit) / Hospitality & Retail POS Synchronization
- **Search Queries**: oracle micros pos to oracle database sync, sql anywhere to oracle 19c 23ai replication, fix ora-00001 pos transaction collision, multi-unit restaurant cashout audit apex
- **Source Stack**: Oracle MICROS / NCR Aloha / SQL Anywhere Edge POS + Nightly Polling Scripts
- **Target Stack**: Idempotent Oracle 23ai / 19c POS Sync Engine + ORA-00001 Collision Guard + APEX Cashout Audit
- **Summary**: Eliminate POS polling failures and ORA-00001 collisions across multi-unit restaurants and retail stores with real-time SQL Anywhere/MICROS to Oracle sync.
- **Anonymized Proof**: Built and managed an enterprise POS synchronization and diagnostic architecture for an international multi-unit restaurant group, streaming MICROS and SQL Anywhere edge transactions into Oracle 19c with zero primary-key collisions.
- **PDF Solution Brief**: https://multi-unit-pos-oracle-sync.pages.dev/briefs/multi-unit-pos-oracle-sync-solution-brief.pdf
- **Domain LLMs.txt**: https://multi-unit-pos-oracle-sync.pages.dev/llms.txt

### [VNA-SB-033] Toll Road, Transit & Infrastructure Medallion Data Platform on OCI, Fusion ERP & OAC (https://toll-transit-medallion-lakehouse.pages.dev/)
- **Category**: Industry Operating Platforms (Public Sector, B2B, POS & Transit) / Transportation & Infrastructure Lakehouse
- **Search Queries**: toll road medallion data platform oci, transit authority oracle analytics cloud oac, oracle fusion erp infrastructure telemetry, roadway intelligence lakehouse
- **Source Stack**: Siloed Lane/Sensor Telemetry, Legacy Toll Databases & Disconnected ERP Financials
- **Target Stack**: OCI Medallion Lakehouse (Bronze/Silver/Gold) + Oracle Cloud ERP + Oracle Analytics Cloud (OAC)
- **Summary**: Unify high-velocity toll lane telemetry, asset maintenance, and Oracle Cloud ERP financials in a governed Bronze/Silver/Gold Medallion Lakehouse on OCI.
- **Anonymized Proof**: Delivered a full-lifecycle Oracle Cloud ERP and Medallion Data Platform with Oracle Analytics Cloud (OAC) executive dashboards for a major regional toll road authority.
- **PDF Solution Brief**: https://toll-transit-medallion-lakehouse.pages.dev/briefs/toll-transit-medallion-lakehouse-solution-brief.pdf
- **Domain LLMs.txt**: https://toll-transit-medallion-lakehouse.pages.dev/llms.txt

### [VNA-SB-034] Oracle Discoverer (EUL5) & BI Publisher to Oracle APEX, AOP & Analytics Cloud (https://oracle-discoverer-bipu-to-apex.pages.dev/)
- **Category**: Orphaned Oracle Stack Rescue (Discoverer, Workflow & EBS CEMLI) / Oracle Discoverer EUL & BI Publisher Exit
- **Search Queries**: oracle discoverer migration to apex, extract eul5_documents eul5_qpp_stats sql, replace oracle discoverer workbooks, bi publisher rtf to apex office print aop
- **Source Stack**: Unsupported Oracle Discoverer (EUL4/EUL5 Tables), Workbooks & Legacy XML/BI Publisher .rtf
- **Target Stack**: Governed Oracle 23ai Views + APEX Interactive Grids + APEX Office Print (AOP) + OAC
- **Summary**: Extract Oracle Discoverer End User Layer (EUL5) folders, joins, and workbooks into governed Oracle 23ai views, APEX Interactive Grids, and AOP templates.
- **Anonymized Proof**: Migrated 1,400+ legacy Oracle Discoverer workbooks and BI Publisher reports into 160 governed Oracle 23ai analytic views and APEX Interactive Grids with runtime filtering.
- **PDF Solution Brief**: https://oracle-discoverer-bipu-to-apex.pages.dev/briefs/oracle-discoverer-bipu-to-apex-solution-brief.pdf
- **Domain LLMs.txt**: https://oracle-discoverer-bipu-to-apex.pages.dev/llms.txt

### [VNA-SB-035] Oracle Workflow (.wft) & Legacy SOA Suite / BPEL to Native APEX 24.2 Workflows & ORDS (https://oracle-workflow-soa-to-apex.pages.dev/)
- **Category**: Orphaned Oracle Stack Rescue (Discoverer, Workflow & EBS CEMLI) / Oracle Workflow (.wft) & SOA Suite Exit
- **Search Queries**: oracle workflow wft to apex 24.2 workflow, migrate wf_engine plsql to apex approvals, retire oracle soa suite bpel weblogic, ords rest orchestration
- **Source Stack**: Oracle Workflow Builder (.wft / WF_ENGINE) & Heavy WebLogic SOA Suite 11g/12c BPEL
- **Target Stack**: Native Oracle APEX 24.2 Workflows & Unified Task Lists + ORDS REST Microservices
- **Summary**: Retire desktop Oracle Workflow Builder (.wft) and expensive WebLogic SOA Suite clusters by migrating approvals and BPEL orchestrations to APEX 24.2 Workflows.
- **Anonymized Proof**: Converted 85 complex Oracle Workflow (.wft) approval hierarchies and SOA Suite BPEL integrations into native Oracle APEX 24.2 Workflows and ORDS REST services, retiring four WebLogic SOA servers.
- **PDF Solution Brief**: https://oracle-workflow-soa-to-apex.pages.dev/briefs/oracle-workflow-soa-to-apex-solution-brief.pdf
- **Domain LLMs.txt**: https://oracle-workflow-soa-to-apex.pages.dev/llms.txt

### [VNA-SB-036] Emergency AWR, ASH & PL/SQL Performance Tuning (Cut CPU 50%-80% Before Buying Cores) (https://plsql-awr-performance-tuning.pages.dev/)
- **Category**: AWR Performance Tuning & Turnkey Oracle ACE Pods / 5-Day AWR, ASH & PL/SQL Engine Tuning
- **Search Queries**: oracle awr performance tuning service, fix oracle high cpu latch contention, plsql batch job optimization dbms_profiler, reduce oracle processor license cores
- **Source Stack**: High-CPU Oracle Databases, Nightly Batch Overruns, Latch Contention & Slow PL/SQL Loops
- **Target Stack**: Oracle ACE 5-Day AWR/ASH Diagnostic + Set-Based SQL Refactoring + Smart Indexing
- **Summary**: Before spending six figures on extra Oracle Database cores, our Oracle ACEs tune top AWR wait events and refactor slow PL/SQL loops to cut CPU by 50% to 80%.
- **Anonymized Proof**: Executed a 5-day AWR and PL/SQL performance optimization for an enterprise financial database, reducing peak CPU utilization from 96% to 28% and shrinking a 7-hour nightly batch run to 42 minutes without adding hardware.
- **PDF Solution Brief**: https://plsql-awr-performance-tuning.pages.dev/briefs/plsql-awr-performance-tuning-solution-brief.pdf
- **Domain LLMs.txt**: https://plsql-awr-performance-tuning.pages.dev/llms.txt

### [VNA-SB-037] Open Oracle Forms / APEX Requisition Bridge (Turnkey ACE Pod in 10 Days vs. 6-Month Hire) (https://oracle-forms-apex-talent-bridge.pages.dev/)
- **Category**: AWR Performance Tuning & Turnkey Oracle ACE Pods / Turnkey Oracle ACE Pod vs. 6-Month Hiring Delay
- **Search Queries**: hire oracle forms to apex developer, oracle apex consulting team vs full time hire, 2 week oracle forms modernization poc, oracle ace application development pod
- **Source Stack**: Open 90-to-180 Day Job Requisitions for Senior Oracle Forms / APEX / PLSQL Developers
- **Target Stack**: Turnkey Viscosity Oracle ACE Engineering Pod + Automated Binary FMB/RDF Tooling + 2-Week POC
- **Summary**: Have an open Oracle Forms or APEX developer requisition stalled for months? Deploy an Oracle ACE pod + automated FMB/RDF tooling in 10 days with a 2-week POC.
- **Anonymized Proof**: Stepped in for a regional enterprise whose Senior Oracle Forms Architect retired after a 5-month stalled recruiting search, delivering a working production APEX module in 14 days and completing the full migration ahead of schedule.
- **PDF Solution Brief**: https://oracle-forms-apex-talent-bridge.pages.dev/briefs/oracle-forms-apex-talent-bridge-solution-brief.pdf
- **Domain LLMs.txt**: https://oracle-forms-apex-talent-bridge.pages.dev/llms.txt

### [VNA-SB-038] Microsoft Entra ID & Okta SSO Federation + Row-Level Security (VPD / RAS) for Oracle & APEX (https://entra-okta-sso-oracle-vpd-ras.pages.dev/)
- **Category**: Zero-Trust Identity (Entra/Okta VPD) & SLED Cooperative Procurement / Zero-Trust SSO & Row-Level Security (VPD / RAS)
- **Search Queries**: oracle apex microsoft entra id sso, okta saml oidc oracle apex authentication, oracle virtual private database vpd apex, oracle real application security ras multi tenant
- **Source Stack**: Database-Account Logins, Shared Passwords & Unfiltered Table Access in Legacy Oracle Apps
- **Target Stack**: Entra ID / Okta OIDC/SAML Federation + Oracle Real Application Security (RAS) / VPD + Audit
- **Summary**: Pass cyber-insurance and compliance audits in 2 weeks by adding Microsoft Entra ID or Okta MFA/SSO and database-enforced Row-Level Security (VPD/RAS) to Oracl
- **Anonymized Proof**: Implemented Microsoft Entra ID (Azure AD) single sign-on, role-based access control, and database-enforced row-level security for an international life-sciences laboratory platform on Oracle APEX.
- **PDF Solution Brief**: https://entra-okta-sso-oracle-vpd-ras.pages.dev/briefs/entra-okta-sso-oracle-vpd-ras-solution-brief.pdf
- **Domain LLMs.txt**: https://entra-okta-sso-oracle-vpd-ras.pages.dev/llms.txt

### [VNA-SB-039] Oracle EBS R12 CUSTOM.pll & XX_ Schema Offload to Clean-Core APEX Sidecar Extensions (https://ebs-r12-cemli-apex-extension.pages.dev/)
- **Category**: Orphaned Oracle Stack Rescue (Discoverer, Workflow & EBS CEMLI) / Oracle EBS R12 CEMLI & CUSTOM.pll Offload
- **Search Queries**: oracle ebs r12 cemli offload to apex, replace ebs custom.pll forms personalization, migrate xx_ custom schema to oracle apex, clean core erp sidecar extension
- **Source Stack**: 500+ Invasive EBS R12 CEMLIs, CUSTOM.pll Triggers, Custom .fmb Forms & XX_ Schemas
- **Target Stack**: Clean-Core Oracle EBS / Fusion ERP + Decoupled APEX 24.2 Sidecar Extensions on Autonomous DB
- **Summary**: Unblock your Oracle EBS R12 upgrade or Fusion Cloud migration by lifting invasive CUSTOM.pll hooks and XX_ schemas into a clean-core Oracle APEX sidecar.
- **Anonymized Proof**: Extracted 180 invasive EBS R12 custom Forms, CUSTOM.pll extensions, and XX_ bolt-on tables into a decoupled Oracle APEX sidecar on Autonomous Database, cutting quarterly EBS patching regression testing from 6 weeks to 4 days.
- **PDF Solution Brief**: https://ebs-r12-cemli-apex-extension.pages.dev/briefs/ebs-r12-cemli-apex-extension-solution-brief.pdf
- **Domain LLMs.txt**: https://ebs-r12-cemli-apex-extension.pages.dev/llms.txt

### [VNA-SB-040] Electric Co-Op, Water Authority & Midstream Field GIS, ROW Document AI & Offline PWA Portal (https://utility-pipeline-field-gis-apex.pages.dev/)
- **Category**: Industry Operating Platforms (Public Sector, B2B, POS & Transit) / Utility, Water & Midstream Field GIS & ROW AI
- **Search Queries**: utility field work order offline pwa oracle apex, oracle spatial gis map integration apex, right of way easement document ai vector search, electric coop river authority asset portal
- **Source Stack**: Paper Field Tickets, Disconnected GIS Maps, Unindexed Easement PDFs & Siloed EAM Work Orders
- **Target Stack**: Oracle 23ai Spatial & Vector Search + Offline-Capable APEX Field PWA + Maximo/ERP Sync
- **Summary**: Unify field crew inspections, spatial GIS maps, right-of-way (ROW) document AI search, and Maximo/ERP work orders in an offline-capable Oracle APEX 24.2 PWA.
- **Anonymized Proof**: Engineered an integrated asset telemetry, spatial work-order, and document intelligence architecture for regional utility and infrastructure operators on Oracle Cloud Infrastructure.
- **PDF Solution Brief**: https://utility-pipeline-field-gis-apex.pages.dev/briefs/utility-pipeline-field-gis-apex-solution-brief.pdf
- **Domain LLMs.txt**: https://utility-pipeline-field-gis-apex.pages.dev/llms.txt

### [VNA-SB-041] Public Sector & SLED Fast-Track Cooperative Procurement Hub for Oracle, APEX & Cloud (https://sled-cooperative-procurement-oracle.pages.dev/)
- **Category**: Zero-Trust Identity (Entra/Okta VPD) & SLED Cooperative Procurement / Public Sector Fast-Track Cooperative Procurement
- **Search Queries**: texas dir dbits oracle apex consulting, choice partners software services contract, sled cooperative procurement oracle modernization, interlocal contract oracle database cloud
- **Source Stack**: 9-to-12 Month Formal RFP Delays Stalling Urgent County, Municipal, ISD & State IT Projects
- **Target Stack**: Pre-Competed Cooperative Contract Vehicles (TX DIR DBITS / Choice Partners / Interlocal SOW)
- **Summary**: Skip the 9-month RFP cycle: procure fixed-fee Oracle APEX, Database 23ai, and cloud modernization phases in weeks via pre-competed SLED cooperative vehicles.
- **Anonymized Proof**: Delivered a $1.74M enterprise Oracle APEX and Autonomous Database financial modernization for a major metropolitan county using a pre-competed Texas DIR DBITS cooperative contract vehicle.
- **PDF Solution Brief**: https://sled-cooperative-procurement-oracle.pages.dev/briefs/sled-cooperative-procurement-oracle-solution-brief.pdf
- **Domain LLMs.txt**: https://sled-cooperative-procurement-oracle.pages.dev/llms.txt