3745699 - Exchange Rate Replication Error : "Query result not unique; BO CER_EXCHANGE_RATE, Node ROOT, Query QUERY_BY_CURRENCY_PAIR2 : CATEGORY_CODE = 1 ; VALID_FROM_DATE_TIME = XYZ;"

• Exchange rate replication from S/4 to sales cloud fails for specific currency pairs.
• Error message: "Query result not unique; BO CER_EXCHANGE_RATE, Node ROOT, Query QUERY_BY_CURRENCY_PAIR2 : CATEGORY_CODE = 1 ; VALID_FROM_DATE_TIME = XYZ; EXCHANGE_RATE_QUOTED_CURRENCY = EUR ; EXCHANGE_RATE_UNIT_CURRENCY_CO = AUD ; TYPE_CODE-CONTENT = 001"

• Product: SAP Cloud for Customer core applications
• Integration of C4C with S/4 HANA

1. Go to web service message monitor 

2. Open the exchange rate service interface 

3. Error :Query result not unique; BO CER_EXCHANGE_RATE, Node ROOT, Query QUERY_BY_CURRENCY_PAIR2 : CATEGORY_CODE = 1 ; VALID_FROM_DATE_TI

An inactive exchange rate entry for the same currency pair/date/type exists in the system which is causing this issue .

1. Identify the incoming payload details (FromCurrencyCode, ToCurrencyCode, ConversionDateTime, TypeCode) from the failed replication.
2. In sales cloud, open Administrator > Exchange Rate for Foreign Currencies > View Exchange Rate work center.
3. Filter by the source (FromCurrencyCode) and target (ToCurrencyCode) currencies, and locate entries for the relevant date and type.
4. If the existing entry is inactive, create/maintain a new active exchange rate entry for the same currency pair, new date, and sametype. Note: Exchange rates cannot be deleted via the UI; inactive combinations remain.
5. Re-trigger the replication from S/4 and verify the inbound processing completes successfully.

query result not unique, CER_EXCHANGE_RATE, QUERY_BY_CURRENCY_PAIR2, exchange rate replication, inactive exchange rate, duplicate exchange rates, TypeCode, VALID_FROM_DATE_TIME, FromCurrencyCode, ToCurrencyCode, inbound processing, push integration, c4c, s/4, sales cloud , KBA , LOD-CRM-INT-S4H , Integration of C4C with S/4 HANA , Problem