APEX

Oracle Autonomous 19c, APEX 24.1.7

I am using custom authentication. I wanted to enable RAS on my application. I tried to follow along the steps here here (following exactly the steps, works fine, but that's for APEX authentication schema. I want to implement RAS for my custom auth scheme). I also relied heavily on the steps here.

MYFIN is the schema name that has all my tables. APEX app is attached to WKSP_MYFIN schema

1. Login as admin
2. created db role: db_role_user
3. granted dml on table to the role
4. grant execute on myfin.authentication_pkg to db_role_user;
5. grant db_role_user to myfin with admin option;
6. EXEC XS_ADMIN_CLOUD_UTIL.GRANT_SYSTEM_PRIVILEGE('PROVISION','MYFIN');
7. EXEC XS_ADMIN_CLOUD_UTIL.GRANT_SYSTEM_PRIVILEGE('ADMIN_ANY_SEC_POLICY','MYFIN');
8. login as MYFIN
9. exec sys.xs_principal.create_role(name => 'app_role_user', enabled => true);
10. grant db_role_user to app_role_user;
11. exec sys.xs_principal.create_user(name => 'XSTEST', schema => 'MYFIN');
exec sys.xs_principal.set_password('XSTEST', 'pasword');
exec sys.xs_principal.grant_roles('XSTEST', 'XSCONNECT');
exec sys.xs_principal.grant_roles('XSTEST', 'app_role_user');

I stopped here and did not create any acls (although I tried previously and got errors too).

When I try to login, I get this error: ORA-46069: operation disallowed in an application session

The details:

The highlighted PLSQL code is my login process, and it calls my custom authentication function. This works fine once I disable RAS.

Where can I start investigating this from?