Collect Shipment and Booking History failed with ORA-24247: network access denied by access control list (ACL) error

Issue:

"Collect Shipment and Booking History" in ASCP completed with below errors in the log file:

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

Cause:

Demantra schema in ASCP does not have "connect" grant on the network ACL.

Verification:


SYS-UAT> select * from dba_network_acls;

HOST  LOWER_PORT UPPER_PORT ACL                        ACLID
----- ---------- ---------- -------------------------- -------------------------
*                           /sys/acls/OracleEBS.xml    71572A92FE0405D0B59100B2A

SYS-UAT> SELECT DECODE(DBMS_NETWORK_ACL_ADMIN.check_privilege('OracleEBS.xml', 'MSDEM', 'connect'),1, 'GRANTED', 0, 'DENIED', NULL) privilege FROM dual;

PRIVILE

-------

Solution:

Grant connect on ACL to demantra schema (MSDEM in this case)

BEGIN

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=>'/sys/acls/OracleEBS.xml',

   principal => 'MSDEM',

   is_grant  => true,

   privilege => 'connect');

COMMIT;

END;

/

Verfication:

SYS-UAT> SELECT DECODE(DBMS_NETWORK_ACL_ADMIN.check_privilege('OracleEBS.xml', 'MSDEM', 'connect'),1, 'GRANTED', 0, 'DENIED', NULL) privilege FROM dual;

PRIVILE

-------

GRANTED

Now, rerun the program and it completes successfully without any issues.