My Oracle Support Banner

Diagnostics Apps Check (OMCHECK) Errors With ORA-06502: PL/SQL: Numeric Or Value Error If An Object Name Is Longer Than 30 Characters (Doc ID 2818391.1)

Last updated on NOVEMBER 15, 2024

Applies to:

Oracle Order Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

In 19C database version, object name length supports a name of more than 30 characters in length.
Diagnostics: Apps Check fails with the below error for any application that has an object name longer than 30 characters. 


For example object name below defined for the Incentive Compensation application is longer than 30 characters and therefore errors as below:

CN CN_XREF_TBL CN_XREF_TBL_PK NORMAL 28-AUG-21 03:21:30 VALID

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 106



Steps:

1) Order Management Super User Responsibility
2) Reports, Requests -> Request -> Single Request
3) Diagnostics: Apps Check

Changes

 

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.