<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
0D5KZ00000yocXx0AIOkta Classic EngineIntegrationsAnswered2025-08-18T16:56:08.000Z2025-08-14T13:10:45.000Z2025-08-18T16:56:08.000Z

MadhusudanS.93394 (Customer) asked a question.

Fetching payload in ORACLE apex while using OKTA as authentication

Hi All,

 

I have implemented OKTA as authentication in ORACLE APEX using SSO option. The OKTA team is sending custom claims in a payload. How should I fetch this payload in oracle apex. Could anyone of you tell the process to get this payload in apex and use the custom claim.

This is the sample payload sent by OKTA team. Shoud I write any PLSQL code in post authentication procedure or any kind of process.

Sample payload.

{

 

"sub": "00u1eruv3lwot0h8",

 

"name": "Ram",

 

"email": "Ram@gmail.com",

 

"ver": 1,

 

"iss": "https://oktapreview.com/oauth2/default",

 

"aud": "0oa2g83asah4GdhCH0h8",

 

"iat": 17550123654,

 

"amr": [ “pwd”],

 

"idp": "00ojo0gzckm4u0K4O5A0h7",

 

"nonce": "nonce",

 

"preferred_username": "Ram@gmail.com",

 

"auth_time": 1000,

 

"at_hash": "preview_at_hash",

 

"apex_username": "ram",

 

"Apex_role": ["admin","contributer","reader"] }


This question is closed.
Loading
Fetching payload in ORACLE apex while using OKTA as authentication