{"id":33597,"date":"2026-04-16T09:47:30","date_gmt":"2026-04-16T09:47:30","guid":{"rendered":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/?p=33597"},"modified":"2026-04-30T09:54:26","modified_gmt":"2026-04-30T09:54:26","slug":"peopletools-8-62-query-administration-and-partial-data-masking","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/blog\/peopletools-8-62-query-administration-and-partial-data-masking\/","title":{"rendered":"PeopleTools 8.62 \u2013 Query Administration and Partial Data Masking Enhancements"},"content":{"rendered":"\n

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. <\/p>\n\n\n\n

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. <\/p>\n\n\n\n

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. <\/p>\n\n\n\n

1. Query Administration Enhancements<\/strong> <\/h2>\n\n\n\n

The Query Administration component in PeopleSoft provides administrators with a centralized place to monitor and manage queries created through PeopleSoft Query Manager. <\/p>\n\n\n\n

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. <\/p>\n\n\n\n

Navigation<\/strong> <\/h3>\n\n\n\n

PeopleTools > Utilities > Administration > Query Administration<\/strong> <\/p>\n\n\n\n

Admin Page<\/strong> <\/h3>\n\n\n\n

The Admin Page acts as the central console for managing queries within the PeopleSoft environment. <\/p>\n\n\n\n

Key Functions:
\u2022 Enable \/ Disable queries
\u2022 Turn query logging ON\/OFF
\u2022 Reassign query ownership
\u2022 Rename \/ Move \/ Delete queries
\u2022 Clear logs and statistics <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Executing Page<\/strong> <\/h3>\n\n\n\n

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. <\/p>\n\n\n\n

Through this page, administrators can: <\/p>\n\n\n\n

    \n
  • View active queries along with details such as\u00a0user ID, application server domain, and runtime<\/li>\n\n\n\n
  • Identify\u00a0queries that have been running for an unusually long time\u00a0<\/li>\n\n\n\n
  • Terminate queries that may be\u00a0impacting\u00a0system performance\u00a0<\/li>\n\n\n\n
  • Enable or disable query logging when\u00a0required\u00a0<\/li>\n<\/ul>\n\n\n\n

    Technical Note<\/strong> <\/h3>\n\n\n\n

    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.

    \"\"<\/p>\n\n\n\n

    Settings Page<\/strong> <\/h3>\n\n\n\n

    The Settings Page allows administrators to configure system-level behavior related to query execution and monitoring. <\/p>\n\n\n\n

    Some of the important configuration options available on this page include: <\/p>\n\n\n\n

      \n
    • Enable Query Timeout<\/strong>\u00a0\u2013 Automatically\u00a0terminate\u00a0queries that exceed the defined execution time\u00a0<\/li>\n\n\n\n
    • Run Query Statistics<\/strong>\u00a0\u2013 Collect performance statistics for queries\u00a0<\/li>\n\n\n\n
    • Query Data Masking<\/strong>\u00a0\u2013 Enable masking of sensitive data in query results\u00a0<\/li>\n\n\n\n
    • Query Column Mask<\/strong>\u00a0\u2013 Configure masking rules for specific columns\u00a0<\/li>\n<\/ul>\n\n\n\n

      These settings help administrators establish governance policies around how queries operate in the environment. <\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      2. Partial Data Masking<\/strong> <\/h2>\n\n\n\n

      One of the notable security enhancements introduced in PeopleTools 8.62 is Partial Data Masking. <\/p>\n\n\n\n

      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. <\/p>\n\n\n\n

      Partial Data Masking addresses this concern by hiding a portion of the data while still displaying part of the value. <\/p>\n\n\n\n

      Example<\/strong> <\/p>\n\n\n\n

      Original Value
      1234567890<\/strong> <\/p>\n\n\n\n

      Masked Value
      1234<\/strong>****** <\/p>\n\n\n\n

      This approach allows users to identify the record while preventing exposure of the complete sensitive information. <\/p>\n\n\n\n

      Configuration Steps<\/strong> <\/p>\n\n\n\n

      To enable partial data masking: <\/p>\n\n\n\n

        \n
      1. Navigate to\u00a0Query Administration > Settings<\/li>\n\n\n\n
      2. Enable\u00a0Query Data Masking<\/li>\n\n\n\n
      3. Specify the\u00a0Masking Character\u00a0(for example\u00a0*)\u00a0<\/li>\n\n\n\n
      4. Define the\u00a0number of characters that should remain visible\u00a0<\/li>\n<\/ol>\n\n\n\n

        Note:<\/strong>
        Data masking does not apply to Long Character fields or Image fields. <\/p>\n\n\n\n

        Business Benefits<\/strong> <\/h2>\n\n\n\n

        These enhancements provide several practical benefits for organizations using PeopleSoft: <\/p>\n\n\n\n

          \n
        • Improved Data Security<\/strong>
          Sensitive information in query results can be protected from unnecessary exposure.\u00a0<\/li>\n\n\n\n
        • Simplified Query Administration<\/strong>
          Administrators can manage queries centrally and monitor activity more efficiently.\u00a0<\/li>\n\n\n\n
        • Regulatory Compliance Support<\/strong>
          Data masking helps organizations align with privacy and compliance requirements.\u00a0<\/li>\n\n\n\n
        • Better Governance and Monitoring<\/strong>
          Query logs and statistics provide better visibility into system usage.\u00a0<\/li>\n<\/ul>\n\n\n\n

          Conclusion<\/strong> <\/h2>\n\n\n\n

          PeopleTools8.62brings 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. <\/p>\n\n\n\n

          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. <\/p>\n","protected":false},"excerpt":{"rendered":"

          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 […]<\/p>\n","protected":false},"author":1,"featured_media":33598,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[17],"tags":[],"class_list":["post-33597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-peoplesoft"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/33597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/comments?post=33597"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/33597\/revisions"}],"predecessor-version":[{"id":33599,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/33597\/revisions\/33599"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/33598"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=33597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=33597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=33597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}