My Oracle Support Banner

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

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
Goal
Solution
References


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.