My Oracle Support Banner

Planning ODS Load Failed With Error: ORA-06502: PL/SQL: numeric or value error (Doc ID 2762615.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Planning ODS Load failed with error

ERROR

19-MAR 14:13:55 : ORA-06502: PL/SQL: numeric or value error: character to number conversion error
P_table_name = MSC_DELIVERY_DETAILS
19-MAR 14:13:55 : Exchange partition failed
19-MAR 14:13:55 : Error_Stack...
19-MAR 14:13:55 : ORA-06502: PL/SQL: numeric or value error: character to number conversion error

19-MAR 14:13:55 : Error_Backtrace...
19-MAR 14:13:55 : ORA-06512: at "APPS.MSC_CL_MISCELLANEOUS", line 32
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 4808

STEPS

The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Collections > Oracle Systems > Standard Collections



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.