EEX8.8+: The AE EX_EMPNOTIFY goes to No Success

(Doc ID 781970.1)

Last updated on AUGUST 23, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 8.8 to 9.1 [Release 8.8 to 9]
Information in this document applies to any platform.
***Checked for relevance on 04-Jun-2012***

Goal

PeopleSoft Enterprise FSCM application delivers Workflow functionality within the Expenses module that can send email notifications about expense-related events. A message can inform an employee that they have an outstanding Cash Advance or that the system has processed a Payment for a Cash Advance or Expense Report. To implement a notification system, you define system workflow rules and run a process to send notifications about things such as expense payments or overdue items.

The process in charge of this functionality is the Employee Notifications Application Engine Program (EX_EMPNOTIFY). At the time of launching this process, the user can select from 4 main options:

- Employee Payments: Payment has been processed from a cash advance or expense report.
- New Credit Card Transaction: If your organization receives corporate credit card feeds, employees are notified when they need to process new transactions linked to their employee profiles.
- Overdue Advances: Employees are notified when they have outstanding cash advances that have not been reconciled to an expense report within a defined time period.
- Overdue Credit Card Txn (overdue credit card transaction): Employees are notified of outstanding credit card transactions not selected for processing in an expense report because too much time has passed. Your organization defines the overdue period.

Sometimes, however, this process can abend with the following Error Message:

" Role EX_EMPLOYEE has no members
Error when attempting to triger Business Process/Event: EX_PROCESS_PAYMENTS / Send Email
TriggerBusinessEventTriggerBusinessEvent failed for EX_PROCESS_PAYMENTS.Payment Notification-Send Email. (2,302) EX_PMT_NTFY_VW.BANK_SETID.Workflow PCPC:1287 Statement:11
Error saving Component Interface. {EX_PMT_NOTIFY}
Process ABENDED at Step EX_PMT_NOTFY.EMP_NTFY.Step01 (PeopleCode) -- RC = ?
EX_PMT_NOTFY EMP_NTFY Step01 PeopleCode ?
"

This is most of the times related to a configuration problem within the system, or some data setup that is not correctly defined. Which should be the places where to start looking for? What should be troubleshooted and double-checked to have this issue resolved?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms