My Oracle Support Banner

R12: AP/IBY: The Recalculate Payment Process Request Concurrent Process Fails with : ORA-00001: Unique Constraint (AP.AP_USER_EXCHANGE_RATES_U1) Violated (Doc ID 2912834.1)

Last updated on DECEMBER 01, 2022

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Payments - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When running the "Recalculate Payment Process Request" concurrent process for a Payment Process Request (PPR) the following error occurs :

ORA-00001: unique constraint (AP.AP_USER_EXCHANGE_RATES_U1) violated
  1. From a Payables Responsibility navigate to Payments -> Entry -> Payments Manager -> Submit Single Payment Process Request
  2. Fill out the request details with "Stop Process for Review After Scheduled Payment Selection" under the "Processing" tab checked
  3. Submit the PPR
  4. Once the PPR is in "Invoices Pending Review" status click on the "Start Action" icon
  5. Make a change by adding or removing a scheduled payment
  6. Click Calculate to submit the "Recalculate Payment Process Request" program
  7. Go to View -> Requests an review the log file for the error

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


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