Pension Estimates Error: COM Stmt=INSERT INTO PS_PA_I_SALARY_VW(EMPLID,ANNUAL_RT) VALUES(:1,:2)
(Doc ID 2652162.1)
Last updated on MARCH 24, 2020
Applies to:
PeopleSoft Enterprise HCM Pension Administration - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When Calculating Pension Estimates, the following SQL error occurs when a person has zero in PS_JOB.ANNUAL_RT.
ERROR
-----------------------
COM Stmt=INSERT INTO PS_PA_I_SALARY_VW(EMPLID,ANNUAL_RT) VALUES(:1,:2)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Job Data - Compensation Page (Navigation: Workforce Administration> Job Information> Job Data> Compensation Page
2. Verify that the Annual Rate field is blank
3. Navigate to Pension Estimates Page (Navigation: Self Service > Benefits > Benefits Information > Pension Estimates)
4. Calculate Pension
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 |
| Cause |
| Solution |
| References |