Planning Engine Start Fails With Error ORA-01455: Converting Column Overflows Integer Datatype (Doc ID 2291087.1)

Last updated on JULY 27, 2017

Applies to:

PeopleSoft Enterprise SCM Supply Planning - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The planning engine PLI_PC_OM_KITS got shut down on production environment after a user made an update on a planned purchased.
 

ERROR
-----------------------
Planning Engine Start Fails With Error ORA-01455: converting column overflows integer datatype

The analytic server log file contains an error message related to PSOPTSYNC record :

PSANALYTICSRV.26477 (1) [2016-10-11T07:57:06.586 6908147F@10.136.182.6 ProbInst6](3) File: /vob/peopletools/src/psstatecore/optdatacache.cppSQL error. Stmt #: 425 Error Position: 0 Return: 1455 - ORA-01455: converting column overflows integer datatype
Failed SQL stmt: SELECT PROBINST, RECNAME, VERSION FROM PSOPTSYNC WHERE PROBINST='PLI_PC_OM_KITS' OR PROBINST='$ALL$'


The issue can be reproduced at will with the following steps:
1. Supply Planning > Create Plan > Load Planning Instance, the planning engine PLI_PC_OM_KITS doesn’t start.



Cause

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 hundreds of Community platforms