ACA Patch Error: Data MoverSQL error. Stmt #: 0 Error Position: 188 Return: 942 - ORA-00942: table or view does not exist

(Doc ID 2114934.1)

Last updated on AUGUST 21, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When running create views, Ci errors and informs that this table PS_ACA_MERGE_MSG doesn't exists.
the following error occurs.

ERROR
-----------------------
The following fail when applying Patch 2233853 bundle #21.

SQL Successful - CREATE VIEW PS_ACA_DEPND_BENEF (EMPLID, DEPENDENT_BENEF, NAME) AS SELECT EMPLID ,DEPENDENT_BENEF ,NAME FROM PS_DEPENDENT_BENEF UNION SELECT EMPLID ,'00' ,NAME FROM PS_PERSON_NAME

Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 188 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt:CREATE VIEW PS_ACA_MRG_DTA_VW (ACA_DAT_EXTRACT_ID, ACA_ALE_MEMBER, ACA_CALENDAR_YEAR, EMPLID) AS SELECT DISTINCT M.ACA_DAT_EXTRACT_ID ,M.ACA_ALE_MEMBER ,M.ACA_CALENDAR_YEAR ,M.EMPLID FROM PS_ACA_MERGE_MSG M WHERE M.EMPLID NOT IN( SELECT X.EMPLID FROM PS_ACA_MERGE_MSG X WHERE X.MESSAGE_SET_NBR = 3004 AND X.MESSAGE_NBR IN (208,212,213)) (200,0)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Apply Patch 2233853, bundle #21.

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