My Oracle Support Banner

ETL9.2: SQL Scripts to Remove Null/Orphaned Notifications for Reported Time and Absence Requests From EOW Tables (Doc ID 2851337.1)

Last updated on MAY 10, 2022

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


The Pending Approvals page for Reported Time is showing rows that either have no data on them or names and dates without hours to approve.

The reported time or absence requests has been previously approved, show 0 hours to approve, or show no data at all.

Having these items present makes using this tile extremely slow, and is making it difficult to navigate to this tile.

Steps to Reproduce the Issue:

Navigate to the Pending Approvals page for Reported Time
     A.  Navigation: On the Manager Self-Service home page, click the Approvals tile to access the Pending Approvals page.
     B.  On the left pane, you can see the Reported Time listing. 
     C.  The right pane enables you to view the Reported time entries pending approvals.




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

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