I tried the published work around:
The bug is still being worked by the Development and the workaround is available to override this issue.
As a workaround you can make APEX_PUBLIC_USER local user by updating user$.spare1 column in the PDB.
sqlplus / as sysdba
alter session set container=MANCO2;
create table backup_user$ as select * from user$;
update user$ set spare1=0 where name='APEX_PUBLIC_USER';
conn / as sysdba
I learned the hard way not to use shutdown abort in a PDB. So yes, this did correct the error for APEX_PUBLIC_USER and did the same for ORDS_PUBLIC_USER.
However, I'm still not getting my application to appear on the web page.
Oracle Rest Data Services is showing:
404 Not Found
- The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured
Not sure if I need to change SPARE1=0 for the other APEX users, since APEX only exists in the PDB. Again I moved a 12.2 Non-CDB to a PDB. I didn't find anything describing what changes need to be performed on the APEX (5.1.2) side of the house for this transition running with ORDS (3.0.11) and Tomcat (7.0) for the web interface. Any suggestions on where to look or try would be helpful. Thanks.