Agent to convert SQL to BQL
Issue Description: Unable to locate/invoke the AI Agent for SQL to BQL transformation in Fusion 26C.Context: We are setting up a Data Sync pipeline from Oracle to Autonomous Transaction Processing (ATP). We need to leverage the AI-assisted Query Transformer Agent to analyze raw SQL statements and auto-generate the equivalent BQL syntax mapped to RODS business object views. Current State & Findings:
- Environment Version: Oracle Fusion 26C
- Identified Agents: We tested
ORA_EXTRACTION_QUERY_PREPROCESSORandORA_EXTRACTION_QUERY_EXECUTOR_WF. - Problem: Triggering these via the workflow engine results in static output only. The dynamic AI translation is not occurring.
Tagged:
1