Variance Check During Triangulation Rate Calculation
(Doc ID 2547866.1)
Last updated on AUGUST 26, 2024
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When trying to generate Triangulation rate through SQR report that triangulation rates are getting inserted into rate table even if rate is more than variance set up for combination. The EO3090 sqr report should the variance condition while inserting triangulation rates into the rate table.
Steps to replicate:
-------------------
1) Navigate to: Set Up Financials/Supply Chain >> Common Definitions >> Currency >> Currency Quotation Method
Set up currency quotation method between 2 currencies for which rates are not yet defined
Set up Triangulation with a reference currency for which rates exist for both currencies
2) Navigate to: Set Up Financials/Supply Chain >> Common Definitions >> Market Rates >> Market Rate Definition. In market rate definition set the error type as ‘Stop’ for the currency pair
3) Before running Cross/Reciprocal Rate Calc process no rates are present in Rate Table
4) Run Cross/Reciprocal Rate Calc process having Rate Triangulation checkbox selected: Set Up Financials/Supply Chain >> Common Definitions >> Market Rates >> Cross/Reciprocal Rate Calc (EO9030)
Now, rates were inserted in PS_RT_RATE_TBL table with Cross/Reciprocal Rate Calc process as of date.
5) Now, modify rate to common currency for any of the currencies so that it would impact triangulated rate by more than 2.5%. Navigate to: Set Up Financials/Supply Chain >> Common Definitions >> Market Rates >> Market Rates. Two warinig message appear: Rate differres from previos value by more then 2,5% --> Press OK, A triangulated cross-rate was changed, do you want to bypass triangulation? --> Press No
6. Rerun Cross/Reciprocal Rate Calc process with latest as of date: Set Up Financials/Supply Chain >> Common Definitions >> Market Rates >> Cross/Reciprocal Rate Calc (EO9030)
7) Check the Message log of EO9030
No errors seen even if the calculated rate would differ by more than specified tolerance limit.
8) Check the new markte rate: Set Up Financials/Supply Chain >> Common Definitions >> Market Rates >> Market Rates
Newly calculated rate differs by more than 2.5%, which violate the Error option in market rate definition set up. But the new rate is inserted in PS_RT_RATE_TBL by EO9030 process which shouldn't.
Please see Replication screenshots for more details.
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 |