Self-service name change -missing record PS_PERSON_PRINAME
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.
Issue upgrading. Missing record: PS_PERSON_PRINAME
Replication: Self Service > Personal Information > Name Change
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
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