E-SEC:Adding New User Through PIA Throws Peoplecode Error (Doc ID 2157950.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

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.

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

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.


Logs and Trace:

Customer traced the SQL and found that it gives the following SQL error.

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

It looks like the PeopleCode is submitting the above insert statement, but since no value is passing for the column OPERPSWD and the column does not have a DEFAULT value, it is failing.


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


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

1. Navigate to PeopleTools - > Security -> User Profile -> Add New Value.
2. Enter the needed information, then Save. The error occurs.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
New users cannot be created due to this error.

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