help in gl report

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
sors
Posts: 5
Joined: Wed Jan 14, 2009 7:11 am
Location: Egypt

help in gl report

Post 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
hiszaki
Posts: 482
Joined: Thu May 10, 2007 9:03 am
Location: Egypt

Post 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
sors
Posts: 5
Joined: Wed Jan 14, 2009 7:11 am
Location: Egypt

Post by sors »

what is fsg tool
please i wait your reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Here is FSG example,

topic.asp?TOPIC_ID=3708
sors
Posts: 5
Joined: Wed Jan 14, 2009 7:11 am
Location: Egypt

Post 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
hiszaki
Posts: 482
Joined: Thu May 10, 2007 9:03 am
Location: Egypt

Post 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
sors
Posts: 5
Joined: Wed Jan 14, 2009 7:11 am
Location: Egypt

Post by sors »

i know all that steps but i want to know how get account description from db tables
qadeer
Posts: 2
Joined: Thu Dec 06, 2007 4:46 am
Location: Pakistan

Post 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/
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest