My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2020

Applies to:

Oracle Freight Payment, Billing and Claims Cloud Service - Version 19 and later
Information in this document applies to any platform.

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

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
Cause
Solution


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