Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Translation Rule - Not picking up the rates.

992405Oct 7 2014 — edited Oct 8 2014

Dear All,

According to our customer requirement we need to have a different rate to that of normal exchange rate.

So we have used Rules to define the same.

As there are some P&L accounts for which these different rate (Say Special Rate) should be applied, we have used TransPeriodic String to apply the rule as follows.

If HS.ENTITY.Member = "NORTH" Then

IF HS.Year.Member() = "2013" Then

If strAccount = "12345" or strAccount = "12346" or strAccount = "12347" Then

If HS.Period.Member() = "May" Then

HS.TransPeriodic "A#"&strAccount , "A#"&strAccount, 60, ""

ElseIf HS.Period.Member() = "June" Then

HS.TransPeriodic "A#"&strAccount , "A#"&strAccount, 70, ""

ElseIf HS.Period.Member() = "July" Then

HS.TransPeriodic "A#"&strAccount , "A#"&strAccount, 80, ""

ElseIf HS.Period.Member() = "August" Then

HS.TransPeriodic "A#"&strAccount , "A#"&strAccount, 90, ""

End If

When we have checked this rule in our UAT it is working fine for May, June, July but it is not picking for "August".

For August it is not picking Special Rate it is picking normal Exchange Rate.

Am i missing anything to enable in August so that it can pick the rule file and calculate the special rate.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2014

Added on Oct 7 2014

#business-intelligence-applications, #financial-data-management, #performance-management-applications

2 comments

671 views