E-SEC:Password controls cause PeopleCode error when creating new user profile in PT8.55 (Doc ID 2121831.1)

Last updated on JULY 26, 2017

Applies to:

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

Symptoms

On : People Tools: 8.55.02, Application : HCM 9.2 PUM 16, Database : Oracle Database 12.1.0.2

Tried to add a new user by following the below navigation:
PeopleTools - > Security -> User Profile -> Add New Value

On saving the page it gives the following error.

ERROR
-----------------------
SQL error in Exec. (2,280) FUNCLIB_PTSEC.OPRID.FieldFormula Name:Password_History PCPC:8903 Statement:119
Called from:PSOPRDEFN.PTOPERPSWDV2.SavePreChange Statement:19


Logs and Trace:

PSAPPSRV.6175 (6) 1-120513 09.20.18 0.002212 SQL error. Function: SQLExec^M
Error Position: 0^M
Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PSPSWDHISTORY"."OPERPSWD") ^M
Statement: INSERT INTO PSPSWDHISTORY (OPRID, PTOPERPSWDV2, OPERPSWDSALT, PSWDSAVEDATE) VALUES (:1, :2, :3, TO_TIMESTAMP(:4,'YYYY-MM-DD-HH24.MI.SS.FF'))^M
Original Statement: insert into PSPSWDHISTORY (OPRID, PTOPERPSWDV2, OPERPSWDSALT, PSWDSAVEDATE) values (:1, :2, :3, %datetimein(:4))
PSAPPSRV.6175 (6) 1-120514 09.20.18 0.012347 Cur#1.6175.DASC1J RC=0 Dur=0.000610 Fetch
PSAPPSRV.6175 (6) 1-120515 09.20.18 0.000724 Cur#1.6175.DASC1J RC=0 Dur=0.000001 Fetch


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

1. Enable password controls (for example)
8 minimum length
1 digit
3 passwords to retain
signon PeopleCode enabled
expires in 30 days without warning
5 failed logins locks account

2. Navigate to PeopleTools - > Security -> User Profile -> Add New Value
a. Enter UserID
b. Select Symbolic ID
c. Enter new password
d. Confirm new password
e. Select ID tab
f. Select ID Type as None
g. Save

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