R12/XTR: When exclusion item NONE revaluation UNREALIZED GAIN LOSS incorrect and Retro Test FAILS (Doc ID 1273212.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Treasury - Version 12.0.0 to 12.2.5 [Release 12 to 12.2]
Information in this document applies to any platform.

Goal

When exclusion item: NONE revaluation appears to be incorrect: UNREALIZED GAIN/LOSS is incorrect and Retrospective Effectiveness Test FAILS? Basically:
1. When exclusion item is NONE revaluation appears to be incorrect: UNREALIZED GAIN/LOSS is incorrect And Retrospective Effectiveness Test FAILS?
2. What is the calculation for the Unrealized Gain or Loss for hedges?

Example:
a. Exclusion Item on 13008 is none
b. Exclusion Item 13007 is set to time value

DEAL_NO DEAL_TYPE AMOUNT_TYPE UNREALISED_PL FAIR_VALUE PERIOD_FROM PERIOD_TO
13007 HEDGE CCYUNRL       0       -100000 01-NOV-10 30-NOV-10
13008 HEDGE UNREAL   -5092.03 -320840.61 01-NOV-10 30-NOV-10
14065 FX        UNREAL   -101.65       -101.65 01-NOV-10 30-NOV-10
14066 FX        UNREAL  -5240.5    -5240.5 01-NOV-10 30-NOV-10


Step 1: Create FX Forward (Deal = 14068) > Create Hedge Attributes > Effectiveness Testing tab (See Screenshots) > Assign Hedge Items and Hedge Instruments (Deal 14068) > Set Status of Hedge = Current

Step 2: Treasury > Accounting > Hedge Effectiveness Testing > Prospective > Enter Prospective Test for 01-NOV-2010 with STatus = Pass. Next test is not required until 01-DEC-2010 as defined in the Hedge Attributes

Step 3: Treasury > Accounting > Revalatuions > Create Revaluation Batch (01-NOV-2010 thru 15-NOV-2010) > Capture Rates > Create Revaluations > Authorize

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms