My Oracle Support Banner

Invalid Value For The Column Jtot_object1_code When Attempting To Renew Contract (Doc ID 297470.1)

Last updated on JULY 14, 2020

Applies to:

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

Symptoms

When attempting to manually renew a contract by selecting Renew from the popup menu user receives the following errors:

Invalid value for this column JTOT_OBJECT1_CODE (1/2)

Program Error: An unexpected error was encountered.
Error code - &ERROR_CODE
Error message - &ERROR_MESSAGE
Action: Please contact your system administrator.
(SQLcode=100)(SQLerrm=ORA-01403: no data found) (2/2)

When renewing using the "Renew a single Contract" concurrent program these errors also appear in the log file:

+---------------------------------------------------------------------------+
Oracle Contracts Core: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
OKCNRENS module: Renew a single Contract
+---------------------------------------------------------------------------+
Current system time is 01-FEB-2005 11:05:59
+---------------------------------------------------------------------------+
**Starts**01-FEB-2005 11:05:59
**Ends**01-FEB-2005 11:06:00
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program Error: Contract - XXXX could not be renewed. Please contact your
support representative.
Invalid value for the column JTOT_OBJECT1_CODE.
Program Error: An unexpected error was encountered.
Error code - &ERROR_CODE
Error message - &ERROR_MESSAGE
Action: Please contact your system administrator. (SQLcode=100)
(SQLerrm=ORA-01403: no data found)
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 01-FEB-2005 11:06:01
+---------------------------------------------------------------------------+

There is no additional information to indicate which value is invalid and what data is not found.

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!


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