PeopleSoft Workflow Implementation Using AWE for Coppin State University

PeopleSoft Workflow Implementation Using AWE for Coppin State University

Requirements

Coppin State uses customized PeopleSoft Requisition workflow for Requisition authorization at the University. PeopleSoft 9.2 delivers Approval Framework which can be leveraged along with new enhancements to replace the custom workflow authorizations.

The existing custom Requisition approval workflow was designed in PeopleSoft 84 version and has since been used without an upgrade to the solution. PeopleSoft 9.2 Approval Framework delivers features and enhancements which fulfil the gaps in the current custom version of the approval workflow.

Current State

>In the current approval workflow PeopleSoft 8.4 approval configuration was implemented using the Business Objects and virtual approval functionality. Customer uses three levels of approval:

  • >Level 1 Approval – Cost Center Manager
  • Level 2 Approval – IT Approval
  • Level 3 Approval – Title III Fund Administrator
Issues to be Addressed

Currently the customer faces some issues, which are not addressed by the existing approval workflow:

  • In a scenario where an approver is the same for all three levels, the approver has to approve the requisition transaction each time (three times in this case)
  • Notifications are not sent to the Approvers or Requesters when a requisition is submitted for approval or finally approved/denied
  • If there is an error in the approval workflow, the worklist transaction disappears without any trace and there is no notification to either the requester or the workflow administrator.

Final Requirements -Customer is interested in implementing the PeopleSoft 9.2 delivered Approval Framework for Requisition Approvals. This implementation will replace their existing custom Requisition Approval Workflow.

Some of the customer specific requirements are listed below:

  • Disable Pushback functionality
  • Rename the “Deny” button label to “Review” on the Approval pages
  • Add a notification email to the Procurement Department on their Distribution List - Procurement @customer.com
  • The requester should have access to “Multiple Approvers” panel to see who all have the request pending with
  • Worklist Link should be renamed to contain Requisition ID only
  • Users should not have access to the “Start New Path” Under the Approvals page
  • Approval workflow should route the same way as current functionality:
    • Level 1 – Triggered Always – Department Managers or Project Admins
    • Level 2 – Triggered with an OIT Account
    • Level 3 – Triggered with a Title 3 Project
shape2

Solution Details

PeopleSoft 9.2 Approval Framework is enabled at Coppin State University by disabling the Virtual Approval Framework for Requisition Approvals.

The approval setup is configured in the application as well as some features have been customized based on customer requirements using PeopleCode.

    1. Activate Approval Framework

    The first step in configuring the Requisition Approval Workflow is to disable Virtual Approval.

    Activate Purchasing requisition workflow approval framework as below:

    • Open the Purchasing Definition and go to “Req Change Options” tab
    • Select the “Workflow Approval Required” Checkbox which will prompt you with a message to continue with disabling virtual approval, click “Yes”
    2.Configure Transaction Registry

    Review and update the Transaction Registry setup as shows in the snapshots below:

    Navigate: Main Menu Enterprise Components Approvals Approvals Transaction Registry

    Configure Transaction Registry

    Review and update the Transaction Registry setup as shown below (continued):

    Configure Transaction Registry
    3. Transaction Configuration Setup

    The Transaction Configuration setup is done manually. Below are the snapshots to review the setup after successful migration.

    Navigate: Main Menu > Enterprise Components > Approvals > Approvals > Transaction Configuration

    Transaction Configuration Setup

    One of the Events is changed to add an Email ID once the Requisition is finally approved. This has been added as a User List (CSU_WF_Procurement) which uses a SQL Object defined in the Application Designer Project.

    Transaction Configuration Setup
    4. Approval Process Setup

    The Approval Process Setup screenshots on how the setup should look like after completing the configuration.

    Approval Process Setup Approval Process Setup Approval Process Setup

    Step 1:Approval Process Setup

    Approval Process Setup Approval Process Setup Approval Process Setup Approval Process Setup Approval Process Setup Approval Process Setup

    Step 2:

    Approval Process Setup Approval Process Setup Approval Process Setup Approval Process Setup

    Step 3:

    Approval Process Setup Approval Process Setup Approval Process Setup Approval Process Setup Approval Process Setup Approval Process Setup Approval Process Setup

    4. Configure URL Definition

    To generate a URL in the email notifications to take approvers directly to the Requisition Approval/Denial page, URL definition is modified as shown below.

    Please note that this definition changes based on environments. For example, the URL shown below is for TST environment and will be different for UAT or Production environments.

    5. Integration Broker Setup

    Please review the Integration Broker Setup as shown below:

    NODES

    Navigate: Main Menu PeopleTools Integration Broker Integration Setup Nodes

    1. Open Node “PSFT_EMC_GETMAIL” and Make sure the Node is Active

    Integration Broker Setup

    Under Connectors tab, make sure the highlighted properties are updated

    Integration Broker Setup

    Under Node Definitions tab, the properties should have the Property – EMC_REPOSITORY_EMAILADDRESS updated to “ps_email@customer.edu”

    QUEUES

    Navigate: Main Menu PeopleTools Integration Broker Integration Setup Queues

    1. Open Queue “EOAW_APPROVALS”

    2. Change the “Queue Status” from Pause to Run

    3. Click on Save

    Integration Broker Setup

    Click on the EOAW_APPROVALS Service Operation

    IIntegration Broker Setup

    Under General Tab, make sure the Service Operation is “Active”

    Integration Broker Setup

    Under the Handlers tab, make sure the Handler is “Active”

    Integration Broker Setup

    6. Setup User Lists

    Following User Lists were created to fetch the appropriate approval routings and Email notification routing. All the User lists use SQL Definitions which will be migrated through the Application Designer Project.

    1. CU_WF_Procurement –Created for routing final requisition approval email notification to the Procurement Department Distribution List
    2. CU_WF_LEVEL1 – This user lists identifies the appropriate candidates for Level 1 of Approval Cycle: Department and Project Admins
    3. CU_WF_LEVEL2 – This user lists identifies the appropriate candidates for Level 2 of Approval Cycle: OIT Managers
    4. CU_WF_LEVEL3 – This user lists identifies the appropriate candidates for Level 3 of Approval Cycle: Title 3 Managers

    7. Setup security:

    Permission List

    The Permission List CUPO1040 was edited and two more Menus were added for Requisition Approvers.

    1. EOAW_APPROVAL_WORKFLOW

    Integration Broker Setup Integration Broker Setup Integration Broker Setup

    PV_MAIN_MENU

    Two components were enabled under this menu – PV_APPR_MAN_CMP and PV_REQ_APPROVAL

    These pages are required for the approvers to be able to approve requisitions.

    Integration Broker Setup Integration Broker Setup

    A new custom role has been created for Workflow Admin and has been assigned to the “wrkflw_admin” user id as well. Role Name – CU_WF_ADMIN

    See The Team In Action

    Upcoming Events

    Virtual
    Broadcoms-VMWare-Price-Surge-Impact-on-the-Tech-Sector
    May 1, 2024
    04:00 PM ET
    • All
    • General interest topics

    Broadcom's VMWare Price Surge: Impact on the Tech Sector

    Broadcom's VMWare Price Surge: Impact on the Tech Sector

    Exploring Market Trends and Strategic Implications

    May 1, 2024
    04:00 PM ET | 30 mins

    Description

    In this 30-minute panel discussion, industry experts will delve into the recent price surge of Broadcom shares, exploring its underlying causes and projecting its potential effects on the broader technology sector. As Broadcom—a leader in semiconductor and infrastructure software solutions—sees significant fluctuations in its stock prices, stakeholders from across the industry are keen to understand the repercussions. This session will cover key topics such as the drivers behind the price surge, including market trends, financial health, and strategic acquisitions. Additionally, our panelists will discuss how this volatility affects investors, competitors, and the technology market as a whole. Join us to gain insights that could shape your strategic decisions in this rapidly evolving landscape. Whether you are an investor, a tech professional, or simply interested in the dynamics of the tech industry, this discussion promises valuable perspectives to help you navigate the complexities of market changes.

    Event Type

    Virtual

    Event Subject

    General Interest Topics

    Oracle Product Focus

    Oracle VMWare Cloud Service

    Event Audience

    All

    Speakers

    arvind_rajan
    Arvind Rajan
    Joe_Finlinson-new-250x250
    Joe Finlinson
    Virtual
    Next-Level-Docs-IDP-Strategies-that-Work
    May 8, 2024
    04:00 PM ET
    • All
    • Intelligent document processing

    Next-Level Docs: IDP Strategies that Work

    Next-Level Docs: IDP Strategies that Work

    Improve Workflow with Intelligent Document Processing

    May 8, 2024
    04:00 PM ET | 45 mins

    Description

    Join us for a dynamic 45-minute session where we'll dive into the powerful capabilities of Intelligent Document Processing (IDP). This technology isn't just about handling paperwork—it's about transforming how your business operates. Throughout our discussion, we'll explore how IDP uses machine learning and AI to turn dense documents into usable data, swiftly and accurately. You'll learn about the essential components of IDP systems, see them in action through practical examples, and discover strategies to seamlessly integrate these tools into your daily operations. If you're looking to cut costs, boost efficiency, and make more informed decisions, you won't want to miss how IDP can be a game-changer for your organization.

    Event Type

    Virtual

    Event Subject

    Intelligent Document Processing

    Oracle Product Focus

    Oracle Document Understanding Service

    Event Audience

    All

    Speakers

    arvind_rajan
    Arvind Rajan
    Virtual
    AI-Powered-Invoice-Automation
    May 15, 2024
    04:00 PM ET
    • All
    • Ap automation

    AI-Powered Invoice Automation

    AI-Powered Invoice Automation

    Transforming Finance with AI

    May 15, 2024
    04:00 PM ET | 45 mins

    Description

    Join us for an engaging one-hour webinar that explores the revolutionary Astute AP Invoice Automation solution, powered by Oracle AI. Learn how artificial intelligence is reshaping finance by automating the entire invoice process, from capture to payment. We'll discuss key features such as automated error correction, fraud detection, and real-time analytics, providing CFOs and AP teams with the tools needed for efficient and secure financial transactions. Discover how to enhance visibility, speed up approvals, and manage cash flow more effectively with a cloud-native, plug-and-play solution. Perfect for finance professionals seeking to optimize their procure-to-pay processes and leverage cutting-edge AI capabilities for better business outcomes.

    Event Type

    Virtual

    Event Subject

    AP Automation

    Oracle Product Focus

    Oracle Document Understanding Service

    Event Audience

    All

    Speakers

    arvind_rajan
    Arvind Rajan
    Virtual
    PeopleSoft-Sytem-Health-Key-Insights
    May 22, 2024
    04:00 PM ET
    • All
    • Peoplesoft lifecycle management

    PeopleSoft Sytem Health: Key Insights

    PeopleSoft Sytem Health: Key Insights

    Optimizing PeopleSoft for Strategic Business Alignment

    May 22, 2024
    04:00 PM ET | 45 mins

    Description

    In this insightful webinar, discover the comprehensive benefits of the PeopleSoft Health Check service offered by Astute Business Solutions. Learn how this assessment strategically aligns IT goals with overarching business objectives to maximize efficiency and effectiveness. Our experts will guide you through the process of analyzing business needs, organizational structures, and technical environments to optimize your PeopleSoft implementation. Enhance your understanding of the pivotal areas for improvement and prepare your PeopleSoft systems for future challenges and opportunities. Join us to empower your organization with the best practices and actionable insights from PeopleSoft specialists.

    Event Type

    Virtual

    Event Subject

    PeopleSoft Lifecycle Management

    Oracle Product Focus

    PeopleSoft

    Event Audience

    All

    Speakers

    arvind_rajan
    Arvind Rajan

    Reach Out

    Ready to Connect?

    Please fill the following form, we will get back to you within a business day.

    Contact Form

    Contact Us

    Schedule an
    Appointment Now

    Meet with an Astute expert today, we would love to help you think about your enterprise applications, and how the cloud can deliver greater value to your customers.