I am using Oracle Apex 19.1 along with ords 19.1 on oracle database 18.1 XE
Created an Oracle Apex application which is using google authorization . After running application I see google login page but after putting in credentials I see error page below
Upon checking debug for oracle apex application i am getting below error
| SID=112 USER=APEX_PUBLIC_USER INSTANCE=1 | 9 |
0%
| - |
| 4 | 0.27205 | 0.00003 | Error: Error processing request. | 1 |
0%
| - |
| 5 | 0.27208 | 0.00002 | - additional_info: Contact your application administrator. | 4 |
0%
| - |
| 6 | 0.27209 | 0.00035 | - display_location: ON_ERROR_PAGE | 4 |
0%
| - |
| 7 | 0.27244 | 0.00003 | - is_internal_error: true | 4 |
0%
| - |
| 8 | 0.27248 | 0.00002 | - apex_error_code: APEX.UNHANDLED_ERROR | 4 |
0%
| - |
| 9 | 0.27249 | 0.00003 | - ora_sqlcode: -29273 | 4 |
0%
| - |
| 10 | 0.27252 | 0.00003 | - ora_sqlerrm: ORA-29273: HTTP request failed ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1035 ORA-29024: Certificate validation failure ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1148 ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 934 ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1580 ORA-06512: at "APEX_190100.WWV_FLOW_WEBSERVICES_API", line 408 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 79 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 362 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 439 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_NATIVE", line 511 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_NATIVE", line 1381 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 2913 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 3073 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION", line 1750 | 4 |
0%
| - |
| 11 | 0.27255 | 0.00003 | - error_backtrace: ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1035 ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1148 ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 934 ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1580 ORA-06512: at "APEX_190100.WWV_FLOW_WEBSERVICES_API", line 408 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 79 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 362 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 439 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_NATIVE", line 511 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION_NATIVE", line 1381 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 2913 ORA-06512: at "APEX_190100.WWV_FLOW_PLUGIN", line 3073 ORA-06512: at "APEX_190100.WWV_FLOW_AUTHENTICATION", line 1750 ORA-06512: at "APEX_190100.WWV_FLOW", line 4052 | 4 |
0%
| - |
| 12 | 0.27257 | - | - component: APEX_APPLICATION_AUTH TestGoogleAuthentication (15965224081894190) |
I am unable to figure out what is wrong , however same application is working with apex.oracle.com , please help