R12 PAAPIMPB: Exchange Rate Variances (ERV) Appear in Projects but are Missing in Payables. (Doc ID 2245903.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

The customer has an ERV that was imported into PA and then deleted from AP by one of their generic datafixes (distribution line number missing from ap_invoice_distributions_all) .  The datafix did not remove the item from Projects.  They are asking for a datafix to remove the expenditure in PA as well.

Payable generic datafix patch 19276929:R12.AP.C - AP notes:

The fix script ap_cancel_inv_fix.sql resolves the cancellation issue where the customer tried to cancel the invoice but the attempt failed. The fix will delete all the tax, ipv and erv distributions and correct the rest of the distributions. Below the code from fix script ap_cancel_inv_fix.sql

-- delete all IPV and ERV distributions
 delete ap_invoice_distributions_all aid
  where invoice_id in (select invoice_id from AP_TEMP_DATA_DRIVER_9088967
  where process_flag = 'D')
  and line_type_lookup_code in ('IPV', 'ERV');

The AP GDF script has deleted the ERV lines from invoice distributions without taking care of PA data.

Cause

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