ETL9.2: HCM ACA Applying Patch 21426995 To DEMO (Doc ID 2079453.1)

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.

Symptoms

Environment:
Tools: 8.53.14
App: HCM 9.2.08
DB: Microsoft SQL Server
OS: MS Windows 2008r2

Issue:

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:

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
Unsuccessful completion


It looks like the tables from the remaining DELETE statements in the script are not in 8.53 PeopleTools.

PSPGAXIS
PSPGNUIOPT
PSPGAXISPERS
PSPGAXISPERSLNG
PSPGVIEWOPTPERS
PSPGVWOPTPERLN
PSPGCHARTOPTPER
PSPGCHTOPTPERLN
PSPGQRYPRMPTPER
PSPGQRYPRMPTPLN
PSPGGRIDOPTPERS

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.

Business Impact:
User needs confirmation on how to proceed.

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