My Oracle Support Banner

Variance Check During Triangulation Rate Calculation (Doc ID 2547866.1)

Last updated on OCTOBER 22, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:

------- 

Variance Check During Triangulation Rate Calculation EO9030

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.


ACTUAL BEHAVIOR
---------------
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.


EXPECTED BEHAVIOR
-----------------------
Rate shouldn’t change if error type option is set as Stop & the rate after calculation varies by more than the specific tolerance.

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.