{"id":31432,"date":"2026-01-06T08:36:34","date_gmt":"2026-01-06T08:36:34","guid":{"rendered":"http:\/\/kovaion-new1.local\/oracle-peoplesoft-setting-up-alerts-for-pending-approvals\/"},"modified":"2026-01-06T13:04:56","modified_gmt":"2026-01-06T13:04:56","slug":"oracle-peoplesoft-setting-up-alerts-for-pending-approvals","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/oracle-peoplesoft-setting-up-alerts-for-pending-approvals\/","title":{"rendered":"Oracle PeopleSoft | Setting Up Alerts for Pending Approvals"},"content":{"rendered":"

 <\/p>\n

In today\u2019s fast-paced work environment, keeping track of pending approvals can be a challenge. Often, users need to log in and navigate through multiple menus to check their approval queue. This blog post provides a proof-of-concept guide on how to set up automated alerts to notify users of pending approvals, ensuring they can stay on top of their tasks without constantly logging in to check.<\/p>\n

 <\/p>\n

Alerts and Notification in PeopleSoft:<\/strong><\/h2>\n

Alerts are proactive messages sent to users to notify them about specific events or conditions that require their attention. These can be configured to trigger based on predefined criteria or thresholds. Alerts help in maintaining workflow efficiency by ensuring that users are promptly informed about important events.<\/p>\n

Notifications are messages that inform users about specific actions or statuses. While like alerts, notifications can be more informational and less urgent. They are designed to keep users updated on the status of processes, approvals, or other relevant activities.<\/p>\n

 <\/p>\n

Steps to Set Up the Alert\/Notification:<\/strong><\/h2>\n

1. Query Security: Add EOAW Records<\/strong><\/h3>\n

To start, ensure the necessary EOAW records are available in the Query Record Search. Add EOAW_TXN<\/strong> and EOAW_SUMM_DTL<\/strong> to the Query Security.<\/p>\n

Navigation<\/strong>: Main Menu > PeopleTools > Security > Query Security > Query Access Manager<\/p>\n

    \n
  • Navigate to the Query Access Manager. Search for the Query Tree: QUERY_TREE_EO<\/strong><\/li>\n<\/ul>\n
    \"Accessing-the-Query-Tree-QUERY_TREE_EO\"
    Fig 1.1 Accessing the Query Tree: QUERY_TREE_EO<\/strong><\/figcaption><\/figure>\n

     <\/p>\n

      \n
    • Search for and add EOAW_TXN<\/strong> and EOAW_SUMM_DTL<\/strong> if they are not already present.<\/li>\n<\/ul>\n
      \"Adding-the-Child-Records-EOAW_TXN-and-EOAW_SUMM_DTL\"
      Fig 1.2 Adding the Child Records – EOAW_TXN and EOAW_SUMM_DTL<\/strong><\/figcaption><\/figure>\n

       <\/p>\n

      \"Fig
      Fig 1.21<\/strong><\/figcaption><\/figure>\n

       <\/p>\n

      2. Create the Query<\/strong><\/h3>\n

      Next, create a query using the EOAW_SUMM_DTL<\/strong> and EOAW_TXN<\/strong> records to fetch pending approvals. This query can be customized to include additional details as needed.<\/p>\n

      Navigation<\/strong>: Main Menu > Reporting Tools > Query > Query Manager<\/p>\n

        \n
      • Go to the Query Manager and Create a new query using the specified records.<\/li>\n<\/ul>\n
        \"Fig-1.3-Create-a-new-query-joining-the-records-EOAW_SUMM_DTL-and-EOAW_TXN\"
        Fig 1.3: Create a new query joining the records EOAW_SUMM_DTL and EOAW_TXN<\/strong><\/figcaption><\/figure>\n

         <\/p>\n

        \"Fig
        Fig 1.31<\/strong><\/figcaption><\/figure>\n

         <\/p>\n

        \"Fig
        Fig 1.32<\/strong><\/figcaption><\/figure>\n

         <\/p>\n

          \n
        • Customize the SQL to fit your business requirements.<\/li>\n<\/ul>\n
          \"Fig-1.4-Selecting-the-Fields-from-the-Records\"
          Fig 1.4 Selecting the Fields from the Records<\/strong><\/figcaption><\/figure>\n

           <\/p>\n

          \"Fig-1.5-Customize-the-Thread-ID-to-display-the-Number-of-Pending-Approvals.\"
          Fig 1.5 Customize the Thread ID to display the Number of Pending Approvals<\/strong><\/figcaption><\/figure>\n

           <\/p>\n

          \"Fig
          Fig 1.6 Setting the Criteria – to fetch pending approvals<\/strong><\/figcaption><\/figure>\n

           <\/p>\n

          \"Fig
          Fig 1.7 Viewing the Query for Fetching Pending Approvals for the User<\/strong><\/figcaption><\/figure>\n

           <\/p>\n

          3. Create Message Catalog Entry<\/strong><\/h3>\n

          Create an entry in the Message Catalog for the query. This entry will be used to format the alert message.<\/p>\n

          Navigation<\/strong>: Main Menu > PeopleTools > Utilities > Administration > Message Catalog<\/p>\n

            \n
          • Navigate to the Message Catalog. Add a new entry with your desired messages, input binds, and message set\/number.<\/li>\n<\/ul>\n
            \"Fig
            Fig 1.8 Creating the Message Information for Alert Notification Mail<\/strong><\/figcaption><\/figure>\n

             <\/p>\n

            4. Create the Alert Definition<\/strong><\/h3>\n

            Now, create an alert based on the query you created. This alert will notify users of pending approvals.<\/p>\n

            Navigation<\/strong>: Main Menu > Enterprise Components > Events & Notifications > Alerts > Alert Definition<\/p>\n

              \n
            • Navigate to Alert Definition and Create a new alert using the query.<\/li>\n<\/ul>\n
              \"Fig
              Fig 1.9 Creating the Alert for Pending Approvals<\/strong><\/figcaption><\/figure>\n

               <\/p>\n

                \n
              • Define the alert details as per your requirements.<\/li>\n<\/ul>\n
                \"Fig
                Fig 1.10 Setting up the Mail Recipient<\/strong><\/figcaption><\/figure>\n

                 <\/p>\n

                \"Fig
                Fig 1.11 Setting up the Message Catalog Created for the Mail Content and provide Transaction URL (Component Details)<\/strong><\/figcaption><\/figure>\n

                 <\/p>\n

                5. Run the Alerts<\/strong><\/h3>\n

                Finally, schedule and run the alerts as needed. You can set the process to run at specific times, such as daily, to ensure users receive timely notifications.<\/p>\n

                Navigation<\/strong>: Main Menu > Enterprise Components > Events & Notifications > Alerts > Run Alerts<\/p>\n

                  \n
                • Navigate to Run Alerts and enter the Alert Query details to run the Process<\/li>\n<\/ul>\n
                  \"Fig
                  Fig 1.12 Setting up the Details to Run the Alert<\/strong><\/figcaption><\/figure>\n

                   <\/p>\n

                    \n
                  • Set up the process to run on a recurrence, such as daily or at a specific time.<\/li>\n<\/ul>\n

                    Navigation<\/strong>: Main Menu > PeopleTools > Process Scheduler > Process Scheduler Recurrences<\/p>\n

                    \"Fig
                    Fig 1.13 Creating Recurrence for the Alert Process<\/strong><\/figcaption><\/figure>\n

                     <\/p>\n

                    6. Receiving Alerts<\/strong><\/h3>\n

                    With everything set up, users will receive alerts for pending approvals directly in their notifications. This allows them to prioritize their tasks without the need to log in and check their approval queue constantly.<\/p>\n

                    \"Fig
                    Fig 1.14 Alerts Received in Mail for Pending Approvals<\/strong><\/figcaption><\/figure>\n

                     <\/p>\n

                    \"Fig
                    Fig 1.15 Pending Approvals on the Approval Tile in MSS<\/strong><\/figcaption><\/figure>\n

                     <\/p>\n

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

                    By following these steps, we can create a system that automatically notifies users of pending approvals, helping them stay organized and efficient. This proof-of-concept guide provides a foundational approach that can be tailored to meet our specific business needs and security requirements. Stay ahead of the tasks and ensure no approval is missed with these automated alerts.<\/p>\n

                    Author:<\/strong> Nandhini Devi Raman, Oracle PeopleSoft Consultant<\/p>\n","protected":false},"excerpt":{"rendered":"

                      In today\u2019s fast-paced work environment, keeping track of pending approvals can be a challenge. Often, users need to log in and navigate through multiple menus to check their approval queue. This blog post provides a proof-of-concept guide on how to set up automated alerts to notify users of pending approvals, ensuring they can stay […]<\/p>\n","protected":false},"author":1,"featured_media":24082,"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-31432","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\/31432","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=31432"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31432\/revisions"}],"predecessor-version":[{"id":31433,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/31432\/revisions\/31433"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/24082"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=31432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=31432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=31432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}