ORA-29273: HTTP request failed, ORA-06512: at “SYS.UTL_HTTP”

ERROR

ORA-29273: HTTP request failed, ORA-06512: at “SYS.UTL_HTTP”, ORA-12545: connect failed because target host or object does not exit, ORA_06512: at “APPS.HR_LOCATION_API”

SOLUTION

1. Go to System Administrator responsibility
2. Navigate to  Profile > System
3. Query the System Profile Option ‘IRC: Geocode Host’ at ‘Site’ Level
4. Update its value to null, and save changes.