WFR Identifying an Invoice as a Duplicate Even Invoice it is Not A Duplicate (Doc ID 2161680.1)

Last updated on FEBRUARY 29, 2024

Applies to:

Symptoms

After Implementing the WFR Duplicate Check, a few invoices are incorrectly showing as duplicate.  The .ini file was implemented to look for duplicate invoices. Currently, if an invoice is found to be a duplicate, WFR will not allow for further processing of this invoice. Is there any way we can process these invoices from WFR.

The issue can be reproduced at will with the following steps:

Set the ini settings as listed below:

# Duplicate invoice number check
WFR_OP_PerformDuplicateInvoiceCheck=YES
WFR_VL_CDIERPName=WorkFlow OR JDE
WFR_VL_CDISQLConnectionGroup=03
WFR_VL_CDIDBTableName=PROD_OCS.INVOICEDUPLICATECHECK
WFR_VL_CDIDBInvoiceNumber=INVOICENUMBER
#WFR_VL_CDIDBSupplierID=VENDOR_ID
#WFR_VL_CDIDBSupplierSite=VENDOR_SITE_ID
WFR_VL_CDIDBSupplierSite=VENDORID
#WFR_VL_CDIDBCompanyCode=ORG_ID
WFR_OP_CDIIgnoreBlankValues=YES
WFR_OP_CDIAllowForceValidation=NO
 

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.