After Upgrading Database, All Credit Card Authorizations Are Failing With "ORA-24247: network access denied by access control list (ACL)" (Doc ID 1292939.1)

Last updated on MARCH 26, 2024

Applies to:

Symptoms

1. After upgrading database to  11g (11.2.0.1) or to 19C, Payments is not longer working for receipts processing. All credit card authorizations during receipt creation or remittances are failing with following errors:

err code=-24247
err msg=ORA-24247: network access denied by access control list (ACL)
In G_EXC_UNEXPECTED_ERROR Exception
status :=U

2. FND Log and the AR_AUTORECAPI: Automatic Receipts Creation Program (API) log show the error messages:

ORA-29273: HTTP request failed
ORA-6512: at "SYS.UTL_HTTP", line 1029
ORA-24247: network access denied by access control list (ACL)
ORA-6512: at line 6

3. Detect receipts with Authorization failure.

4. The Automatic Receipts Execution Report For Creation/Approval/Format shows COMMUNICATION_ERROR in the Exception column.

5. Query to test connectivity from Database to Payments engine shows the following error when executed with "apps" user:

-- For non-ssl connection:
select utl_http.request('&value_of_IBY_Ecapp_URL_profile_option') from dual;

err msg=ORA-24247: network access denied by access control list (ACL)

-- For ssl connection:
select utl_http.request('&value_of_IBY_Ecapp_URL_profile_option',null,'file:&value_of_Database_Wallet_Directory_profile_option', null) from dual;

err msg=ORA-24247: network access denied by access control list (ACL)

Changes

Upgraded database to 11g or 19C

Cause

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