EAP: Payment Request Duplicate Invoice Checking Does Not Work if Invoice Number Has Lowercase Letter (Doc ID 2894429.1)

Last updated on SEPTEMBER 07, 2022

Applies to:

Symptoms

Payment Request Duplicate Invoice Checking does not catch a duplicate Invoice Number if the initial Payment Request has a lowercase letter entered as part of the Invoice Number.

However, if the initial Payment Request has all uppercase letters for the Invoice Number, the duplicate invoice detected error is displayed for subsequent Payment Requests even if the same Invoice Number is all lowercase letters.

STEPS
1. Navigate to Set Up Financials/Supply Chain > Business Unit Related > Payables > Payables BU Processing Options
2. On the Payables Options > Vouchering Options 2 page, Duplicate Invoice Checking has the following boxes checked:
   - Invoice Number, Invoice Date, Gross Amount, Supplier ID, and Business Unit
3. On the Fluid Employee Self Service Home page, click the Payment Request tile
4. Add a Payment Request with Invoice Number = test_duplicate
5. Submit the Payment Request
6. Click OK to the following message received -- The current Payment Request will be submitted. Click OK to proceed
7. Payment Request Center lists the above Payment Request
8. Select the Payment Request just created
9. On the Payment Request page, click the Copy button
10. On the Summary page, do not make any changes. Leave the Invoice Number = test_duplicate
11. Submit the Payment Request
12. Click OK to the following message received -- The current Payment Request will be submitted. Click OK to proceed
13. Payment Request Center lists both Payment Requests created above with all the same information -- This should not have occurred. Should have received a duplicate invoiced detected error in Step 12.
14. Select any one of the two Payment Requests created
15. On the Payment Request page, click the Copy button
16. On the Summary page, change the Invoice Number to TEST_DUPLICATE
17. Submit the Payment Request
18. Click OK to the following message received -- The current Payment Request will be submitted. Click OK to proceed
19. Payment Request Center lists all three Payment Requests created
20. Select the Payment Requests with Invoice Number = TEST_DUPLICATE
21. On the Payment Request page, click the Copy button
22. On the Summary page, change the Invoice Number to test_duplicate
23. Submit the Payment Request
24. Following message is displayed:  

Duplicate Invoice detected -see payment request xxxxxxxxxx. Payment Request is rejected.

A duplicate invoice has been detected according to criteria established for the current payment request's Business Unit or Supplier. Refer to the indicated payment request or voucher to inspect duplicate entry values. The current payment request cannot be entered or saved until duplicate values are resolved.

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.