My Oracle Support Banner

EEX9.2: Exp Report Payment Notification doubling the amount Field (Doc ID 2178412.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 version, Expense Report

Expense report Payment Notification doubling the Amount field

Payment Notification is doubling the Amount field in the Expense Report payment row when the Employee has two rows on the EX_ER_PYM_VW. 
The T&E Payment Notification process uses a component interface to send the notifications to each employee. The component interface uses a new view to populate the expense sheet information. This new view (EX_ER_PYM_VW) joins to the PS_EX_EE_PYMNT_DTL, that doubles the payment amount when the employee has two rows on this table, one row for each Employee relationship that the Employee has had with the company that is tracked with different EMPL_RCD field values.


1. Make sure the employee have two employee records and payment details on both the records are same.
2. Log in as a user.
3. Create and Submit an Expense Report.
4. Get it approved and paid.
5. Run Employee Payment notification process.
6. When an email is generated, the amount is doubled in that email.

The issue has the following business impact:
Due to this issue, users getting wrong amount in emails.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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