Function based index not getting compiled after session is altered to a different schema

Function based index not getting compiled after session is altered to the user having the required function implementation

Steps to reproduce

// login using system user or high privileged user

// create dummy user with required permissions

create user dummy_user identified by dummy_user;

grant query rewrite, create session, create table, create view, create sequence, create procedure, create trigger, create type, create materialized view, create job, unlimited tablespace to dummy_user;

grant select on v$session to dummy_user;

grant select on gv$session to dummy_user;

// Alter the session

alter session set current_schema = dummy_user;

CREATE OR REPLACE FUNCTION get_dummy_number(name IN varchar2)