Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

Using Value ECT causes calculation to be run twice

edited Mar 25, 2019 11:59AM in Hyperion Financial Management (HFM) (MOSC) 5 commentsAnswered

Hi all,

I wrote a validation rule that calculates the difference between a balance sheet account and a movement account. After running calculate using process control screen; validation is not calculated properly. Only after running force calculate right after calculating, the validation works fine.

validationdifference = HS.GetCell("A#BS20714000.C2#[None].V#<Entity Curr Total>"&topsxc2) - HS.GetCell("A#BS20714000.C2#MOV_TNG.V#<Entity Curr Total>"&topsxc2)

Detailed explanation is below.

- Balance sheet accounts have adjustments over Entity Currency figures, so IFRS figures sit on <Entity Curr Total> Value member. First line in the table below.

- But for movements IFRS figures are manually entered so they have no adjustments.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center