My Oracle Support Banner

Fusion Global Payroll: Apex_web_service Call. ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130. ORA-06512: at "APEX_050100.WWV_FLOW_WEBSERVICES_API", line 191 (Doc ID 2483185.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.18.05.0 and later
Oracle Fusion Global Payroll - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.05.0 version, Global Payroll

When attempting to invoke an HCM extract remotely,
the following error occurs:

ERROR
-----------------------
Error report -
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "APEX_050100.WWV_FLOW_WEB_SERVICES", line 1022
ORA-06512: at "APEX_050100.WWV_FLOW_WEBSERVICES_API", line 191
ORA-06512: at line 25
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
  Fix the error and retry the HTTP request.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. attempting to invoke an HCM extract remotely;
2. stuck error occurs.

Trying to invoke an HCM extract remotely and am not sure of the apex_web_service call parameters for url & action.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.