EAP: Corrected Recycled Voucher Still Has Error, "Invoice Number Duplicate Invoices Exist" Since Voucher Still Exists on PS_TSE_VCHR and PS_TSE_VCHR_FLD (Doc ID 2814994.1)

Last updated on SEPTEMBER 02, 2024

Applies to:

Symptoms

Voucher placed in Recycled Status due to Duplicate Invoice Checking since it is a duplicate of a matched PO Voucher. Matched PO Voucher is deleted. The Recycled Voucher is re-saved and is now in a Postable status. Voucher is no longer a duplicate Voucher since the PO Voucher was deleted. However, if the Voucher is re-displayed, Voucher > Error Summary page still has the following Header Errors:

Invoice Number Duplicate Invoices Exist

It appears that the Voucher was not deleted from the tables of TSE_VCHR and TSE_VCHR_FLD when the Voucher was re-saved.

Data is now out of sync since Voucher still exists in the tables of TSE_VCHR and TSE_VCHR_FLD but the Voucher is in a Postable Status.

STEPS
1. Navigate to Set Up Financials/Supply Chain > Business Unit Related > Payables > Payables Options > Vouchering Options 2 page
2. Duplicate Invoice Checking set to Recycle
3. Create a PO
4. Dispatch the PO
5. Create Voucher from the PO
6. Run Matching
7. PO Voucher is matched
8. Create a new Voucher with the same info as the PO Voucher from Step 5
9. When adding the Voucher, following message is displayed:

Warning -- Duplicate invoice detected -- see voucher xxxxxxxx for Business Unit yyyyy. Voucher cannot be posted. (7030,142)

A duplicate invoice has been detected, according to criteria established for the current voucher's Business Unit, Voucher Origin, Control Group, or Supplier. Refer to the indicated voucher to inspect duplicate entry values. The current voucher can be saved, but cannot be posted until duplicate values are resolved

10.  Click OK
11.  On the Voucher > Invoice Information page, populate the Distribution Line
12.  Click Save For Later
13.  Click OK to Warning Message. This is the same message from Step 9.
14.  On the Voucher > Invoice Information page, "Go to Review Errors" icon displays beside the Business Unit
15.  Voucher > Error Summary page has the following Header Error:

Invoice Number Duplicate Invoices Exist

16.  On the Voucher > Summary page, Entry Status = Recycle
17.  On the Delete Voucher page, delete the PO Voucher
18. When Click Delete on the Delete Voucher page, following message is displayed:

  You cannot delete this voucher. (7030,162)

  The voucher has been associated with:

  (1) Accounting entries, or
  (2) Payments, or
  (3) Matching, or
  (4) Netting, or
  (5) Workflow

19.  Click OK
20.  On the Match Workbench page, search for the Matched PO Voucher then check the Undo Match box
21.  Select Action = Undo Matching
22.  Click Run
23.  On the Match Workbench page, search for Match Status = To Be Matched
24.  PO Voucher has a status of “To Be Matched”
25.  On the Delete Voucher page, delete the PO Voucher
26.  Click Delete
27.  PO Voucher has Entry Status = Deleted
28.  Display the Recycled Voucher
29.  On the Voucher > Invoice Information page, click Save
30.  "Go to Review Errors icon" is no longer displayed beside the Business Unit
31.  On the Voucher > Summary page, Entry Status = Postable
32.  Re-display the Postable Voucher
33.  On the Voucher > Summary page, Entry Status = Postable
34.  On the Voucher > Invoice Information page, "Go to Review Errors icon is displayed again beside the Business Unit
35.  On the Voucher > Error Summary page has the following Header Error:

Invoice Number Duplicate Invoices Exist

36.  Through SQL, verify that the Voucher still exists on PS_TSE_VCHR and PS_TSE_VCHR_FLD even though the Voucher’s Entry Status = Postable

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.