R12: AP: 'No Rate' Hold Place During Invoice Cancellation (Doc ID 1294309.1)

Last updated on FEBRUARY 04, 2025

Applies to:

Symptoms

NO RATE hold is placed at Invoice Cancellation time.

When attempting to release NO RATE hold, the error listed below is displayed.

AutoRate concurrent program is not running for cancelled invoices.  

Steps to reproduce:

1. Log into Oracle Applications using a Payables responsibility
2. Open the Invoice Workbench screen
   (N) Invoices > Entry > Invoices
3. Query the invoice to cancel.
4. Use the [Actions] button, Cancel option to try to cancel the invoice.
   A new "NO RATE" hold is placed on the invoice.
   
   
5. Go to the [Holds] tab and set the cursor on the "NO RATE" hold and try to release this hold.
   You get error message APP-SQLAP-10009 described above.

An output of the EBS Payables and eBTax Invoice Analyzer Report (APINVANLZR), executed for the problem invoice (Invoice_ID), shows the invoice currency (AP_INVOICES_ALL.invoice_currency_code) differs from the Payables Options Base Currency (AP_SYSTEM_PARAMERTERS_ALL.base_currency_code) and the Invoice is missing Exchange Rate information (AP_INVOICES_ALL.exchange_rate IS NULL  AND  AP_INVOICES_ALL.exchange_rate_Type IS NULL).

Cause

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