My Oracle Support Banner

Reported Time Approvals error when updated to Image 33 "SQL error. Function: Rowset.Fill - ORA-00942: table or view does not exist (PS_EOAW_EOPCPB0_WK) " (Doc ID 2677331.1)

Last updated on JUNE 04, 2020

Applies to:

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

Symptoms

Getting SQL error for Reported Time Approvals in Approvals Tile after updating HR 9.2 Demo environment from image 24 to Image 33 with only Time and Labor product.
 

ERROR
-----------------------
SQL error. Function: Rowset.Fill
Error Position: 349
Return: 942 - ORA-00942: table or view does not exist
Statement: select fill.eopcobj_button_l0,fill.eopcobj_button_l0a,fill.eopcobj_button_l0b,fill.eopcobj_button_l0c,fill.eopcobj_button_l0d,fill.eopcobj_link_l0,fill.eopcobj_link_l0a,fill.eopcobj_link_l0b,fill.eopcobj_link_l0c,fill.eopcobj_link_l0d,fill.eopcobj_tapb_l0,fill.eopcobj_tapb_l0a,fill.eopcobj_tapb_l0b,fill.eopcobj_tapb_l0c,fill.eopcobj_tapb_l0d from PS_EOAW_EOPCPB0_WK FILL




The issue can be reproduced at will with the following steps:
Manager Self Service Dashboard > Click on Approvals Tile >Click on Reported Time > SQL Error



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.