Customer Interface errors with 'This Customer Payment Method Is Already Defined To Be Active For The Date Range Specified' (Doc ID 1635024.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

In R12

Run Customer Interface to convert payment methods for another operating unit associated to a customer, and it fails with the following error message in the Customer Interface Transfer Report:

========================================= Exception Records in RA_CUST_PAY_METHOD_INTERFACE ========================================

Customer Reference Address Reference Payment Method Name Start Date Error Message
------------------ ----------------- ------------------- ---------- --------------------------------------------------------------
MX-15678 BILL_TO PA720 CITI USD SMITH 01-JAN-68
  This customer payment method is already defined to be active for
  the date range specified.
  
MX-15678 BILL_TO PA720 CITI USD SMITH 01-JAN-68
  This customer payment method is already defined to be active for
  the date range specified.
  
MX-15678 BILL_TO PA720 CITI USD SMITH 01-JAN-68
  This customer payment method is already defined to be active for
  the date range specified.
  
MX-15678 BILL_TO PA720 CITI USD SMITH 01-JAN-68
  This customer payment method is already defined to be active for
  the date range specified.

This happens when an account has two sites in different countries.  The first country is imported with no issues.
When loading the second country's site for a different operating unit, all the payment methods error out if they belong to the the first operating unit.
The failed records have the correct operating unit assigned to the records.

It seems that the Customer Interface code may not be considering the site_use_id which is in a different by operating unit in the RA_CUST_RECEIPT_METHODS table.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms