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.
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
Million Knowledge Articles and hundreds of Community platforms