My Oracle Support Banner

EEX9.2: Upgrading From 9.0 To 9.2 - Cannot Find Queries UPG_EXZ01 And UPG_EXZ02 (Doc ID 2704575.1)

Last updated on OCTOBER 18, 2021

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Upgrading from FSCM 9.0 to FSCM 9.2 (PUM36). On the certified path (to PUM 11) there are some manual steps that need to be performed on the production copy environment.
Unable to find the UPG_ queries. The queries are not available in the query manager or in Query Administration.

Are these queries supposed to be included in the upgrade or can they be ignored?

This Task 2-15-1: Running the Pre-Upgrade Expenses Queries
In this step, you run the PeopleSoft Expenses pre-upgrade queries.
To run the re-upgrade queries:
1. Select Reporting Tools, Query, Query Viewer.
2. Run the following queries:
• UPG_EXZ01, Business Unit Acctg Display
• UPG_EXZ02, Expense Acctg Display by Role


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.