Hello, I'm trying to do Google Authentication with Apex 24.1.6 (updating soon).
I have set up a Google OAuth 2.0 Client with authorized redirect URIs to https://myapexurl/ords/apex_authentication.callback.
I have added in the Google SSL certs to the Oracle wallet I'm using for this instance of Apex, it is working for sending emails through Google.
I have added ACLs for accounts.google.com, oauth2.googleapis.com, and apps.googleusercontent.com (not sure if I need all of these, but I'm trying to get it to work).
In Apex, I have set up a web credential called Google IdP using OAuth2 Client Credentials. For OAuth Scope, I have tried just profile, just email, and both profile, email. I have copied and pasted the client ID and secret.
For the Authentication Scheme named GoogleOAuth, I have set it to Social Sign-in, picked the Google IdP as the credential Store, and Google as the Authentication Provider. For scope, here I have tried email and profile in multiple combinations.
I get the Sign in with Google page, pick my account, enter the password, and then I'm redirected back to Apex with the message “Error processing request …” The debug log shows the following
I have googled and googled, but haven't found anything else I am missing. Any suggestions?
Thanks
Error: Error processing request.
- Additional info: Contact your application administrator.
Details about this incident are available via debug id "670189".
- 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: -6502
- SQL error: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APEX_240100.WWV_FLOW_JWT", line 460
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 902
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 "APEX_240100.WWV_FLOW_JWT", line 460
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 902
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 2604
- Statement:
- Component: APEX_APPLICATION_AUTH GoogleOAuth (40031317059009127)