My Oracle Support Banner

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

Last updated on OCTOBER 02, 2018

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.