EAP: Erroneous 'Duplicate Invoice Detected" Error When Adding Voucher By Supplier Name (Doc ID 2815003.1)

Last updated on APRIL 28, 2023

Applies to:

Symptoms

Duplicate Invoice Checking is setup with the boxes checked for Supplier ID, Invoice Number, and Invoice Date on the Supplier > Identifying Information page. When trying to create a Voucher by populating the Supplier Name and Invoice Number that was on a previous Voucher, receive an error, referencing a Voucher created back in August 2010.

However, if try to create a Voucher by populating the Supplier ID and Invoice Number that was on a previous Voucher, able to add the Voucher without any errors.

Adding a Voucher by populating the Supplier Name should behave the same way as populating the Supplier ID. Should be able to add a Voucher both ways.

ERROR
Duplicate invoice detected -- see voucher xxxxxxxx for Business Unit yyyyy. Voucher entry is rejected. (7030,22)

STEPS 

1. On the Supplier > Identifying Information page, under Duplicate Invoice Settings, have two rows existing

a. Effective Date = 07/29/2019
Duplicate Inv Indicator = Specify at this Level
Boxes checked for Supplier ID, Invoice Number, and Invoice Date

b. Effective Date = 01/25/2008
Duplicate Inv Indicator = Default from Higher Level

2. On the Payables Option > Vouchering Options 1 page, Duplicate Invoice Checking setup:

a. Boxes checked for Invoice Number and Supplier ID

3. On the Vouchers > Add/Update > Regular Entry > Add a New Value page, enter a partial name in the Supplier Name field
4. Select a Supplier
5. Populate the Invoice Number field with a value that is on a previous Voucher
6. Click Add
7. Above error is received

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.