Page 1 of 1
help in gl report
Posted: Tue Feb 02, 2010 8:41 am
by sors
i want to make report
to get gl oaccount(segment and description)
like that
1.0000.101.200
company.dept.cc
and so on
Posted: Wed Feb 03, 2010 3:53 am
by hiszaki
Hi sors
The best way to make a report for GL accounts by using FSG tools. it's very easy & useful to generate any reports in the GL module according to your request.
Thanks
Hisham
Posted: Wed Feb 03, 2010 4:50 am
by sors
what is fsg tool
please i wait your reply
Posted: Wed Feb 03, 2010 6:15 am
by admin
Posted: Wed Feb 03, 2010 6:56 am
by sors
thanks for your reply but if i want to make acustom report
and i want to see account description what asuitable query for that
Posted: Mon Feb 08, 2010 3:49 am
by hiszaki
Hi sors
If you want to make a custom report, you can design, build & put it on oracle application by using oracle report builder then put it on oracle application through some steps.
Thanks
Hisham
Posted: Tue Feb 09, 2010 5:42 am
by sors
i know all that steps but i want to know how get account description from db tables
Posted: Wed Feb 17, 2010 3:37 am
by qadeer
hi sors,
select gcc.segment1||'.'||gcc.segment2||'.'||gcc.segment3||'.'||gcc.segment4||'.'||gcc.segment5 Account_Code,
f1.DESCRIPTION||'.'|| f2.DESCRIPTION||'.'|| f2.DESCRIPTION||'.'|| f3.DESCRIPTION||'.'|| f4.DESCRIPTION Account_desc
from
fnd_flex_values_vl f1,
fnd_flex_values_vl f2,
fnd_flex_values_vl f3,
fnd_flex_values_vl f4,
fnd_flex_values_vl f5,
gl_code_combinations gcc
where
f1.flex_value=gcc.segment1 and f2.flex_value=gcc.segment2
and f3.flex_value=gcc.segment3 and f4.flex_value=gcc.segment4
and f5.flex_value=gcc.segment5
and f1.flex_value_set_id=1010882 and f2.flex_value_set_id=1011029
and f3.flex_value_set_id=1010883 and f4.flex_value_set_id=1010881
and f5.flex_value_set_id=1010884
replace "flex_value_set_id" as per your chart of account.
hope this help you
also visit
http://www.notesbit.com/index.php/oracl ... formation/