FSG Report Submission
Date: Tue, 3 Aug 1999 12:19:23 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: GL: FSG Report Submission
The Oracle General Ledger users manual discusses the
ability to run FSG reports from the STANDARD report
submission window, however I can't seem to find the
appropriate place to set this up.
I've tried to create a Report SET, however only
standard reports and programs are available to be
added to the set, I dont see FSG's to choose from.
Also tried modifying the Request Group, but again,
dont see the place to add FSG's to the list.
Can someone point me in the right direction.
Thanks
Date: Tue, 03 Aug 1999 14:33:14 -0500
From: "Sue Lynch" SuEL@wma.clarkshoe.com
Subject: Re: GL: FSG Report Submission
To run FSG's from Report, requets , standard window, Select Program-Run
Financial Statement Generator and it should then give you a parameter box
where you can choose your desired FSG report and parameters.
Hope this helps.
Sue
Date: Tue, 03 Aug 1999 15:44:23 -0400
From: msudhir@answerthink.com (Manjapra Sudhir)
To: fierosrcul@yahoo.com
Subject: Re: GL: FSG Report Submission
Hi ,
To run FSG reports you have to add RGARG in the concurrent programs.
- SYS ADMIN Function
Also check if
Request - Group - GL Concurrent Program Group - SEE if Program Run FSG
exists in Orcale GL Apps. I am writing this from my notes. Hard for me to
test my notes out as I am not currently working ith GL. Hope this helps.
Bye
Date: Tue, 03 Aug 1999 15:49:48 -0400
From: msudhir@answerthink.com (Manjapra Sudhir)
To: msudhir@answerthink.com
Cc: fierosrcul@yahoo.com, oraapps-l@cpa.qc.ca
Subject: Re(2): GL: FSG Report Submission
Hi,
After you check the steps mentioned before. Go to the standard report
window and pick Run program FSG once you pick the run Program FSG this
will prompt you to all the FSG report that you have created. Hope this
helps. Bye.
Date: Tue, 3 Aug 1999 15:48:25 -0400
From: "Lau, Gabby" gLau@wssc.dst.md.us
Subject: RE: FSG Report Submission
In the submit request form, go to 'Program- run financial statement
generator'.
Gabby
Date: Tue, 3 Aug 1999 15:54:06 -0400
From: ralph ramnath rramnath@neal-and-massy.com
Subject: RE: GL: FSG Report Submission
In addition, sometimes the report group does not contain the 'Program Run
FSG'. You may have to go to SYS ADMIN and add it to the group.
Display only Negative Amounts
Date: Tue, 03 Aug 1999 11:47:56 -0400 (EDT)
From: Rajendra Gutta CMCIRPG@NJTRANSIT.STATE.NJ.US
Hi FSG Gurus
I have a requirement for displaying only the negative amounts in the FSG
report,ie hiding all the rows with positive amounts.Can anybody suggest a
solution for this situation.I know of a display row flag in the row set
definition,but is there a way i can display the exception condition meeting
rows only.
Thanks in anticipation.
Raj.
Date: Mon, 09 Aug 1999 14:47:02 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: FSG Exception reporting - Reply
You should be able to define an exception flag for this
condition, and then when you run the FSG, enter Yes in the
Exceptions field in the Runtime Options zone. This will print
only rows that meet the Exception condition you specified.
If there are many columns, and you want to test all of them
for negative amounts, you may have a hard time pulling this
off. You'll have to play with it a while.
Ken
Report on Grand Parents and Parents Only
Date: Tue, 17 Aug 1999 12:06:40 -0400 (EDT)
From: Rajendra Gutta CMCIRPG@NJTRANSIT.STATE.NJ.US
Hi FSG Gurus,
We have a requirement where we need to report on the Grand Parent and the
Parent Only with Totals,and no details on child segments.If we give the
'E'/'B'
option then it would report till the level of the child segments,We are not
implementing Summary Accounting.
eg : Grand Parents :10101,20101
Parents : 10110,20110
Childs : 10111...19999,20111...29999.
The report output would be:
10110 : Totals
20110 : Totals
10101 : Totals
20101 : Totals
Hope i am putting across the issue clearly.
Thanks in anticipation,for any help.
Raj.
Date: Tue, 17 Aug 1999 11:31:28 -0500
From: "Kanakam, Venkat (c)" vkanakam@Carlson.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Hi,
It is not possible to print values for intermediate parents below grand
parent in FSG. FSG always expands parent or grand parent to its detail level
ignoring whatever parents in between. To some extent this can be achieved by
Summary accounts. The only option is Reports 2.5.
HTH
Venkat Kanakam
Consultant
CIBER, Inc.
Date: Tue, 17 Aug 1999 15:59:03 -0400 (EDT)
From: Rajendra Gutta CMCIRPG@NJTRANSIT.STATE.NJ.US
To: oraapps-l oraapps-l@cpa.qc.ca
Thanks very much for the reply,we are now confirmed on this and working on
alternatives like developing a separate row set for each level of reporting
for
the same FSG and totalling by the Grand Parent/Parent.
Raj.
YTD Budget amounts not appearing
From: Ashok [mailto:kumar_a_s@yahoo.com]
Sent: 26 October 1999 09:26
To: Multiple recipients of list
Subject: FSG-YTD Budgets
Hi,
I am facing a problem in FSG reports. The year to date
budget amount is not appearing in the YTD column. I
have defined the amount type as YTD-Budget Full Year.
We have defined 13 month accounting period. Our budget
is also defined for 13 month but our client budgets
only for 12 periods. Hence we have put zero amounts in
the 13th month.
I have no idea why the YTD budgets do not appear in
the YTD column. The monthly budgets appear in the
report.
Can anyone help me.
Thanks in advance
Regards
Ashok
Date: Tue, 26 Oct 1999 12:39:06 +0200
From: Terence Osborne TerenceO2@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: FSG-YTD Budgets
Hi
We had the same problem. If you use the amount type - YTD Budget Full year ,
The budget need to include all 13 periods otherwise it won't pick up the
total column, and that is the figure you want to appear in your report.
What we did to correct this was the following.
1. Define a new budget that included all 13 periods
2. Use budget wizard to down load the budget into excell
3. Copied that information into the new budget and uploaded it
4. Changed the control value in the columnset in order to pick up the
new budget
The above sorted out our problem
Regards
T. Osborn
Date: Tue, 26 Oct 1999 07:53:44 -0500
From: "Tom F. Wieczorek" Tom.Wieczorek@kemperinsurance.com
To: oraapps-l@cpa.qc.ca
Subject: Re: FSG-YTD Budgets
Did you define the control value in you column and on your report?
Date: Wed, 27 Oct 1999 09:34:35 +1000
From: Paul_Thien@gecfa.com.au
To: oraapps-l@cpa.qc.ca
Subject: Re: FSG-YTD Budgets
You will not be able to get a budget for period 13. Try YTD for Period 12.
Ashok kumar_a_s@yahoo.com
Multicurrency reporting with all amounts in Functional Currency
Date: Sat, 30 Oct 1999 05:25:32 -0700 (PDT)
From: Sivakumar K sivamanj@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Need help on multi-currency
Hi
Can someone help me with this.
We have installed Oracle Apps Rel 11. GL module on NT.
The Set of books has Functional currency as USD.
If I enter two transactions on an account say Rent,
one with USD and other with a foreign currency.
When I run a report defined with FSG, the rent
account reports either USD value or foreign currency
value, but not total functional currency value.
Like
Curr Entered Converted(USD)
USD 1000
CAD 2000 1000
I would like to see the total USD 2000. In the column
set the amount type is selected as YTD-Actual.
Thanks in advance
Rgds
Sivakumar
Date: Tue, 2 Nov 1999 07:16:55 -0500
From: Steve Bradley sbradley@sprynet.com
To: "Oraaps List Server (E-mail)" oraapps-l@cpa.qc.ca
Subject: RE: Need help on multi-currency
What currency (if any) are you using in the row and column sets and report
definition? I ran the same test with no currency in row, column and report
definition, no control value and USD for the report request. I get the
correct USD functional amount.
If you want to see the translated CAD amount run the report with CAD in the
report request.
If you want to see entered CAD amount assign a control value to the row or
column set and define the control value in the report definition as CAD and
entered.
Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 503-218-9747
Pager 888-912-2569