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_authentication.callback error when using social sign-in with keycloak

Sebastian EichhammerOct 18 2024 — edited Oct 18 2024

Hi,

I have a problem with apex_authentication.callback when using authentication social sign-in with keycloak
I have in parallel a setup with Apex 23.1.4 where is working find, but failed in 24.1.
It seems I have no ACL or Certificate problem, Apex is reaching Keycloak and keycloak is sending back a token,
but Apex can't handel it.

I can also see the session in Keycloak:

Error: Error processing request.
- Additional info: Contact your application administrator.
- Display location: ON_ERROR_PAGE
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: true
- Common runtime error: false
- APEX error code: APEX.UNHANDLED_ERROR
- SQL code: -29261
- SQL error: ORA-29261: bad argument
ORA-06512: at "SYS.UTL_ENCODE", line 8
ORA-06512: at "SYS.UTL_ENCODE", line 243
ORA-06512: at "APEX_240100.WWV_FLOW_CREDENTIAL", line 363
ORA-06512: at "APEX_240100.WWV_FLOW_CREDENTIAL", line 952
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 856
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION_NATIVE", line 439
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION_NATIVE", line 1286
ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 4786
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION", line 2240
- Backtrace: ORA-06512: at "SYS.UTL_ENCODE", line 8
ORA-06512: at "SYS.UTL_ENCODE", line 243
ORA-06512: at "APEX_240100.WWV_FLOW_CREDENTIAL", line 363
ORA-06512: at "APEX_240100.WWV_FLOW_CREDENTIAL", line 952
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 856
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION_NATIVE", line 439
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION_NATIVE", line 1286
ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 4786
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION", line 2240
ORA-06512: at "APEX_240100.WWV_FLOW", line 2633

- Statement:
- Component: APEX_APPLICATION_AUTH OpenID (34800197462879157)

Thanks and regards

Sebastian

This post has been answered by Anton Scheffer-Oracle on Oct 18 2024
Jump to Answer
Comments
Post Details
Added on Oct 18 2024
1 comment
679 views