R12: AP: Invoices not Validating by Invoice Validation Process but will Validate via Invoice Workbench (Doc ID 2166970.1)

Last updated on APRIL 26, 2023

Applies to:

Symptoms

For certain invoices in a particular operating unit, the scheduled Invoice Validation concurrent process ends in Warning and does not successfully validate the invoices.  The error message in the log file reads (as an example):

   Invoice Validation did not process Invoice Id Due to Tax Error:6761989, Line Number:"
   For the currency USD, there is either no exchange rate for currency CAD defined or it is not applicable for DD-MMM-YY. (TRX_CURRENCY_CONV_DATE=DD-MMM-YY.)

However, these same invoices can successfully be validated from the Invoice Workbench.
Also noteworthy: The date mentioned in the error message (in the case of this example, "DD-MMM-YY.) does not appear relevant to the invoice(s) not validating in the concurrent process.

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.