# MODIFIABLE REQUEST FOR PROPOSALS (RFP) TEMPLATE
## Project Title: Construction Timekeeping, HeavyJob/HeavyBid Migration & Multi-Service Field ERP (Landscaping, Trucking, Concrete Washouts & Grading) on Oracle 23ai & APEX
- **RFP Document Reference**: `VNA-RFP-029` (Companion to Solution Brief `VNA-SB-029`)
- **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://oracle-apex-erp-portal-extensions.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 **HCSS HeavyJob / HeavyBid, Rigid Green/Landscaping ERPs (SingleOps / Aspire / LMN), Paper Timesheets & Equipment Spreadsheets** environment to **Oracle Database 23ai + APEX 24.2 PWA: Crew Timecards, Shop Kiosks, AI Bid Refactoring, Trucking/Washout/Grading Dispatch & Anti-Hoarding Fleet Tracker**.

Our primary business and technical objectives are:
- Single-Trade 'Green' Landscaping ERPs Break on Multi-Service Operations: Off-the-shelf landscaping ERPs (Greenius, SingleOps, Aspire, LMN) assume every job is a crew mowing or planting. When a contractor also operates dump trucks (per-ton/per-load haul tickets), environmental concrete washout containers (drop-off, pump-out, swap, and manifest tracking), and mass grading/excavation (cut/fill production units), office staff are forced into 4 disconnected systems and double data entry.
- HeavyJob & HeavyBid Licensing & Rigidity: HCSS HeavyJob and HeavyBid charge high per-seat/module fees and lock historical bid assemblies, production rates, and daily foreman diaries inside rigid structures that are difficult to customize or combine with AI takeoff and corporate ERP workflows.
- Timekeeping Friction & Payroll Bottlenecks: Field foremen struggle with clunky apps while shop mechanics and fabrication workers lack fast tablet clock-in/clock-out kiosks, forcing payroll clerks to manually reconcile hours across Jobs, Cost Codes, prevailing-wage classifications, and overtime rules.
- Jobsite Equipment Hoarding & Blind Utilization: Foremen routinely 'hoard' excavators, skid steers, trenchers, and specialty tools on their jobsites 'just in case,' hiding idle assets from other crews while equipment managers lack barcode check-in/check-out, maintenance tie-in, and usage-based depreciation.

---

## 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`) | HCSS HeavyJob / HeavyBid, Rigid Green/Landscaping ERPs (SingleOps / Aspire / LMN), Paper Timesheets & Equipment Spreadsheets | Full retirement / modernization |
| Target Architecture (`Stack Y`) | Oracle Database 23ai + APEX 24.2 PWA: Crew Timecards, Shop Kiosks, AI Bid Refactoring, Trucking/Washout/Grading Dispatch & Anti-Hoarding Fleet Tracker | Production-grade HA/DR & security |
| Field Foremen, Crew Leads, Estimators & External Users | `[Insert Count, e.g., 350 users]` | 100% functional parity & optimization |
| Tracked Heavy Equipment, Dump Trucks & Concrete Washout Bins | `[Insert Count, e.g., 280 assets/bins]` | Automated AST & schema uplift |
| Current Per-Seat / Module Software Spend (HeavyJob / Green ERP $/user/mo) | `[Insert Count, e.g., 95 $/user/mo]` | `[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]**: HeavyJob & HeavyBid Migration to an AI-Native Estimating & Job Cost Platform: We extract your historical HeavyBid / Excel bid tabs, crew assemblies, equipment rates, and HeavyJob cost-code actuals into Oracle Database 23ai. Estimators use Oracle 23ai AI Vector Search and Document AI to parse PDF plans/specs, compare historical production rates against actual job performance, and generate 100% custom proposals.
2. **[MODIFIABLE REQUIREMENT 2]**: Multi-Service Dispatch Engine (Landscaping + Trucking + Concrete Washouts + Grading): One unified data model handles every service line cleanly: (a) Landscaping route/crew schedules, (b) Trucking dispatch with digital haul tickets, scale weights, and DOT driver logs, (c) Concrete Washout serialized bin tracking (GPS drop-off, fill status, pump-out/swap routing, and environmental disposal manifests), and (d) Grading & Earthwork daily cut/fill quantities and percent-complete billing.
3. **[MODIFIABLE REQUIREMENT 3]**: Mobile Crew Timesheets, Daily Logs & Shop Timecard Tablet Kiosks: Field foremen enter crew time against Job IDs and Cost Codes alongside weather, production quantities, safety sign-offs, and jobsite photos from any phone/tablet PWA. Shop and yard employees clock in and out on mounted tablet kiosks with badge/PIN scan, feeding a multi-tier approval workflow and one-click CSV/API payroll export.
4. **[MODIFIABLE REQUIREMENT 4]**: Anti-Hoarding Equipment Check-In/Check-Out, Barcode & GPS Fleet Management: Every heavy asset, truck, washout bin, and tool is tracked via mobile barcode/QR check-in/check-out, UNSPSC coding, and GPS telematics. Automated daily internal job rental charges bill the active job until the asset is checked back into the yard, immediately stopping foremen from hoarding idle equipment and tying actual runtime hours directly to preventive maintenance and depreciation.
5. **[MODIFIABLE REQUIREMENT 5]**: Zero-Per-Seat B2B Subcontractor, Customer & Supplier Portals: Because Oracle APEX 24.2 carries $0 per-user licensing, every foreman, driver, shop worker, general-contractor customer, and external subcontractor accesses real-time job status, washout manifests, COI/W-9 uploads, and billing backups without adding a single dollar of per-seat SaaS fees.

### 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 | HCSS HeavyJob Field Diaries, Timecards & Cost-Code Tracking | Oracle APEX 24.2 Mobile Foreman PWA + Shop Timecard Kiosks | 100% custom cost-code timekeeping, photo/note diaries, multi-tier approval & payroll CSV/API export | `[Mandatory / Optional]` |
| REQ-02 | HCSS HeavyBid Assemblies, Historical Bid Tabs & Takeoffs | Oracle 23ai AI-Assisted Estimating Workbench + Vector Bid History | Migrate assemblies & production rates; use AI to match new bid items against historical actuals | `[Mandatory / Optional]` |
| REQ-03 | Rigid 'Green' Landscaping ERP (Fails on Trucking, Washouts & Grading) | Unified Multi-Service Dispatch (Landscaping, Trucking, Washouts, Grading) | Purpose-built dispatch workflows for haul tickets, serialized concrete washout bins, and earthwork | `[Mandatory / Optional]` |
| REQ-04 | Concrete Washout Bin Spreadsheets & Paper Environmental Manifests | Serialized Container Lifecycle Tracker (Drop-Off / Swap / Pump-Out / Manifest) | GPS bin pin-drop, yard inventory, route optimization, and automated recurring rental + service billing | `[Mandatory / Optional]` |
| REQ-05 | Foreman Equipment Hoarding & Paper Yard Sign-Out Sheets | Mobile Barcode Check-In/Out + Automated Daily Internal Job Rental Charge | Charge active job daily until checked back in; link hours to maintenance & usage depreciation | `[Mandatory / Optional]` |
| REQ-06 | Per-User SaaS Portal Fees for Subcontractors & GC Customers | Zero-Per-Seat Oracle APEX B2B Customer & Subcontractor Portal (VPD) | Unlimited external logins for haul tickets, washout manifests, lien waivers, and AIA progress billing | `[Mandatory / Optional]` |

### 3.3 Mandatory Platform & Tooling Standards
- Oracle APEX 24.2 Progressive Web App (Mobile Crew Timecards, Tablet Shop Kiosks, Barcode Scanner & Spatial Map)
- Oracle Database 23ai (AI Vector Search for Historical Bid Matching, OCI Document Understanding for Tickets/Plans)
- Viscosity AMP (Role-Based Security for Foremen, Estimators, Dispatchers, Mechanics, and External GCs)
- APEX Office Print (AOP) for AIA Billing Backups, Bid Proposals, Certified Payroll & Concrete Washout Manifests
- Automated REST / CSV Connectors for QuickBooks, Vista by Viewpoint, Spectrum, Sage 300 CRE, and Oracle Fusion

---

## 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: Why build an internal construction and multi-service ERP on Oracle APEX + 23ai instead of buying HCSS HeavyJob or a niche landscaping ERP?
- **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)**: COTS tools force you to choose between heavy-civil rigidity (HeavyJob/HeavyBid) or single-trade 'Green' landscaping ERPs that cannot handle dump-truck hauling, concrete washout container logistics, or mass grading. With Oracle APEX 24.2 and Oracle Database 23ai, we deliver a system tailored 100% to every service line you operate, in 5 to 8 weeks, with $0 per-user licensing fees.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 2: How do you migrate our historical estimates and cost history out of HeavyBid and HeavyJob?
- **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)**: We extract your historical HeavyBid assemblies, bid tabs, equipment rates, and HeavyJob daily timecard/cost-code history into structured Oracle 23ai tables and AI Vector indexes. Your estimators keep all their institutional history while gaining AI-assisted takeoff and bid matching.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 3: How does your system stop foremen from hoarding equipment on jobsites?
- **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)**: We pair mobile barcode check-in/check-out with automated daily internal job rental billing. As long as an excavator, truck, or attachment is checked out to Job #104, Job #104's budget is charged the daily internal rental rate until the foreman checks it back into the yard or transfers it to another active crew.
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 4: Can external subcontractors, haulers, and homebuilder customers log into the portal without costing us per-seat fees?
- **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. Oracle APEX is licensed by underlying database compute (ECPU/OCPU), not per named user. You can grant portal access to 500 internal crew members and 5,000 external subcontractors, third-party truckers, and GC customers at $0 per-user license cost, secured by Oracle Virtual Private Database (VPD).
- **Evaluator Score (0 to 10 Points)**: `[   / 10 ]`

### Vendor Question 5: 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 6: 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 `Construction Timekeeping, HeavyJob/HeavyBid & Multi-Service Field ERP` 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-029` | Companion Portal: https://oracle-apex-erp-portal-extensions.web.app/ | This site is designed by Viscosity.AI*