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!

Apex with cohere failed to create a simple app (interactive report) other than EMP and DEPT Table

myluism3 days ago

Hi. this is the situation:

  1. I requested a WS in apex.oracle.com.
  2. Configured Cohere AI Service successfully
  3. Created a simple app from create application using AI base on EMP Table. Application created successfully.
  4. I´m failing to create an identical application but based on some other table. One that makes sense to me and it is appropiate for my goals. Wizard is not able to create it.

This table belongs to same schema as DEPT and EMP

I can query the table from SQL Commands page:

What am I missing here? Do I have to enable it for rest services?

My ultimate goal is to create a chat bot or use Gen AI where users can ask question about this data (AI Service Conf and RAG source). I have tried this but get error ORA-20987. so I´m trying the easiest way first. No luck. None of then work.

Comments
Post Details
Added 3 days ago
3 comments
67 views