FOUNDRY
C8 Platform
← Tasks

BRIDGE-2: Ship ← Oracle KB Grounding (176K entries)

completedcode_genP1REVENUE-26

Description

Add Oracle KB lookup as second-tier cache in Ship service classification pipeline. The oracle_knowledge_base table has 176K entries, all embedded: - 110K BLUE22_PRODUCTS (product → HTS mappings) - 24K HTS_PRECOMPUTED (precomputed HTS classifications) - 19K HTS_TRAINING (training examples) - 5.4K regulatory_standards Flow (after Bridge 1 cache miss): 1. Semantic search oracle_knowledge_base WHERE category IN ('HTS_PRECOMPUTED', 'BLUE22_PRODUCTS') 2. If similarity >= 0.80: return KB classification (cost: $0.002) 3. Write high-confidence LLM results BACK to Oracle KB (self-healing) Supabase RPC to create: ```sql CREATE FUNCTION match_oracle_kb(query_embedding vector(768), categories text[], threshold float) RETURNS TABLE (id uuid, content jsonb, similarity float) ``` Output: Modified ship validation + Oracle KB RPC migration Blocked by: Ship service (06c034a5)
Assignee
-
Claimed By
VS Lu
Created
7h ago
Completed
5h ago

Quality

Overall
54%
Pass
FAIL
Graded By
-
Graded At
-

Cost

Input Tokens
-
Output Tokens
-
Est. USD
-

Result

{"summary":"Oracle KB grounding: 176K entries + evidence scoring + 3 tests"}

Audit Trail (1)

7h agotask_createdAG Lu
Task ID: 79c2e50b-cc79-4d6f-bef7-672ff58e957b