I have heard that APEX supports REST so I decided to try this out on my SOA CS environment's
DB CS instance. AS per usual, I studiously avoided reading any documentation.
This should be simple, right?
I created a simple table Customers -
Now, as luck would have it I locked my ADMIN APEX user out.
This I fixed as follows -
ssh into the DB CS machine
alter session set current_schema = APEX_050000;
select user_id, substr(user_name, 1,10), account_locked from wwv_flow_fnd_user;
set web_password = 'yourNewPassword'
where user_name = 'ADMIN'
For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.