R12 PAAPIMPB: Exchange Rate Variances (ERV) Appear in Projects but are Missing in Payables.
Last updated on MARCH 20, 2017
Applies to:Oracle Project Costing - Version 12.2.4 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms