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.
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?
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms