Diagnostics AppsCheck Errors, ORA-06502 ORA-06512 Purchasing OMCHECK.SQL

(Doc ID 372987.1)

Last updated on JANUARY 09, 2018

Applies to:

Oracle Order Management - Version to [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 16-Dec-2010


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

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

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

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


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