My Oracle Support Banner

Renewing a Contract over 400 lines Error: " Invalid value for the column chr_id" (Doc ID 1909629.1)

Last updated on FEBRUARY 25, 2022

Applies to:

Oracle Service Contracts - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.3 version, Service contract Renewals

When attempting to renew a couple of contracts with over 400 lines, the following error occurs:

ERROR
-----------------------
Invalid value for the column chr_id. (COL_NAME=cle_id)
Program Error: Contract - XXXX could not be renewed. Contact your support representative.


STEPS
-----------------------
The issue can be reproduced at will with the following steps

1. Using Service Contract Manager responsibility

2. Query certain contract over 400 lines

3. Right click renew

4. Enter Duration for 1 year

5. Click on Renew and then the error is displayed

Same error when submitting through the concurrent process.

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.