Group Asset Summary Report and Group Asset Detail Report Ends With ORA-06502 (Doc ID 2211348.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Other Issues

When attempting to run the Group Asset Summary Report and Group Asset Detail Report, the following error occurs.

ERROR
-----------------------
Job processor caused exception
[INSTANCE_ID=cffar12070x04.usdc2.oraclecloud.com.1471771307091] [INSTANCE_JOB_ID=2567]::oracle.xdo.servlet.scheduler.ProcessingException: ::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=cffar12070x04.usdc2.oraclecloud.com.1471771307091] DataException:[INSTANCE_JOB_ID=2567] oracle.xdo.XDOException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms