My Oracle Support Banner

Diagnostics AppsCheck Errors, ORA-06502 ORA-06512 Purchasing OMCHECK.SQL (Doc ID 372987.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Order Management - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
 


Symptoms



On 11.5.10.2 in Production:
When attempting to run the appscheck concurrent request for Purchasing
the following error occurs.


ERROR
Omcheck.sql for po (201) fails with ora-06502 ora-06502
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 70


STEPS
1. Responsibility OM Super User
2. Nav Path: Reports, Request -> Run Request -> Single Request
3. Choose "Diagnostics: Apps Check", select Purchasing from the LOV.


BUSINESS IMPACT
Due to this issue, users cannot provide diagnostics output of appscheck for puchasing to service request.




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.