Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Configure IA : ORA-20987 error in backend AI service

Alexis BMay 5 2025

Hello,

We are using APEX 24.1 on DB 19c SE (on-premise) and when trying to use IA :
- Create App from IA
- APEX Assistant in App Builder
- Call to apex_ai.chat function in a Dynamic Action

We always get following error :
ORA-20987 error in backend AI service

We tried with Open AI and Cohere and we got same results (We create free account for both as we would like to try them before to buy anything)

ACLs are opened to all host (*) and all port (lower port = null, upper_port = null)
And ‘connect’ privilige is given to APEX_240100
We are already able to send mail from APEX

Example of Open AI configuration :

Does anyone would be able to help us please?

May this be linked to the DB Version (DB 19c SE on-premise) ? Or are we mandatory to use paid version of AI API?

Thanks

Best regards,

This post has been answered by InoL on May 5 2025
Jump to Answer
Comments
Post Details
Added on May 5 2025
2 comments
232 views