Oracle Access Manager (OAM) OAuth Revoke Endpoint Fails In The Log File "SQLException: ORA-12899: value too large for column ..." (Doc ID 2975746.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Oracle Access Manager - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

OAuth revoke endpoint fails, in the OAM log file the following error is seen "SQLException: ORA-12899: value too large for column ..."

Background

Enabled /revoke endpoint OAuth/OIDC endpoint
Testing from postman or other curls result in 200/success result code.
Integrated an external application with OIDC, which frequently fails with error "{"error":"server_error","error_description":"Internal Server Error"}"
During the logout process the OAM log file shows ...

When this happens, logout does not take place and the access token is not invalidated, so it is still possible to access application hitting the "back" button

	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

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