Set Exchange Rate Using Direct SQL Update Agent Action not Updating the Invoice Header Amount Value (Doc ID 2635612.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Set Exchange Rate Using Direct SQL Update Agent Action not Updating the Invoice Header Amount Value

Customer have requirement to set the exchange rate on invoice. During invoice matching they want to set the exchange rate but they want to set the date of exchange as shipment actual receipt date not the invoice match date.
According to standard agent action availability "Set Exchange Rate", it takes the SYSDATE for exchange rate date but Customer want to have shipment actual receipt date.
For this requirement They have created direct sql update to update the exchange rate id and date on the invoice during match.
This Direct SQL Update Action will update the exchange rate id and date on the invoice but exchange rate not getting applied on invoice costs. But once they select that invoice and click on finish changes reflecting. But this is manual task which Customer doesn't required. 

Is there any alternate options to achieve this

Cause

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