Prerequisites for AI Features

Complete the required database configuration before using AI features in Essbase.

Before you use AI features in Essbase, configure the required database privileges and network access for the database user that will access Oracle Cloud Infrastructure GenAI services.

These prerequisites apply to the following AI features:

• Ask Essbase
• AI Query
• AI Calculation Assistant
• MCP Server

Required Database Privileges

Grant the following privileges to the oracle database user that will use AI features.

GRANT CREATE SESSION TO <YOUR_DB_USER_NAME>;
GRANT CONNECT, RESOURCE TO <YOUR_DB_USER_NAME>;
GRANT EXECUTE ON DBMS_CLOUD TO <YOUR_DB_USER_NAME>;
GRANT EXECUTE ON DBMS_VECTOR TO <YOUR_DB_USER_NAME>;
GRANT EXECUTE ON DBMS_CLOUD_AI TO <YOUR_DB_USER_NAME>;
GRANT EXECUTE ON DBMS_CLOUD_AI_AGENT TO <YOUR_DB_USER_NAME>;
GRANT EXECUTE ON DBMS_CLOUD_PIPELINE TO <YOUR_DB_USER_NAME>;

Configure Network Access

Run the following PL/SQL as the ADMIN user to configure network access to the Oracle Cloud Infrastructure Generative AI inference endpoint.

Note:

Select the appropriate Oracle Cloud Infrastructure Generative AI inference endpoint for your deployment and performance requirements. For example:

• inference.generativeai.us-chicago-1.oci.oraclecloud.com
• inference.generativeai.us-ashburn-1.oci.oraclecloud.com
• other inference endpoints are also available.

BEGIN 
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => 'inference.generativeai.us-chicago-1.oci.oraclecloud.com',
ace => xs$ace_type(privilege_list => xs$name_list('http'),
principal_name => '<YOUR_DB_USER_NAME>',
principal_type => xs_acl.ptype_db));
END;