My Oracle Support Banner

Errors ORA-06502 and ORA-06512 Occurs When Viewing The Magnetic File (Doc ID 580111.1)

Last updated on APRIL 06, 2024

Applies to:

Oracle Concurrent Processing - Version 12.0.3 to 12.0.3 [Release 12]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Submitted a custom program using concurrent manager but upon completion, the
output cannot be viewed because of the error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_CP_OPP_REQ", line 539 Error


Changes

Creating a new Magnetic Transfer file by using PYUMAG process. Process has finished without
errors. Got error in this process when pressing on button View Output in Requests form.
Full text of error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_CP_OPP_REQ", line 539
--------------------------------------------------------------
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception 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
Changes
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.