← 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