My Oracle Support Banner

E-SEC: Error When Running ENCRYPT_PASSWORD in DataMover "Number Of Columns In SELECT And INSERT Do Not Match PS_SQLSTMT_TBL" (Doc ID 2950795.1)

Last updated on MAY 25, 2023

Applies to:

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

Symptoms

When attempting to encrypt password for custom userid 'PSCOPY',
the following error occurs.



ERROR
-----------------------

SQL Successful - UPDATE psoprdefn set PTOPERPSWDV2= '********' , operpswdsalt=' ' , encrypted = 0 , lastupdoprid = 'myid', lastupddttm = sysdate where oprid = 'PSCOPY'
Number of columns in SELECT and INSERT do not match PS_SQLSTMT_TBL
Ended: Tue Feb 21 16:24:58 2023
Unsuccessful completion

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.