Interface Trip Stop Providing Unexpected Result When Daily Rates Are Missing
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.
The Interface Trip Stop processes is not correctly rejecting transactions that require daily rates when running in non-Debug mode.
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.
Customer expects that ITS would return a warning like in Debug mode
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