E-CA: Applying DataMover Script From PUM Image Fails With Error "SQL Error. Error Position: 0 Return: 8001 - Invalid bind variable number"

(Doc ID 2308075.1)

Last updated on OCTOBER 02, 2017

Applies to:

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

Symptoms

On : 8.56 version, Change Assistant

 

When applying FSCM Update Image 25 to Demo Oracle environment - FSCM 9.2 / Image 24 / tools 8.56.02, the UPD216176390 Script errors as follows. 

 

ERROR

-----------------------

SQL Error. Error Position: 0 Return: 8001 - Invalid bind variable number

UPDATE PSACTIVITYDEFN set ACTVALID = '9' WHERE OBJECTOWNERID IN ('DWR','DSAC','DCP','CCM','MEG','MMG','MQS')

echo ........RunningDataMoverUPD26395949_01_DMS:complete........

Error: SQL execute error for UPDATE PSACTIVITYDEFN set ACTVALID = '9' WHERE OBJECTOWNERID IN ('DWR','DSAC','DCP','CCM','MEG','MMG','MQS')

echo ........RunningDataMoverUPD26395949_01_DMS:complete........

Ended: Tue Sep 12 22:48:18 2017

Unsuccessful completion

 

STEPS

-----------------------

The issue can be reproduced at will with the following steps:

1. Using FSCM Update Image 25 create change package to apply fixes to FSCM 9.2 / Image 24 / tools 8.56.02 demo environment -

2. Observe the error as reported when running the DMS UPD26395949

 

 

Changes

 

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