My Oracle Support Banner

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

Last updated on AUGUST 29, 2023

Applies to:

Oracle Retail Data Storage Cloud Service - Version 22.1 and later
Information in this document applies to any platform.


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.


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:

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?


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

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