Hi All,
I'm working on Enabling Natural Language Query of EBS 12.2 using the document Updated: Enabling Natural Language Query of EBS 12.2 Using Oracle Generative AI (May 2025)
I have successfully completed the integration — from ADB setup and API enablement to EBS configuration and APEX integration.
However, I’m encountering an intermittent issue in APEX when accessing the ADB Generative AI API. At times, it throws an “HTTP request failed” error. I’m unable to identify the exact cause — most of the time it works perfectly fine, but occasionally it stops working entirely, and then starts working again automatically the next day.
Could anyone please help or guide me on how to troubleshoot this issue?
Current setup:
- Database version: 19.27c
- APEX version: 24.2
- SQL error: ORA-29273: HTTP request failed
ORA-06512: at "APEX_240200.WWV_FLOW_PROCESS_NATIVE", line 55
ORA-06512: at "APEX_240200.WWV_FLOW_CODE_EXEC_PLSQL", line 155
ORA-06512: at "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", line 2757
ORA-06512: at line 67
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES", line 681
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1004
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1688
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1004
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 650
ORA-28759: failure to open file
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 598
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 816
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1652
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 699
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SE~
- Backtrace: ORA-06512: at line 67
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES", line 681
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1004
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1688
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1004
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 650
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 598
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 816
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1652
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 699
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 753
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1332
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES", line 641
ORA-06512: at "APEX_240200.WWV_FLOW_WEBSERVICES_API", line 661
ORA-06512: at "APPS.FND_NLQ_UT~
- Statement: begin DECLARE