E-INST: PeopleTools Patch Installation Fails With Error Invalid Column Name 'PTSF_SRCH_ENG_INS'.

(Doc ID 2190072.1)

Last updated on NOVEMBER 04, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, Updates and Fixes

When trying to apply tools patch 8.55.10 database.we are getting below error while executing patch855tls.dms script.

ERROR
-----------------------
"File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]
Invalid column name 'PTSF_SRCH_ENG_INS'.
Failed SQL stmt: UPDATE PS_PTSF_DEPLY_PRMS SET PTSF_SRCH_ENG_INS = 'PTSF_DEFAULT' WHERE PTSF_SRCH_ENG_INS = ' "


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply the PT 8.55.10 patch.
2. Run patch855tls.dms script.


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