In 9.2 Upgrade Task 2-3-2: Completing Human Capital Resources Approvals, the Query UPG_SS_APPROVAL is Missing
Last updated on MAY 27, 2016
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
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