My Oracle Support Banner

The Reprocess Order Form Shows No Errors but the Service Contract is Not Created (Doc ID 2574571.1)

Last updated on JANUARY 28, 2022

Applies to:

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

Symptoms

When attempting to process Sales Order lines, the Service Contracts Order Processing Program fails to create the Extended Warranty contract Line in the Service Contract. When Reprocessing the Order, the Reprocess Order form does not show any errors but the Service Contracts Order Processing Program logs display the following errors.
 
Oracle Error Message is -ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The issue can be reproduced at will with the following steps:
1) Run the Concurrent Program - Service Contracts Order Processing Program
2) Reprocess the Order for the Order Line which failed to create the Extended Warranty and the Order Processing program fails with ORA error

Due to this issue, users cannot create the Extended Warranty contract for the Order Lines.

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.