My Oracle Support Banner

Incorrectly Populating the Exchange Rate on the SHIPMENT and TRAN_DATA Tables for PO Receipt in Some Scenarios. (Doc ID 3000879.1)

Last updated on JANUARY 29, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

Incorrectly populating the exchange rate on the Shipment (and Tran_Data) tables in some scenarios.

Facing the issue in Case 2.

Case 2: IGNORE_ENT_EXCHANGE_RATE_IND = Y and EXCHANGE_RATE_DATE = 'TPD' for ENTITY_ID = ORDC

Issue : Latest exchange rate should be used ('C' or 'O') depending upon the system options setting. Instead, in the SHIPMENT table exchange rate with type = P is getting used.
TRAN_DATA is working as expected


STEPS TO REPRODUCE
1. Have a purchasing exchange rate different from the operational exchange rate
2. Create a PO with a different exchange rate than location (currencies in-line with the order)
3. Receive goods
4. Compare exchange rate on shipment versus the applied exchange rate in tran_data records.

Changes

 NA

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
Changes
Cause
Solution
References


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