AI beyond HRMS. Meet DelveAnt, our AI-native CRM for modern sales teams. Get Early Access for FREE
Found 1072 results.
AI beyond HRMS. Meet DelveAnt, our AI-native CRM for modern sales teams. Get Early Access for FREE
Discover how AI-powered HR solutions are transforming workforces – join us in London to enhance employee
experience and drive business growth. Register now!
Explore PeopleTools 8.62 updates, including Query Administration improvements and partial data masking enhancements for better security and control.
Oracle continues to improve PeopleSoft with every PeopleTools release, focusing not only on new features but also on strengthening administrative control and data security. In modern enterprise systems, managing queries efficiently and protecting sensitive data are both critical responsibilities for administrators.
PeopleTools 8.62 introduces a set of improvements that address these areas through enhancements to Query Administration and the introduction of Partial Data Masking capabilities. These updates make it easier for administrators to monitor query activity, manage performance issues, and ensure that confidential information does not get exposed through query results.
In this blog, we will take a closer look at these enhancements and understand how they help improve governance and data protection within the PeopleSoft environment.
The Query Administration component in PeopleSoft provides administrators with a centralized place to monitor and manage queries created through PeopleSoft Query Manager.
In many organizations, hundreds or even thousands of queries are created over time. Some of these queries may run frequently or may not be optimized properly, which can impact system performance. The Query Administration component helps administrators track these queries and take necessary actions when needed.
PeopleTools > Utilities > Administration > Query Administration
The Admin Page acts as the central console for managing queries within the PeopleSoft environment.
Key Functions:
• Enable / Disable queries
• Turn query logging ON/OFF
• Reassign query ownership
• Rename / Move / Delete queries
• Clear logs and statistics
The Executing Page provides visibility into queries that are currently running in the system. This page is particularly useful when administrators need to investigate performance issues caused by long-running queries.
Through this page, administrators can:
Information about executing queries is stored in the PSQRYTRANS table. When a query finishes or is terminated, PeopleTools automatically cleans up any orphaned records associated with that query.
The Settings Page allows administrators to configure system-level behavior related to query execution and monitoring.
Some of the important configuration options available on this page include:
These settings help administrators establish governance policies around how queries operate in the environment.
One of the notable security enhancements introduced in PeopleTools 8.62 is Partial Data Masking.
In many cases, query results may include sensitive information such as employee IDs, bank account numbers, or personal identifiers. Displaying this information in its entirety may pose a security risk.
Partial Data Masking addresses this concern by hiding a portion of the data while still displaying part of the value.
Example
Original Value
1234567890
Masked Value
1234******
This approach allows users to identify the record while preventing exposure of the complete sensitive information.
Configuration Steps
To enable partial data masking:
Note:
Data masking does not apply to Long Character fields or Image fields.
These enhancements provide several practical benefits for organizations using PeopleSoft:
PeopleTools 8.62 brings meaningful improvements to query administration while strengthening data privacy through the introduction of partial data masking. These enhancements give administrators greater visibility into query activity and provide better control over how queries are executed and managed.
By using these capabilities effectively, organizations can maintain better governance over their PeopleSoft queries while ensuring that sensitive data remains protected across reporting and analytics tools.
Connect with us for PeopleSoft End-to-End Implementation, Enhancement, Updates, and Support.
Read MoreThis website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
