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

Last updated on JULY 07, 2017

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.
Checked for relevance on 16-Dec-2010


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

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