# MODIFIABLE REQUEST FOR PROPOSALS (RFP) TEMPLATE
## Project Title: Crystal Reports (.rpt), SAP BusinessObjects & OBIEE 12c Migration to Oracle APEX 24.2 & AOP
- **RFP Document Reference**: `VNA-RFP-025` (Companion to Solution Brief `VNA-SB-025`)
- **Issuing Organization**: `[INSERT ORGANIZATION / COMPANY NAME]`
- **Issue Date**: `[2026-10-27]`
- **Proposal Due Date**: `[INSERT DATE, e.g., +30 Calendar Days]`
- **Reference Architecture Portal**: https://crystal-reports-bo-to-apex.web.app/
- **Template Attribution**: This site is designed by Viscosity.AI

---

## SECTION 1: ISSUING ORGANIZATION PROFILE & PROCUREMENT SCHEDULE (MODIFIABLE)

> **Instructions for RFP Author**: Replace all bracketed placeholders (`[...]`) below with your organization's specific dates, contacts, and environment metrics before issuing to prospective bidders.

| Procurement Milestone | Target Date / Entry (Modifiable) |
|---|---|
| Issuing Organization Name | `[Insert Legal Entity Name]` |
| Primary Procurement / Technical Contact | `[Insert Name, Title, Email]` |
| RFP Issue Date | `[2026-10-27]` |
| Vendor Written Questions Due | `[Insert Date - Week 2]` |
| Organization Responses to Vendor Q&A | `[Insert Date - Week 3]` |
| Final Vendor Proposals & Pricing Due | `[Insert Date - Week 4]` |
| Technical Architecture Demos / Oral Presentations | `[Insert Date - Week 5]` |
| Target Contract Award & Phase 0 Kickoff | `[Insert Date - Week 6]` |

### 1.1 Executive Summary & Business Objectives
`[INSERT COMPANY NAME]` ("Organization") is soliciting competitive proposals from qualified enterprise architecture and engineering firms to modernize and transition our current **SAP Crystal Reports (.rpt), BusinessObjects (.unv/.unx), Oracle Discoverer (.eex), OBIEE 12c** environment to **Oracle APEX 24.2 Interactive Reports/Grids, Runtime/AI Inference Filters, APEX Office Print (AOP) & OAC**.

Our primary business and technical objectives are:
- Query Fan-Out Explosion: Over 15+ years, developers clone existing Crystal Reports (.rpt), Oracle Reports (.rdf), or BusinessObjects documents every time a department asks for a new WHERE clause, sort order, or column subset, turning 60 core datasets into 1,200+ redundant report files.
- Maintaining 1,000+ duplicated SQL queries means a single schema change or KPI formula update requires touching hundreds of separate report binaries.
- Oracle OBIEE 12c, SAP BusinessObjects (.unv/.unx), and legacy Oracle Discoverer (.eex) charge steep annual maintenance while trapping users in static exports instead of dynamic runtime filtering.

---

## SECTION 2: CURRENT ENVIRONMENT BASELINE INVENTORY (MODIFIABLE)

Bidders must size their technical delivery plan and fixed-fee milestone pricing against the baseline inventory table below:

| Inventory Dimension | Current Baseline Count / Footprint (Modifiable) | Target Modernization SLA / Objective |
|---|---|---|
| Legacy Source Stack (`Stack X`) | SAP Crystal Reports (.rpt), BusinessObjects (.unv/.unx), Oracle Discoverer (.eex), OBIEE 12c | Full retirement / modernization |
| Target Architecture (`Stack Y`) | Oracle APEX 24.2 Interactive Reports/Grids, Runtime/AI Inference Filters, APEX Office Print (AOP) & OAC | Production-grade HA/DR & security |
| Legacy Crystal (.rpt) / BusinessObjects / Discoverer / OBIEE Reports | `[Insert Count, e.g., 420 legacy reports]` | 100% functional parity & optimization |
| Query Fan-Out Rationalization Lever (Collapse Cloned SQL -> Core Views + Runtime/Inference Filters) | `[Insert Count, e.g., 84 % fan-out reduction]` | Automated AST & schema uplift |
| Pixel-Perfect PDF / Word / Excel AOP Templates | `[Insert Count, e.g., 45 AOP templates]` | `[Target Rationalization / SLA]` |
| Target Cutover Downtime Window | `[e.g., < 15 Minutes / Near-Zero Downtime]` | Rehearsed parallel run + rollback plan |
| Security, Compliance & Identity | `[e.g., SSO/MFA via Entra ID / Okta, Row-Level VPD, Audit Logs]` | Zero critical/high CVEs at Go-Live |

---

## SECTION 3: MANDATORY TECHNICAL SCOPE OF WORK & DELIVERABLES (MODIFIABLE)

The selected partner shall execute the project across four gated phases (**Phase 0: AST Discovery & Architecture Blueprint**, **Phase 1: Core Foundation & Data/Code Conversion**, **Phase 2: Integration, Runtime Filtering & UAT**, and **Phase 3: Parallel Run, Cutover & Hypercare**).

### 3.1 Core Architectural Requirements
1. **[MODIFIABLE REQUIREMENT 1]**: AST Query Fan-Out Rationalization: We parse all legacy .rpt, .rdf, .unv/.unx, .eex, and RPD files into SQL Abstract Syntax Trees (ASTs), stripping literal predicates and clustering queries by their core FROM/JOIN graph and aggregation grain.
2. **[MODIFIABLE REQUIREMENT 2]**: Build Only the Core Canonical SQL Views: Instead of migrating 1,000 cloned reports 1-for-1, we engineer governed, indexed Oracle Database 23ai views, Analytic Views, and PL/SQL pipelined functions strictly for the canonical core queries (typically reducing report artifact count by 75% to 90%).
3. **[MODIFIABLE REQUIREMENT 3]**: Runtime & Inference Filter Generation: Dynamic WHERE clauses, faceted search, saved user views, control breaks, and natural-language AI prompts (Oracle APEX 24.2 Smart Filters + Autonomous Database Select AI) are evaluated at runtime/inference rather than hard-coded into separate files.
4. **[MODIFIABLE REQUIREMENT 4]**: Pixel-Perfect Output via AOP: Regulatory PDFs, statements, and multi-tab Excel workbooks bind to the same rationalized core SQL cursors via APEX Office Print (AOP) or BI Publisher.

### 3.2 Component-Level Conversion & Deliverable Matrix
Bidders must confirm compliance with each component conversion requirement below:

| Req ID | Legacy Artifact / Baseline Workload | Required Target Architecture | Engineering Method & Acceptance Criteria | Priority (Modifiable) |
|---|---|---|---|---|
| REQ-01 | 10-30 Cloned Reports Differing Only by WHERE Clause / Sort / Group-By (Query Fan-Out) | 1 Canonical Oracle 23ai Core View + APEX 24.2 Runtime / Inference Filters | AST Join-Graph Clustering; build once for the core SQL, resolve predicates at runtime/inference | `[Mandatory / Optional]` |
| REQ-02 | SAP Crystal Reports (.rpt) + Nested Subreports | APEX Office Print (AOP) Template + Single Hierarchical CURSOR() Query | Extract SQL & formula fields; bind canonical core query to DOCX/XLSX/PDF template | `[Mandatory / Optional]` |
| REQ-03 | BusinessObjects Universe (.unv / .unx) Joins & Measures | Oracle 23ai Semantic Views + Analytic Views + Select AI Metadata | Compile universe classes into governed SQL views supporting runtime NL2SQL inference | `[Mandatory / Optional]` |
| REQ-04 | Oracle Discoverer Workbooks (.eex) & EUL Folders | Oracle APEX 24.2 Interactive Reports, Smart Filters & Saved Views | Deduplicate EUL folders into core views; users save custom runtime views without IT tickets | `[Mandatory / Optional]` |
| REQ-05 | OBIEE 12c RPD & Answers Dashboards | Oracle Analytics Cloud (OAC) or Native APEX 24.2 Dashboards | Lift executive KPIs to OAC or consolidate operational drill-downs into zero-license APEX pages | `[Mandatory / Optional]` |
| REQ-06 | Crystal Server / BO InfoView Bursting Schedules | APEX_AUTOMATION + DBMS_SCHEDULER + Dynamic VPD Predicates | Single scheduled job bursts personalized outputs by injecting runtime security context | `[Mandatory / Optional]` |

### 3.3 Mandatory Platform & Tooling Standards
- Viscosity AST SQL Fingerprint & Query Fan-Out Rationalization Engine
- Oracle APEX 24.2 (Interactive Reports, Smart Filters, Interactive Grids, Saved Runtime Views)
- Oracle Database 23ai Select AI & Dynamic PL/SQL Contexts (Runtime / Inference Query Generation)
- APEX Office Print (AOP) for Pixel-Perfect PDF, Word, and Excel Output
- Viscosity AMP (Report Access Governance, VPD Row-Level Security & Execution Auditing)

---

## SECTION 4: VENDOR TECHNICAL Q&A QUESTIONNAIRE & SCORING RUBRIC

Bidders must provide direct, concise written responses to each question below. The Issuing Organization's evaluation committee will grade responses using the embedded benchmark criteria.

### Vendor Question 1: How does Query Fan-Out Rationalization reduce our report count by 75% to 90%?
- **Bidder Response Requirement**: Provide a concrete architectural explanation, reference toolset, and verifiable production proof. Generic marketing statements will be scored zero.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: When we parse legacy Crystal (.rpt), Oracle Reports (.rdf), or BusinessObjects repositories into SQL Abstract Syntax Trees, we consistently find that 5 to 15 separate reports query the exact same tables and joins, differing only in hard-coded WHERE clauses, date buckets, or sort orders. We build and govern only the canonical core SQL query in Oracle 23ai, while all filter combinations, groupings, and ad-hoc views are generated dynamically at runtime or via AI inference in Oracle APEX 24.2.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 2: How do runtime and inference-based filters work for business users?
- **Bidder Response Requirement**: Provide a concrete architectural explanation, reference toolset, and verifiable production proof. Generic marketing statements will be scored zero.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: Each core SQL view powers an Oracle APEX 24.2 Interactive Report or Smart Filter page alongside Oracle 23ai Select AI natural-language inference. Users can toggle faceted filters, save private or public runtime report views, schedule email subscriptions, or type natural-language questions that synthesize safe WHERE predicates against the governed core view at runtime.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 3: Can Oracle APEX still produce pixel-perfect multi-page invoices, checks, and statements like Crystal Reports?
- **Bidder Response Requirement**: Provide a concrete architectural explanation, reference toolset, and verifiable production proof. Generic marketing statements will be scored zero.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: Yes. By pairing the rationalized core SQL cursors with APEX Office Print (AOP) or Oracle BI Publisher, business analysts maintain Word or Excel templates while Oracle 23ai supplies nested JSON cursor data at runtime.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 4: How do you prevent report and query fan-out bloat, and how do you guarantee zero vendor lock-in?
- **Bidder Response Requirement**: Detail your methodology for clustering redundant legacy queries/reports into canonical core SQL views with runtime or AI-inference filtering, and specify customer code/data ownership upon project completion.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: Bidder must demonstrate deterministic AST SQL clustering (collapsing 75%-90% of cloned reports into core database views with runtime predicates), 100% customer ownership of all DDL, PL/SQL, application source code, and Terraform scripts, and zero proprietary runtime lock-in.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 5: Describe your automated regression testing, parallel run, and zero-downtime cutover methodology.
- **Bidder Response Requirement**: Specify how data parity, business-rule equivalence, and rollback safety are verified prior to production cutover.
- **Evaluation Benchmark (What High-Scoring Responses Must Demonstrate)**: Bidder must provide automated row-count and cryptographic hash reconciliation, automated unit/UI test suites (e.g., utPLSQL, Playwright), and a rehearsed cutover runbook with sub-minute rollback capability.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

---

## SECTION 5: COMMERCIAL PRICING & LICENSING MATRIX (MODIFIABLE)

Bidders must complete the fixed-price milestone table below and disclose all recurring software or cloud consumption assumptions.

| Milestone / Cost Category | Deliverable & Acceptance Gate | Fixed Fee / Annual Cost (USD) | Estimated Duration (Weeks) |
|---|---|---|---|
| **Phase 0: Discovery & AST Code/Schema X-Ray** | Verified inventory, dead-code manifest, core SQL fan-out map, and final blueprint | `$[Insert]` | `[2 - 3 Weeks]` |
| **Phase 1: Target Environment & Automated Uplift** | Provisioned target stack, schema migration, and core business logic conversion | `$[Insert]` | `[4 - 8 Weeks]` |
| **Phase 2: UI, Integrations, Reporting & UAT** | Completed application/portal screens, runtime reports, AOP templates, and UAT sign-off | `$[Insert]` | `[3 - 6 Weeks]` |
| **Phase 3: Production Cutover & Hypercare** | Rehearsed cutover, reconciliation sign-off, documentation, and 30-day hypercare | `$[Insert]` | `[2 - 3 Weeks]` |
| **Optional: Annual Managed Services / Support** | 24x7 monitoring, patching, DBA performance tuning, and quarterly enhancements | `$[Insert / yr]` | `[12 Months]` |

---

## SECTION 6: PROPOSAL EVALUATION SCORECARD (MODIFIABLE)

| Evaluation Criterion | Weight (%) | Description |
|---|---|---|
| **1. Technical Architecture & Automation Tooling** | `35%` | Depth of AST automation, query fan-out rationalization, database/cloud architecture, and zero lock-in. |
| **2. Verifiable Production Experience & References** | `25%` | Proven track record delivering identical `Crystal Reports, BusinessObjects & OBIEE to APEX & AOP` engagements with measurable outcomes. |
| **3. Cutover Safety, Testing & Compliance** | `20%` | Rigor of data reconciliation, automated regression testing, security/compliance controls, and rollback safety. |
| **4. Commercial Value & Total Cost of Ownership (TCO)** | `20%` | Transparent fixed-fee milestone pricing and 3-to-5 year software/cloud licensing savings. |
| **TOTAL** | **`100%`** | |

---
*Template Reference: `VNA-RFP-025` | Companion Portal: https://crystal-reports-bo-to-apex.web.app/ | This site is designed by Viscosity.AI*