Interface Trip Stop Providing Unexpected Result When Daily Rates Are Missing (Doc ID 2082750.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Inventory Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
The Interface Trip Stop processes is not correctly rejecting transactions that require daily rates when running in non-Debug mode.

Scenario:

Internal Drop Shipment: Sales Order issue from OU2 (Inventory Organization B) for a Sales Order in OU1 (Inventory Organization = A)
Inventory Organization B denominated in EUR
Inventory Organization A denominated in GBP

As per standard Oracle customer gets the following transactions

Inventory Organization A: Logical Intercompany Sales Issue (@average cost in B)
Inventory Organization B: Logical Intercompany Shipment Receipt (@transfer cost)
Inventory Organization B: Logical Sales Order Issue t (@transfer cost)

Transfer Cost is being passed as the Average cost in B in EUR and needs to be converted to GBP in A by Interface Trip Stop.

When the Interface Trip stop is run in Debug mode customer gets the expected result:

Warning: Cannot retrieve the currency exchange rate

Cause: Currency conversion rate for the desired date and rate type Corporate has not been defined between EUR and GBP.

When the Interface Trip stop is run on Non-Debug mode customer found that the value returned for transfer cost after currency conversion is always as "-99" irrespective of the actual inventory value and the fact there is no daily rate.

EXPECTED BEHAVIOR
-----------------------
Customer expects that ITS would return a warning like in Debug mode

Changes

 

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