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

Last updated on SEPTEMBER 12, 2016

Applies to:

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

Symptoms

On : 9.2 version, Expense Report

ACTUAL BEHAVIOR
---------------
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.

STEPS
--------

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.


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

Cause

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