Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ACL Error for OCI Web Credentials on APEX ATP

ShuntMay 3 2020 — edited May 6 2020

Hi All

  1. I have created Web Credentials in the Workspace on my APEX autonomous instance of type "Oracle Cloud Infrastructure (OCI)".
  2. I have then created a Web Source Module of type "Oracle Cloud Infrastructure (OCI)" for the following OCI API:
    • GET /20181116/waasPolicies/ocid1.waaspolicy.oc1../wafLogs?
  3. When I try to discover the API i get an authentication error.
  4. If I create the Web Source Module manually, when I try and use it I get the following ACL error:

Authentication failed.

Technical Info (only visible for developers)

is_internal_error: true

apex_error_code: WWV_FLOW_WEB_SERVICES.AUTHENTICATION_FAILED

ora_sqlcode: -29273

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

component.type: APEX_APPLICATION_PAGE_REGIONS

component.id: 12107542587041551001

component.name: New

error_backtrace:

ORA-06512: at "SYS.UTL_HTTP", line 450

ORA-06512: at "SYS.UTL_HTTP", line 1180

ORA-06512: at "APEX_200100.WWV_FLOW_WEB_SERVICES", line 1212

Additional Points

  • I get the same error on apex.oracle.com.
  • Neither ATP or apex.oracle.com require ACLs for Web Service calls.  From the documentation:

"Each Autonomous Transaction Processing instance is preconfigured with a network access control list (ACL) to permit outbound web service calls from Application Express. No further configuration by application developers is necessary."

  • The credentials I am using work fine from Postman
  • I get the same issue connecting to other OCI APIs

Anyone else had any issues with this?

Thanks

Shunt

1.0.0.20
This post has been answered by Shunt on May 6 2020
Jump to Answer
Comments
Post Details
Added on May 3 2020
1 comment
1,104 views