My Oracle Support Banner

In 9.2 Upgrade Task 2-3-2: Completing Human Capital Resources Approvals, the Query UPG_SS_APPROVAL is Missing (Doc ID 2141369.1)

Last updated on NOVEMBER 26, 2021

Applies to:

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


When trying to complete pending approval transactions in a PeopleSoft HCM 9.1 to 9.2 through Update Image 16 upgrade, the query UPG_SS_APPROVAL is not found on the target database.

The query should be present and available for use in the target application.

The issue can be reproduced at will with the following steps:
1. Complete upgrade steps up to Task 2-3-2
2. On the target database, navigate to Reporting Tools > Query > Query Manager
3. Attempt to run UPG_SS_APPROVAL
4. Query is not found in the target database


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.