Case 00035068 – AP Payment Exchange Rate Incorrect on Payment History

AP Payment Exchange Rate Incorrect on Payment History

Case Number	00035068
Oracle Module	Accounts Payable (AP)
EBS Version	R12
Functional Area	Payment Processing / Foreign Currency / Exchange Rates
Related Patches	None

Symptoms

An AP payment in a foreign currency has an incorrect payment-to-base exchange rate recorded in AP_PAYMENT_HISTORY_ALL.
The MATURITY_EXCHANGE_RATE on the associated check in AP_CHECKS_ALL does not match the correct rate.
The accounted payment amount in the functional currency is incorrect, causing GL reconciliation discrepancies.
Foreign currency gain/loss calculations may be impacted.

Root Cause

The payment-to-base exchange rate (PMT_TO_BASE_XRATE) and its associated rate date were either missing or populated with an incorrect value at the time of payment creation. This caused the payment history record and the check to carry an incorrect functional currency conversion rate. The correct rate was determined through review of the applicable exchange rate table for the payment date.

Resolution

Step 1 – Create backup tables

Run data_fix.sql. The script backs up affected rows:

rsi_ap_check_<case> — snapshot of AP_CHECKS_ALL
rsi_ap_payment_hist_<case> — snapshot of AP_PAYMENT_HISTORY_ALL

Step 2 – Update payment history exchange rate

Update AP_PAYMENT_HISTORY_ALL to set the correct PMT_TO_BASE_XRATE and PMT_TO_BASE_XRATE_DATE values for the affected payment history record.

Step 3 – Update check maturity exchange rate

Update AP_CHECKS_ALL to set the correct MATURITY_EXCHANGE_RATE for the affected check.

Step 4 – Commit and validate

Issue COMMIT. Verify the accounted payment amounts now reflect the correct exchange rate conversion. Re-run Create Accounting if journal entries need to be regenerated.

Note: After correcting the exchange rate, it may be necessary to reverse and recreate accounting entries for the payment to ensure the GL reflects the corrected functional currency amounts.

Script Inventory

File	Description
data_fix.sql	Creates backups; updates PMT_TO_BASE_XRATE and PMT_TO_BASE_XRATE_DATE on AP_PAYMENT_HISTORY_ALL; updates MATURITY_EXCHANGE_RATE on AP_CHECKS_ALL.

Key Tables Affected

Table	Action
AP_PAYMENT_HISTORY_ALL	Update PMT_TO_BASE_XRATE, PMT_TO_BASE_XRATE_DATE
AP_CHECKS_ALL	Update MATURITY_EXCHANGE_RATE