My Oracle Support Banner

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 OCTOBER 26, 2022

Applies to:

Oracle Payments - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

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)

IMPORTANT: Note that getting error "ORA-24247: network access denied by access control list (ACL)" when running the same query with other users (different to 'apps') is expected.

  

Changes

Upgraded database to 11g or 19C

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
Changes
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.