REST API

Reading the Room: HTTP Status Codes in Oracle EPM Cloud

CloudADDIECloudADDIEMarch 5, 20263 min read
Reading the Room: HTTP Status Codes in Oracle EPM Cloud

Part 5 of 12 in the Oracle EPM Cloud REST API series.

Every response Oracle EPM Cloud sends back carries an HTTP status code: a three-digit number that tells you, at a glance, whether the request succeeded, failed, or is still being worked on. These follow standard HTTP conventions, so the same codes you would see from almost any web service apply here too.

CodeMeaningWhat it tells you
200OKThe request completed successfully. Typical for GET calls and simple POSTs.
201CreatedA new resource was created. Check the Location header for its URL.
202AcceptedThe request was accepted but is still processing asynchronously. Check the Location header for a job resource to poll.
400Bad RequestThe request body or parameters were missing or invalid.
401UnauthorizedAuthentication failed or credentials are missing.
403ForbiddenYou are authenticated, but not authorized to perform this action.
404Not FoundThe URL points to a resource that does not exist, often a typo in an app or job name.
405Method Not AllowedYou used a verb the endpoint does not support.
406 and 415Not Acceptable, Unsupported Media TypeThe Accept or Content Type header did not match what the server expects.
500Internal Server ErrorSomething went wrong on Oracle's end.
503Service UnavailableThe service is temporarily overloaded or down for maintenance.

Two of these deserve extra attention once you start automating.

202 Accepted is a signal, not a finish line. It means Oracle has taken the request seriously and started working on it, not that the work is done. A well-built script watches for the Location header that comes back with a 202 and polls that URL rather than assuming success. This matters most for anything long running, like a sizable data import or a cube refresh.

The first digit tells you where the problem lives. Codes in the 400s mean something about your request needs fixing: a bad parameter, a missing header, an authentication issue. Codes in the 500s mean the problem sits on Oracle's side of the connection. That distinction shapes how a script should react. A 400 means stop and check your payload. A 500 or 503 might be worth a short retry, since the same request could succeed a minute later once the service recovers.

Build the habit of logging the status code alongside every response body your scripts capture, even when a call succeeds. When something eventually does go wrong three months from now, having a history of what codes a particular job normally returns makes the difference between spotting an anomaly immediately and re-tracing your steps from scratch.

Status codes tell you whether the request itself was accepted. They do not tell Oracle EPM Cloud who you are in the first place. That is the role of authentication, covered next.

Free Consultation

Want help from senior EPM and ERP consultants?

Schedule a free consultation with CloudADDIE to talk through your planning, consolidation, reporting, or data challenges.

Keep Reading

Related posts

REST API

Authenticating to the Oracle EPM Cloud REST API

3 min readRead post
REST API

The HTTP Verbs You Need to Know

3 min readRead post
REST API

What's Actually Inside a REST Request

3 min readRead post