EEX 9.2: Review Supplier Payments Lists Expense Report From Other Bank Due To The Same Payment ID (Doc ID 2795271.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Supplier Payments Are Showing Up Payments That Are for Other Bank Account due to the same Payment ID

Steps:
1.  Make sure for two different Bank Accounts MAX(PS_PAYMENT_TBL.PYMNT_ID) is same.
2.  Create an Expense Report with an Expense LIne of credit card payment method and get it approved.
3.  Stage the Expense Report and Pay the Expense Report using Paycycle.
4.  Run the post payment process
5.  Create another Expense Report with an Expense LIne of credit card payment method and get it approved.
6.  Stage the Expense Report
7.  Navigate to Travel and Expenses > Process Expenses > Update Staged Payments > Supplier Payments
8.  Open the Supplier of Credit card which has been used on Expense Report and update the Bank Account with other Bank Account which had same PYMNT_ID
9.  Pay the Expense Report using Paycycle
10.Run the Post Payment process
11.Navigate to Travel and Expenses > Process Expenses > Review Payments > Supplier Payments
12.Search with for the payment with a Bank Account and open it

• System shows the Expense Report of different Bank Account also as it has same payment id instead of showing the Expense Report of the Bank Account which is provided in the search
  Expense Report with only searched bank account should be displayed.

Cause

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