EEX 9.2: Employee Notifications Abends at Step EX_PMT_NOTFY.EMP_NTFY.Step01 As TriggerBusinessEvent Failed for EX_PROCESS_PAYMENTS.Payment Notification-Send Email (Doc ID 2914483.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

When the Employee Notifications process (EX_EMPNOTIFY Application Engine Program) abends at Step EX_PMT_NOTFY.EMP_NTFY.Step01 as it fails to validate an Employee's Email Address if this one is incorrect, when generating Payment Notifications.

The Error Message involves TriggerBusinessEvent for EX_PROCESS_PAYMENTS.Payment Notification-Send Email, whose codeline is invoked by PeopleCode within EX_PMT_NTFY_VW.BANK_SETID.Workflow.

REPLICATION STEPS:

  - Log into the FSCM Online Application as User ID VP1
  - Navigate to: PeopleTools > Security > User Profiles > User Profiles
  - Open the PeopleTools Profile from existing User ID EXA1
  - Go to the General tab
  - Click on the Edit Email Addresses link
  - Make sure there is an invalid value in Email Address column
  - Go to the ID tab, and make sure to to define Employee ID KU0021
  - Navigate to: Travel and Expenses > Manage Security > Authorize Expense Users
  - Open existing Employee ID KU0021
  - List User ID EXA1 as an authorized user, and save the changes
  - Log into the FSCM Online Application as User ID EXA1
  - Navigate to: Employee Self-Service Fluid Homepage > Expenses Tile > Create Expense Report Tile
  - Create a brand new Expense Report on behalf of Employee ID KU0021
  - Submit the new Expense Report for approval
  - Log into the FSCM Online Application as Approver
  - Navigate to: Employee Self Service Fluid Homepage > Approvals Tile > Pending Approvals
  - Find the submitted Expense Report, and approve the transaction for payment
  - Log into the FSCM Online Application as User ID VP1
  - Proceed to run the Expenses Post Liabilities process
  - Continue with the Stage Payments program
  - Define a new Pay Cycle in AP Module targeting the Expense Report
  - Run Pay Cycle Selection, Pay Cycle Creation, all the way until Completion
  - Run the Expense Processing program with the options of 'Update Paid Statuses' and 'Post Payments' options selected
  - Navigate to: Travel and Expenses > Manage Employee Information > Process Employee Notifications
  - Add a new Run Control ID with the below option selected:
       - Employee Notification = Employee Payments
  - Run the Application Engine Program EX_EMPNOTIFY
  - Confirm in Process Monitor that the process has abended in an Error Message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.