Planning Engine Start Fails With Error ORA-01455: Converting Column Overflows Integer Datatype
Last updated on JANUARY 13, 2018
Applies to:PeopleSoft Enterprise SCM Supply Planning - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.
The planning engine PLI_PC_OM_KITS got shut down on production environment after a user made an update on a planned purchased.
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.
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