Hi,
I have two oracle cloud accounts. One is my personal account and one from my employer. I created an APEX app in my personal account, exported it into a single SQL file, and imported that file into employer account.
Before importing I created the required schema in Employer Apex DB with appropriate tables and lookup values.
After importing, I am able to go into APEX design mode and see the app. I was able to manage the service/workspace and add users. But I couldn't run the APEX application in preview mode and login.
If I login with the admin account of the workspace I still get access denied error. The only thing that changed between my account and employer account is I modified the application ID from 104 to 110.
I thought I can add a new apex user using the below PL/SQL but no luck adding it.
-- SELECT * FROM APEX_APPL_ACL_USERS;
begin
APEX_ACL.ADD_USER_ROLE (
p_application_id => 110,
p_user_name => 'myadmin01',
p_role_static_id => 'ADMINISTRATOR' );
end;
I get the below error:
ORA-01403: no data found
ORA-06512: at "APEX_240100.WWV_FLOW_ACL_API", line 74
ORA-06512: at line 2
https://docs.oracle.com/error-help/db/ora-01403/
Error at Line: 7 Column: 0
Since I couldnt get to the app's admin interface I couldnt add a user, how else can I add a user or solve this issue?
Thanks,
Nachi