My Oracle Support Banner

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

Last updated on MARCH 05, 2019

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 <currency-1>
Inventory Organization A denominated in <currency-2>

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 <currency-1>and needs to be converted to <currency-2>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 <currency-1>and <currency-2>.

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

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.