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!

Apex - Create Rest data sources in Apex to call SaaS Rest APIs based on Oauth2.0 auth type using IDCS as IDP

Parul_ORAMay 8 2024 — edited May 8 2024

Hi Team,

I have Cloud Oracle Apex application 23.2 where I have created Rest data sources for ‘Oracle Cloud Applications (SaaS) REST Service’ type. I am providing all the details and when it comes to Authentication adding the details as below:

and returning error: ORA-20001: Authentication failed.

In IDCS setup:

created one confidential application and selected grant types are: Client credentials, refresh token and Authorization code. and other details like callback url/scope is added. (Apex application callback url is not added in Scope, but OIC callback url)

In Postman when selecting grant type as authorization code, API response is 200 ok, but I know Apex is only supporting grant type as client credentials. Using client credential as grant type in postman, token is generating but API is responding 401 unauthorized.

Please guide me to setup Apex application and IDCS so that I can call Fusion SCM APIs from Apex using Oauth2.0.

Thanks.

This post has been answered by Carsten Czarski-Oracle on Jul 24 2024
Jump to Answer
Comments
Post Details
Added on May 8 2024
15 comments
2,266 views