ETL9.2:Create Views Failing During Database Setup Process (PeopleSoft DEMO Build) (Doc ID 2252494.1)

Last updated on APRIL 12, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Goal

On : 9.2 version, PUM 16,HCM - Create Views failing during Database setup process (PeopleSoft DEMO Build)


Issue:
During the database setup process (running this setup via data mover) it failed with ACA view errors:

Creating View ACA_MONTH
 - SQL Error. Error Position: 1132 Return: 942 - ORA-00942: table or view does not exist
 

Creating View ACA_WEEK
 - SQL Error. Error Position: 1114 Return: 942 - ORA-00942: table or view does not exist
 
Creating View ACA_AVG_MTH_VW
 - SQL Error. Error Position: 871 Return: 942 - ORA-00942: table or view does not exist

Creating View ACA_AVG_WK_VW
 - SQL Error. Error Position: 862 Return: 942 - ORA-00942: table or view does not exist

After reviewing further we have found that we are missing :
PS_ACA_BGN_WK_TBL,
PS_ACA_BGN_MTH_TBL
 
Question: Please let us know what script contain create table for above two tables, why DEMO it self failing, this is PeopleSoft Delivered DEMO base install?
 

Solution

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