 Parent Child Values in GL Accounting Segment [message #529855] |
Thu, 03 November 2011 07:06  |
|
|
Hi Techies,
I have created parent & child accounts as shown below in GL Accounting Flexfields Segment4 for a IVB_ACCOUNT Value set.
1000(Grand Parent)
| | |
100 200 300
__|______
301 302 303
System Adminisrtator-> Application -> Validation-> Values
1000 is the grant parent account
100 & 200 are the leaf child values(i.e no child is there under these 2 accounts)
300 is the sub parent( i.e it has 3 child account 301,302,303)
This is how i defined child ranges for account 1000 using define child ranges button
From To Include
100 100 Child Value Only
200 200 Child Value Only
300 300 Child Value Only
Saved and compiled the value set hierarchy program..Result: Completed Normal
Now my question is when i click the view Hierarchies button
i am able to see only values
100
200
but not 300
So my question is can we give the sub parent(300) as child value Only?
My expected result in View Hierarchies form is
100
200
301
302
303
please help me..
becoz when i use this query to fetch the results
select ffvc.parent_flex_value,ffvc.flex_value
from
fnd_flex_value_children_v ffvc
where
ffvc.summary_flag='N'
AND ffvc.flex_value_set_id=1078923(IVB_ACCOUNT value set id)
START WITH ffvc.parent_flex_value=1000
CONNECT BY PRIOR ffvc.flex_value=ffvc.parent_flex_value;
Result i am getting is
parent_flex_value ffvc.flex_value
1000 100
1000 200
but expected is
parent_flex_value ffvc.flex_value
1000 100
1000 200
300 301
300 302
300 303
But when i run FSG reports i am getting the result perfect but in custom reports i am not getting  please help me
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
