HCM ACA_MERGE_MSG record is missing from HCM 9.1 Bundle#21 (Doc ID 2110123.1)

Last updated on MARCH 13, 2016

Applies to:

PeopleSoft Enterprise HCM eBenefits - Version 9.1 to 9.1 [Release 9.0]
Information in this document applies to any platform.

Symptoms

Customers are getting the error below while applying Bundle 21:

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)

SQL Error. Error Position: 188 Return: 942 - ORA-00942: table or view does not exist

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