Last updated on APRIL 19, 2017
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.
App: HCM 9.2.08
DB: Microsoft SQL Server
OS: MS Windows 2008r2
Applied PRP 21426995 successfully to HR92U014 (HCM 9.2. image #14). Successfully created the PRJ21426995 project.
Step: Running Data Mover Import UPD21426995_01_IMP_DMS failed with the following error:
SQL Error. Error Position: 0 Return: 601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'PSPGCALCOPT'.
DELETE from PSPGCALCOPT WHERE PTPG_PGRIDNAME IN ('ACA_FULL_PART_TIME','ACA_HIRE_REHIRE','ACA_MONTHLY_RPT','ACA_WEEKLY_RPT')
Error: SQL execute error for DELETE from PSPGCALCOPT WHERE PTPG_PGRIDNAME IN ('ACA_FULL_PART_TIME','ACA_HIRE_REHIRE','ACA_MONTHLY_RPT','ACA_WEEKLY_RPT')
Ended: Tue Nov 17 09:40:03 2015
It looks like the tables from the remaining DELETE statements in the script are not in 8.53 PeopleTools.
Can you check and verify that these are PeopleTools 8.54 tables and not 8.53 tables.
If they are just 8.54, then the script will need to be modified for customers on 8.53.
User needs confirmation on how to proceed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms