My Oracle Support Banner

Extended Warranties Are Not Created After The Service Contracts Order Processing Program Is Executed (Doc ID 3023636.1)

Last updated on MAY 21, 2024

Applies to:

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

Symptoms


When attempting to run the Service contracts Order Processing Program, the contracts are not
created and the program logs show following errors:


Oracle Error Code is --6502
Oracle Error Message is -ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Oracle Error Code is --6511
Oracle Error Message is -ORA-06511: PL/SQL: cursor already open

The issue can be reproduced at will with the following steps:


1. Order Management (R)
2. Create the Sales Order and process the same
3. Book the Order and run the Workflow Background Process
4. Run the Service Contracts Order Processing Program
5. Program logs show errors and contract is not created


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.