Import Autoinvoice Ending In Error get_other_rate Conversion rate not found in GL_DAILY_RATES (Doc ID 2945792.1)

Last updated on MAY 09, 2023

Applies to:

Symptoms

Import Autoinvoice ending in error due to missing rates. User rate and rate information is available in FBDI file and interface

ERROR
-----------------------
ERROR 1: invoice_id 5013-ZX_TDS_TAX_ROUNDING_PKG.get_other_rate
>>Conversion rate not found in GL_DAILY_RATES. From currenecy USD to currency CAD date YYYY-MM-DD

1: A currency conversion rate doesn't exist for this currency. Cause:For the currency USD, there is either no conversion rate for currency CAD defined or it isn't applicable for the currency conversion date YYYY-MM-DD. Action:Enter a valid con.(100000006331553)

Printing Errors from ZX_ERRORS ALONE.

Zx error 2 is A currency conversion rate doesn't exist for this currency. Cause:For the currency USD, there is either no conversion rate for currency CAD defined or it isn't applicable for the currency conversion date YYYY-MM-DD. Action:Enter a valid con

arp_etax_util.print_tax_validation_errors()-


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Fill out template 'Receivables Autoinvoice Import Interface'
2. Generate the .csv files and the zipped file
3. Import the File to UCM
4. Populate the Interface tables with the data from the file on UCM (Load Interface File For Import)
5. Submit the AutoInvoice Process

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.