My Oracle Support Banner

ORA-06512: At "APEX_180100.WWV_FLOW_CREDENTIAL", Line 424 in APEX with Active Directory Authentication (Doc ID 2451220.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Application Express (APEX) - Version 18.1.0.00.45 and later
Information in this document applies to any platform.

Symptoms

On : 18.1.0.00.45 version, MICC Transfer to TSC

ORA-06512: at "APEX_180100.WWV_FLOW_CREDENTIAL", line 424

In APEX we have implemented authentication with Active Directory. Authentication Provider = OpenID Connect Provider.

Curently, the only useful information we get back from ADFS is if user is connected or not.
We would like to upgrade this functionality by getting more information from ADFS (like organisation of an user and similar).
But this is not possible as when ADFS sends more data to Apex, connection into Apex breaks with forwarding lines.

According to dump file, there is a bug in APEX_180100.WWV_FLOW_CREDENTIAL.SET_TOKEN_INTERNAL procedure. It looks that one variable in this procedure is to small.

Can you make an investigation about this problem?

- component: APEX_APPLICATION_AUTH ADFS_GOV_SI (3499684476870467)
"- error_backtrace: ORA-06512: at "APEX_180100.WWV_FLOW_CREDENTIAL", line 424
ORA-06512: at "APEX_180100.WWV_FLOW_CREDENTIAL", line 469
ORA-06512: at "APEX_180100.WWV_FLOW_AUTHENTICATION_NATIVE", line 704
ORA-06512: at "APEX_180100.WWV_FLOW_AUTHENTICATION_NATIVE", line 1779
ORA-06512: at "APEX_180100.WWV_FLOW_PLUGIN", line 2907
ORA-06512: at "APEX_180100.WWV_FLOW_PLUGIN", line 3067
ORA-06512: at "APEX_180100.WWV_FLOW_AUTHENTICATION", line 1727
ORA-06512: at "APEX_180100.WWV_FLOW", line 3983
"
"- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APEX_180100.WWV_FLOW_CREDENTIAL", line 424
ORA-06512: at "APEX_180100.WWV_FLOW_CREDENTIAL", line 469
ORA-06512: at "APEX_180100.WWV_FLOW_AUTHENTICATION_NATIVE", line 704
ORA-06512: at "APEX_180100.WWV_FLOW_AUTHENTICATION_NATIVE", line 1779
ORA-06512: at "APEX_180100.WWV_FLOW_PLUGIN", line 2907
ORA-06512: at "APEX_180100.WWV_FLOW_PLUGIN", line 3067
ORA-06512: at "APEX_180100.WWV_FLOW_AUTHENTICATION", line 1727"
- ora_sqlcode: -6502
- apex_error_code: APEX.UNHANDLED_ERROR
- is_internal_error: true
- display_location: ON_ERROR_PAGE
- additional_info: Contact your application administrator.

ERROR
-----------------------
ORA-06512, ORA-06502

Cause

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
Symptoms
Cause
Solution
References


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