Home » Applications » Oracle Fusion Apps & E-Business Suite » Parent Child Values in GL Accounting Segment (Oracle E-Business Suite R12)
icon5.gif  Parent Child Values in GL Accounting Segment [message #529855] Thu, 03 November 2011 07:06 Go to next message
vinkum
Messages: 19
Registered: October 2011
Location: India
Junior Member

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 Sad please help me
Re: Parent Child Values in GL Accounting Segment [message #529856 is a reply to message #529855] Thu, 03 November 2011 07:13 Go to previous message
vinkum
Messages: 19
Registered: October 2011
Location: India
Junior Member

The Above Hierarchy is not clear sorry this is my first post in this forum
1000
100 200 300
301 302 303

This is the hierarchy i tried to explain above.
Previous Topic: How to split the accounting entries of the invoice in AR
Next Topic: Change of Account Name
Goto Forum:
  


Current Time: Thu Mar 28 17:21:31 CDT 2024