ORA-20001: You have exceeded the maximum number of web service requests per workspace

[admin]

Hi,
If you get this error while using RESFULL web service then you need to login as Internal/Administration and set setting to higher,

ORA-20001: You have exceeded the maximum number of web service requests per workspace

Under Workspace isolation as by default it is 1000 in last 24hrs rolling window,

Maximum Web Service Requests : 20000

Screenshot 2024-06-12 202300.png

to check count of existing,

select trunc(request_date, 'HH24') as hh, count(*) as cnt
from apex_webservice_log
where request_date > sysdate - 1
group by trunc(request_date, 'HH24')
order by 1;

Enjoy