How To Find Costed Transactions Affected By Wrong Exchange Rate
(Doc ID 2799373.1)
Last updated on SEPTEMBER 12, 2021
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
-How To Find Costed Transactions Affected By Wrong Exchange Rate
Costed Material Transactions for particular exchange rate, on the certain transaction date can be found in following ways:
1)From Front-end application:
>Go to Inventory Responsibility > Transactions > Material Transactions - This will open "Find Material Transaction Form"
> Provide values for following fields and click "Find" button
1.Transaction Dates - <Please fill the transaction dates on which transaction was done with wrong exchange rate.>
2.Costed Flag = Yes
3.Provide Source Type, Transaction Type values, if you are looking for a specific Source or Transaction type else keep them blank.
> After clicking "Find" button, you will be able to see costed material transactions.
> For available transaction records, click "Distribution" button at the bottom of the form and check "Conversion Rate or Exchange Rate" in the "Currency" tab of "Material Transaction Distribution" form.
>Go to Inventory Responsibility > Transactions > Material Distributions
>In "Find Material Distributions " from, provide the transaction dates on which transaction was done with wrong exchange rate.
>You can provide any other information to filter the results as needed . Ex. Transaction Type, Source Type , Subinventory etc..
> Click on "Find" button.
> You will see "Material Transaction Distributions" form.
>Click on "Currency tab where you will be able to find records with " Conversion Rate /Exchange Rate" that was entered by user.
> If there are good number of records then transactions can be exported in the excel file and can be filtered based on the "Conversion Rate" Column.
2) Alternatively we can query the transactions from the backend.
The following query can be modified as needed, based on the inputs you would like to provide and data you would like to filter.
SELECT * FROM mtl_material_transactions
WHERE currency_conversion_rate = <Exchange Rate>
AND costed_flag IS NULL
AND currency_conversion_date = <currency conversion date > --Optional condition
AND transaction_date = < transaction date > ;
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