Frequent ORA-29273 (HTTP request failed) in UTL_HTTP while calling HCM REST API
Summary:
We are calling an Oracle HCM REST API (OTL) using UTL_HTTP (POST request with JSON payload).
Sometimes the request fails with:
ORA-29273: HTTP request failed
But when we reprocess the same file again without any changes, it works successfully.
Questions
- Why does this error happen intermittently?
- Is it due to timeout, throttling, or network issues?
- What is the best way to handle or avoid this error?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0