SQL Queries for Troubleshooting Issues on Security, Component Structure, Pages, etc.
(Doc ID 968656.1)
Last updated on MARCH 08, 2018
PeopleSoft Enterprise FIN Receivables - Version 8.9 and later PeopleSoft Enterprise SCM Inventory - Version 8.9 and later PeopleSoft Enterprise EPM Planning & Budgeting - Version 8.9 and later PeopleSoft Enterprise CRM Online Marketing - Version 8.9 and later PeopleSoft Enterprise HCM Human Resources - Version 8.9 and later Information in this document applies to any platform.
This document gives SQL queries with PeopleTools tables that are useful while troubleshooting issues with security, component structure and pages, etc. This document also includes a list of commonly used PeopleTools tables in the PeopleSoft system. It can be used for any module in PeopleSoft system, as most of the PeopleTools tables and SQL scripts given in this document are generic.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!