Error While Calling Apex Web Credential Static Identifier From DBMS_SCHEDULER Job (Doc ID 2970885.1)

Last updated on AUGUST 29, 2023

Applies to:

Goal

On : 22.1 version, Integrating Source Application

Error while calling Apex Web Credential Static Identifier from DBMS_SCHEDULER job


For making rest service calls from Apex, the Apex web credentials calls are used.
Login to Apex --> App builder --> Workspace utilities --> Web credentials --> Created the credential with the Static Identifier as 'MFCS_DEV1_OAUTH'.

When this Static Identifier is used to call a web service using apex_web_service.make_rest_request, it works as expected.

Example:

A stored procedure which should update PO via rest service runs successfully


If the same procedure was scheduled by DBMS_SCHEDULER.CREATE_JOB , the Static Identifier is not recognized and below error gets logged:

--Error
ORA-01403: no data found ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL",
line 116 ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL",
line 107 ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API",
line 542 ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API",


Why are the Apex Web Credentials not getting recognized from the DBMS_SCHEDULER job and how should such requests be handled?
 

Solution

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