My Oracle Support Banner

Getting an Ora-6502 Pl/Sql 'numeric or Value Error' in the Service Contract Order Processing Program After Applying Patch 30431361 (Doc ID 2613827.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Service Contracts - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Warr/Ext.Warranty Integration

When attempting to run the Service Contract Order Processing Program having Service items, the following error occurs.

ERROR
-----------------------
Request ID : 120539201; OKC_CONTRACTS_UNEXP_ERROR (SQLcode=-6502)
(SQLerrm=ORA-06502: PL/SQL: numeric or value error: character to number conversion error);


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Add-on Order containing both a Subscription Line and a Service Line
2. Run the Reprocess Order program for just this order successfully processed the Subscription line but resulted in an error for the Service Line
   The error appears.

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.