Already found the solution, setting the NLS language in the extension to what is set in the database is the key. :)

Super ! Thanks for additional materials!!!

Yes, adding multiple tables in the object list in the profile can enable AI models to understand foreign key constraints and allow you to ask questions based on descriptions in lookup tables. When you define the relationships and constraints properly, the AI can leverage these to provide more accurate and contextually relevant responses. To create a profile that includes multiple tables with foreign key constraints in Oracle APEX using the approach similar to the Select AI example, follow these steps: 1. Define the Tables and Relationships: Ensure your database tables are properly defined with foreign key constraints. E.g: CREATE TABLE departments ( department_id NUMBER PRIMARY KEY, department_name VARCHAR2(100) ); CREATE TABLE employees ( employee_id NUMBER PRIMARY KEY, employee_name VARCHAR2(100), department_id NUMBER, CONSTRAINT fk_department FOREIGN KEY (department_id) REFERENCES departments(department_id) ); 2. Create the Profile: Define a profile in your APEX application that includes these tables and their relationships. The profile configuration will help the AI understand the data context and relationships. You can create the profile with the code provided in the demo with a small modification for adding the foreign key relationships. E.g: BEGIN DBMS_CLOUD_AI.create_profile( profile_name => 'OPENAI_APEX', attributes => '{ "provider": "openai", "credential_name": "OPENAI_CRED_APEX", "object_list": [ { "owner": "<WKPS_USER>", "name": "employees", "primary_key": "employee_id", "columns": ["employee_id", "employee_name", "department_id"] }, { "owner": "<WKPS_USER>", "name": "departments", "primary_key": "department_id", "columns": ["department_id", "department_name"] } ], "foreign_keys": [ { "child_table": "employees", "child_column": "department_id", "parent_table": "departments", "parent_column": "department_id" } ] }' ); END; / For more info please visit this article: medium.com/@cristina.varas98/enhancing-data-analysis-with-select-ai-in-oracle-apex-9d00b070a073