ORA-00942: table or view does not exist - It DOES exist - 19c

Hello,

We have upgraded the Oracle database from 12c to 19c on Oracle EBS 12.2.8 environment. For some of our programs, we get ORA-00942 error (mentioned above).

• BELOW IS THE PLSQL CODE

      In PLSQL code:
       PROCEDURE (errbuf out varchar2, retcode out varchar2) IS
            avar varchar2(40) := 'My Name Is';
            bvar varchar2(40) := 'JOHNSMITH';
            begin
            select  intro, name into avar, bvar from mytable where rownum = 1;
            dbms_output.put_line('code starts here');
            dbms_output.put_line('details:'||avar||bvar);
            end;

• WHEN I RUN THIS CODE FROM SQL PLUS

It is a success. No issues, output print just fine.

• WHEN I RUN THIS CODE FROM EBS, AS CONCURRENT PROGRAM, I GET FOLLOWING AND THE REQUEST ENDS UP IN RED.