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.
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
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|