Self-service name change -missing record PS_PERSON_PRINAME (Doc ID 2280978.1)

Last updated on AUGUST 16, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Issue upgrading. Missing record: PS_PERSON_PRINAME

Replication:  Self Service > Personal Information > Name Change


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

A fatal PeopleCode SQL error occurred.

SQL error in Exec. (2,280) HR_EE_NAME.Activate PCPC:767 Statement:17 

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


Return: 601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'PS_PERSON_PRINAME'.

  Statement: SELECT COUNT(*) FROM PS_PERSON_PRINAME WHERE EMPLID = :1 AND SS_STAT_INDICATOR IN ('M', 'I')

  Original Statement: Select count(*) from PS_PERSON_PRINAME where EMPLID = :1 and SS_STAT_INDICATOR IN ('M', 'I')

PSAPPSRV.6724 (673) 1-1737 08.23.07 0.002000 Cur#0.6724.HCDMO92 RC=0 Dur=0.001000 Destroy Connection Handle=0000000001B1AD58


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