If you are new here, you may want to subscribe to the following feeds Oracle EPF, EPB - Dimension Rule and Hierarchy Rule
Written by Nilesh JethwaWhat is the main difference between running Dimension and Hierarchy Rule?
Let us consider the example hierarchy below
For instance, if you have the following hierarchy in GL
TOTAL
-1000
–1100
—1110 (L)
—1120 (L)
–1200
—1210 (L)
-2000
–2100
—2110 (L)
—2120 (L)
All the nodes with (L) are the lowest level leaf nodes.
When you run a Dimension Rule, it will bring over 1110, 1120, 1210, 2110, 2120.
When you run a Hierarchy Rule with TOTAL as the starting parent value, it will bring over the TOTAL, 1000, 1100, 1200, 2000, and 2100 parent values into EPF.
In GL you can have multiple hierarchies with different top nodes. In Oracle GL, you can have one child report to multiple parents but in EPF, this is not allowed. One child can report only to one parent and the hierarchy rule will fail if there is a violation of this rule.
Posted in EPB, ERP |
2 Comments to “Oracle EPF, EPB - Dimension Rule and Hierarchy Rule”
Leave a Comment
Free Dashboards and KPI examples
September 6th, 2006 at 8:44 am
Hi,
Thanks for answer but let me explain u with example our chart of account is some thing like this
1000 asset
1100 Cash
–1101 petty Cash
1200 Banks
–1201 Bugran bank
–1202 NBK
–1203 HSBC
now if u want to look what is total of bank u have to simply look at 1200 and u will get total of banks Beacuse all banks are starting from 12 now suppose i want to make one report in which i want to show more items in bank which are not releted to bank but for some resons i want to mix them like this ( i cannot take substring ‘12′ this logic fail here i m looking for some option in oracle apps where i can define group that Bankgroup have these account 1201 1304 any thing dosent mater it start from 12 or 12
Banks
1201
1202
1300
1400
September 6th, 2006 at 1:22 pm
Hi Adeel,
What you can do is create a new node in your Account value set.
Go to Key Flexfields Values screen. Query the values for the account segment that you are considering.
Now Click on the plus button to create a new value. Give a name to this new value such as ‘ABC’, description and Check the ‘Parent Flag’. Set the ‘Allow Posting to No’ and ‘Allow Budgeting to Yes or No’ depending on your requirement. Save it
Now click on the define child ranges. In this section enter all the child accounts that you want to report to.
I hope this is what you were looking for.
-Nilesh