FSG Concurrent Managers
From: Marzieh Hariri [mailto:mhariri@russelmetals.com]
Sent: Monday, June 07, 1999 1:16 PM
Subject: FSG Concurrent Manager
Every month end when our users are running FSG's our system slows down
and reports that usually take 1 hour takes 4 hour(Many are run at the
same time)
We have dedicated a FSG cc manager to FSG's it has helped a bit,but
still very slow.
We have done everything to optimize the fsg run (using summary
templates,schedulling fsg's....) .
Can someone tell me if it makes a difference to have 2 ccmanagers for
fsg with less processes.(I am testing it right now) Just checking to see
if someone has experimented or found a way to speed up these reports by
playing around with cc managers definitions (# of processes,workshifts
etc) any pro's and con's..
We are on 10.7 16.1sc our fsg cc manager is set at 8 processes and using
only one primary node.
Thanx for your thoughts in advance.
--
Marzieh Hariri
Senior Oracle Support Analyst
Russel Metals Inc.
(905) 819-7295x5005
Mhariri@russelmetals.com
From: Logan, Ernie Ernie_Logan@bmc.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Sent: Monday, June 07, 1999 7:34 PM
Subject: RE: FSG Concurrent Manager
I would recommend far fewer processes, unless you have at least 16 CPU's
on
your concurrent server. We have found that 1 FSG equals one CPU at 100% of
capacity. Therefore, it is best, IMHO, to allocate no more than 33 - 50 %
of
your server to FSG reporting. Depending on your workload (24x7, 8x5, etc.)
it might make sense to limit them to off hours only. I unfortunately have
no
off hours as Oracle Financials is global and 24x7 here.
Date: Mon, 7 Jun 1999 21:19:59 +0100
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
Subject: Re: FSG Concurrent Manager
My experiences match those of Ernie's. FSG's take up a lot of CPU,
effectively each FSG running will take up 100% of a CPU. Having a separate
FSG CC will prevent the FSGs from holding up other jobs in the queue but the
FSGs will still have an impact on system performance. The only way to
minimise this impact is to reduce the number of FSGs that can run
concurrently by reducing the number of processes your FSG CC has. You have
to make a decision about how much system resource can be taken by the FSGs -
the more you give to FSGs the more your online users and other concurrent
jobs will suffer, whereas, conversely, if you don't give enough CPU time to
the FSGs it will take an age to complete all of them.
Jonathan.
Date: Mon, 7 Jun 1999 16:54:05 -0500
From: "Gregg Ney (s)" gney@cap.org
Subject: RE: FSG Concurrent Manager
I have heard rumors of FSG patches to resolve this issue. I'm trying to
find the numbers. If I do, I'll post them here. Meantime, someone at OWWS
might actually know...
Date: Mon, 7 Jun 1999 17:10:52 -0500
From: "Shockey, David" DShockey@jwrinc.com
Subject: RE: FSG Concurrent Manager
I vaguely remember once being told that you can get better performance
from an FSG if you swipe the SQL code after running the FSG and then
make it a SQL report. I haven't tried it so I don't know for sure. It
may not work for very complex reports.
Has anyone else on the list given this a try?
Date: Tue, 8 Jun 1999 11:44:17 -0500
From: "Landa, Mark (c)" U25MIBG@Carlson.com
Subject: RE: FSG Concurrent Manager
We have applied and tested all the available (that I am aware of) FSG
patches on r10.7/p16.1 sc. We are seeing a 5% decrease in run times on
average for the FSGs we tested. Not a big difference but better than
nothing. Also, Ernie's estimate of 100% CPU per FSG is in the ballpark and
is what we use as a guideline in determining the maximum number of allowable
concurrent FSG processes (we have a separate FSG conc mgr). The FSG patches
for 10.7/p16.1 sc that we have applied are:
FSG Server Patches 769674, 776469, 812518, 878390
FSG Client Patch 765115 (You may want to verify this)
Date: Fri, 11 Jun 1999 10:03:29 -0400
From: "Marzieh Hariri" mhariri@russelmetals.com
Subject: Re: FSG Concurrent Manager
Thank you all for taking time and sharing your experiences with us.
Further testing on our system showed that indeed 8 processes for cc manager
extends the time fsg are run but overall they all finished faster.
By setting more processes we are giving a chance to more fsgs to be serviced .
With less processes each fsg took less to complete but took longer for all to
finish.
I think our main server is too crowded (too many applications running on it).
We are thinking of redirecting fsg's to run on another node with less traffic.
Also schedule long Fsg's to run after hours.
Another thing ,we are asking our users if they find there is a problem with
their reports instead of submitting the complete report use segment override and
run the report for branches that have a problem.
Thanx again.
Detail Report vs Summary Report
From: Prasanna Ramam [SMTP:sukkuv@yahoo.com]
Sent: Wednesday, June 09, 1999 8:39 AM
Subject: FSG's Error in Dtl report vs summary report.
Hi All,
We have some problem in the FSG's report of a Detail report.. Can any
one pls explain me as how to solve this issue !
Problem Desc:
1. One report set contains four sub reports
2. One report gives summary of "Each department" and it is printing
correctly
3. One report gives detailed information of each department a/c wise..
This report is wrong ..at column 2 .
4. Reports contains 5 columns .. and there is error in second column
values ( at only some places )
5. The error report is using row set as "Total Operating" and Column
set as "Expense Analysis" , and content set as "515-Department" !
6. The columns are "last year actual", this year actual, budget,
ytdlast yearactual, ytdthisyearactual,
budget , variance
How should I solve the issue ! the totals of dtl report must be equal
to totals of summary report.. this happening fine for all remaining
columns except second column i.e "this year actual"
Thanks in Advance
Prasanna Ramam
Date: Thu, 10 Jun 1999 09:38:02 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
Subject: RE: FSG's Error in Dtl report vs summary report.
Prasanna,
If 'Total Operating Row is calculated row
- check the calculations
- check whether all the rows are picked (the users would have added
some AFF ranges in Summary and omitted to add in the detailed report's row
set)
- if any non-displayed row is part of you calculation see whether
they are right( display them and print to check)
- check whether the row set's Account Assignment Activity
(Net,Dr,Cr) is same as in the summary row set
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
Date: Fri, 11 Jun 1999 06:46:45 -0700 (PDT)
From: Prasanna Ramam sukkuv@yahoo.com
Subject: RE: FSG's Error in Dtl report vs summary report.
Thanx for the information ! I have checked the column set .. bcos its
giving wrong values only in one column out of 7 columns ! Whatz missing
is the "currency code" , when I put the currency code its working fine
!
Anyway thanx for your information.
Rgds
Prasanna
FSG Performance downgrade
Date: Mon, 5 Jul 1999 18:28:48 -0600
From: Brian Crowley brian.crowley@arcorsys.com
Subject: FSG Performance Degrade-Help!!!!!
My end-user recently added 500 new GL code combinations that are not yet
in use. Also, they entered 50 new hierarchies. Since then performance
had degraded significantly, specifically the month-end FSG processing.
Any ideas on how to remedy the situation?
Date: Tue, 6 Jul 1999 09:21:02 -0400
From: "Farber, Andy" farban@consumer.org
Subject: RE: FSG Performance Degrade-Help!!!!!
Try running the GL Optimizer.
We had terrible performance after extending our budget into the next fiscal
year, from May '99 to May '00, running the GL Optimizer cut running time
from 4 minutes to 1 minute on the test FSG, and from several days (!) to 12
hours for the entire suite of reports.
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531
mailto:farban@consumer.org
FSG Report from two SOBs
Date: Tue, 6 Jul 1999 13:26:49 +0200
From: "Kumar, Deepika (CAP, GCF)" Deepika.Kumar2@gecapital.com
Subject: RE: ORAAPPS-L digest 3378
Hello All
I saw a posting here a few days back saying that an FSG report can be run to
get data from two sets of books eg: from the Primary and Reporting set of
books both. Can you let me know how?
Thanks
Date: Tue, 6 Jul 1999 15:30:35 +0200
From: "Firake, Vinay (CAP, GCF)" Vinay.Firake@gecapital.com
Subject: RE: ORAAPPS-L digest 3378
Hi Deepika,
Use the 'SET OF BOOKS' field in your Column Set definition to specify the
SOB for which you need the balances.
Also, don't forget to mention the Currency of your Repo SOB in the Currency
column.
And presto..., you have it.
I just don't know how security across the SOBs is handled.
Does anyone have any idea?
TIA
Calculation problem
Date: Tue, 6 Jul 1999 10:39:52 -0500
From: "Thomas Wieczorek (s)" twieczo@cap.org
Subject: FSG calculation question
I am having a problem creating a calculation on a report. Here is the
scenario I have a description column, column A with YTD Actual numbers and
column B with YTD Budget numbers. I want column C to show the Percent that
the actual (A) is over or under budget (B).
I must be doing something wrong, but I need some help. Every line in the
calculation column show up as N/A.
Thanks for your help.
Date: Tue, 06 Jul 1999 12:05:50 -0400
From: Joel Smith jsmith@mail.pridehealth.com
Subject: Re: FSG calculation question
Thomas,
My First response would be to make sure there is a value in your (B)budget
part of your formula that is not equal to 0. Any number Divided by 0 = N/A..
If iit is the case where you have figures other than 0 in your budget. Than
make sure in the ColumnSet definition, in your Balance Control Amount type you
choose YTD-Variance%.
Date: Tue, 6 Jul 1999 11:20:22 -0500
From: "Thomas Wieczorek (s)" twieczo@cap.org
Subject: RE: FSG calculation question
A few of my budget line are equal to zero, only about 1 in 10. My Balance
Control Amount ins YTD-Variance. Maybe my formula is wrong. Can you help
me by suggesting how my formula should read?
Thanks
Date: 7 Jul 99 08:32:32 IST
From: Sharath C sharath.c@usa.net
Subject: Re: [ORAAPPS-L digest 3380]
HiThomas,
Incase this suggestion might help you , just give the factor as
percentiles in the column C of the column set. Can u tell the formula u are
using....then probably can figure out the problem
cheers
Sharath
Date: Thu, 08 Jul 1999 05:27:35 0000
From: "rameshkumar av" av@mailcity.com
Subject: Re: Reply FSG calculation question
a value for control value field in the column set has to be given and this
has to be referred in the
define financial report for the budget.
Tuning FSG for improved performance
Date: Tue, 13 Jul 1999 10:31:28 -0600
From: "Snyder, Stephanie" Snyder.Stephanie@tci.com
Subject: GL: FSG Performance Problems
We are currently experiencing problems with the performance of our FSG
report sets - the length of time for completion is unacceptable. We have
been running the GL Optimizer on a regular basis using the options gather
statistics and rebuild indexes. I am not very familiar with how FSGs work -
Can anyone offer advice on where to start to speed up performance? And, Yes
our GL_CODE_COMBINATIONS and GL_BALANCES tables are HUGE - but purging is
not in the near future.
Thanks!
Date: Tue, 13 Jul 1999 11:40:06 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: FSG Performance Problems
There are specific performance patches available from WWS for FSGs. Some of
them are actually quite helpful. Have you run that route yet?
Date: Tue, 13 Jul 1999 10:53:40 -0600
From: "Snyder, Stephanie" Snyder.Stephanie@tci.com
Subject: RE: FSG Performance Problems
We have applied all but two FSG performance patches. These are in the queue
to be applied - PATCH #812518 and #851361. Is there anything else I should
be researching in the meantime?
Date: Tue, 13 Jul 1999 12:16:10 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: FSG Performance Problems
The only other thing I would mention is that you don't normally rebuild the
indexes regularly. That is a one-time process, to my knowledge. We only
'gather statistics' regularly.
As to specific patch numbers, I can't help. They vary by applications
version.
Using +/- signs for variances
Date: Tue, 13 Jul 1999 16:36:00 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: FSG: Variance columns calculation
Hello all,
I'm wondering if anyone has come up with a solution to the
following problem in developing FSG's:
When comparing budgets to actuals, if your revenue exceeds
budgets, that's good. If expenses exceed budget, that's bad.
To show a bad thing, we typically use brackets. However, in
my column set, because the YTD-Variance uses budget
minus actual, my good revenue variances show as negative
numbers, when I want them to show as positive numbers. If I
reverse the sign in the column definition, then the good
revenue variance show as positive numbers, but the bad
expense variance also show as positive numbers, which I
definitely do not want.
Has anyone ever found a way to change the sign for
variances on just their revenue rows, and not on the
expenditure rows? I'd appreciate any suggestions, no matter
how ugly or cumbersome they might be.
Thanks,
Ken Heckbert
Holland College
kheckbert@hollandc.pe.ca
Date: Wed, 14 Jul 1999 09:48:54 -0400
From: "Kurylo, Mary" Kuryma@consumer.org mailto:Kuryma@consumer.org
Subject: RE: FSG: Variance columns calculation
In your YTD-Variance column don't use any calculations or flexfield
assignments. Leave the 'Change sign' fields 'No'.
In your row set definition for your revenue lines set both 'Change sign' and
'Change sign on Variance' to 'YES'. For the expense lines
set both 'Change sign' and 'Change sign on Variance' to 'NO'.
That should work.
Date: Wed, 14 Jul 1999 13:57:04 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: ORAAPPS-L digest 3420 -Reply
Hi Mary,
You're right - that does work. Unfortunately, I'm trying to
show the variance between budgets and
actuals+encumbrances. Therefore, I have to use a
calculation, and that's where I'm running into the problem. I
even tried creating hidden columns for the variance and the
encumbrances, and then adding them together in a displayed
column, but that doesn't work either. For some reason, the
FSG program will not change the sign in a calculated
column.
Thanks for you help,
Ken
Date: Thu, 22 Jul 1999 14:29:49 +0100
From: "Grist, Fergal" Fergal.Grist@ncp.co.uk
Subject: RE: FSG: Variance columns calculation
Hi Ken
We've had some success in the area you're inquiring about
by using hidden columns (if I understand your problem
correctly).
The true solution to your problem would be for Oracle to
create an option: 'CHANGE SIGN ON CALCULATION' similar
to the option: 'CHANGE SIGN ON VARIANCE'. However, in
its absence, a messy combination of hidden columns will
probably meet your requirements.
In summary, create the following hidden standard columns:
YTD-Actual, YTD-Budget and YTD-Variance%. Also create a
hidden, manually calculated, variance % column :
(budget-actual)*100/budget. By selecting certain rows
to 'CHANGE SIGN ON VARIANCE', there will be a difference
of sign between the Oracle calculated variance and the
manually calculated variance.
The key to resolving your problem is to exploit the
difference in sign to alter the sign of your manually
calculated budget and actuals+encumbrances variance.
The above description is only a brief overview. I
don't really have much time at the moment to go into
a more detailed description. However, if you're still
having difficulty in this area, maybe the simplest
solution would be to give me a call - I could talk
you through it quicker than providing a written
description. Email me if you want to take this
approach.
Regards
Fergal Grist.
Date: Thu, 22 Jul 1999 13:22:47 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: RE: FSG: Variance columns calculation -Reply
Fergal, and Mary and everyone else,
I really appreciate all the help everyone gave me on this
problem. Using some of the ideas here, and some that I
gleaned from the Oracle bug database, I was finally able to
come up with a solution. What I had to do was:
In the row set definition for the expenses, I actually used a -
sign instead of a + sign, which brought expenses in as a
negative number, so that both revenue and expenses were
negative numbers.
In the column set definition, for my budget and actual
columns, I set Change Sign to Yes. I left the Variance
column alone.
In my row set definition, for the grand total (revenue less
expenditures), I added the revenue and subtracted the
expense accounts. You don't normally have to do this since
revenues are usually credits and expenses are usually
debits, and you just add them together.
Finally, in the row set definition, for my revenue accounts, I
set Override Column Calculations to Yes, Change Sign to
Yes and Change Sign on Variance to Yes.
Seems like a lot of work, but at least my undesirable
variances all display brackets, and my desireable variances
have no brackets.
Ken Heckbert
How to suppress default Segment Name
Date: Wed, 21 Jul 1999 09:11:14 -0400 (EDT)
From: Balalji Sundaralingam CMCISSB@NJTRANSIT.STATE.NJ.US
Subject: FSG - How to suppress the Segment Name?
Hi FSG Guru's,
I am trying to display the Account Number and the description using the
RowOrder. Oracle displays the segment name by default on the report (
ie.,
segments that have a width greater than 0 in the Roworder definition).
Additionally using Column build, I am able to specify the column names,
which
also gets printed along with the default name.
How to suppress the default name ?
Thanks in Advance for any help.
Balaji
Date: Wed, 21 Jul 1999 09:12:49 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
Subject: RE: FSG - How to suppress the Segment Name?
There are options in the row order definition that let you choose number ,
segment description or both.
Date: Wed, 21 Jul 1999 09:23:52 -0400 (EDT)
From: Balalji Sundaralingam CMCISSB@NJTRANSIT.STATE.NJ.US
Subject: Re: FSG - How to suppress the Segment Name?
Thanks for the suggession, but my problem is only on the heading.
for ex:- the report looks like
ACCOUNT----DESCRIPTION----- OTHER COLUMNS ....
NUMBER
ACCTS
----------------------------------------------------------
I would like to knock of ACCTS display (which is my account segment that has
a
width of 50 with both value and description choosen). The report should
like :
ACCOUNT----DESCRIPTION----- OTHER COLUMNS ....
NUMBER
Date: Wed, 21 Jul 1999 09:49:04 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
Subject: RE: FSG - How to suppress the Segment Name?
Change the value on the row order to the lenght of the account value.
Date: Thu, 22 Jul 1999 10:30:04 +0500
From: fariha afreen fafreen@ora-tech.com
Subject: Re: FSG - How to suppress the Segment Name?
Through Row Order , u can define the width of 0 for the segment u want to
suppress
FSG prints only 6 cols
Date: Thu, 22 Jul 1999 14:16:21 IST
From: "seetha raman" seeethu@hotmail.com
Subject: FSG - PRINTING PROBLEM
Hi,
I have 13 COLs in the col set. The first col starts from 40th position and
10 each for each col.
In the printout I get only the first 6 COLs. But in the screen(the text
file) I get all of them.
Even if I give Landscape or Landwide in the other-request window( By running
'Program- Run Financial Statement Generator'), the printout shows only 6
COLs.
We are in 10.7SC
Thanks in advance for the help.
seetha
Date: Thu, 22 Jul 1999 09:10:52 -0400 (EDT)
From: Balalji Sundaralingam CMCISSB@NJTRANSIT.STATE.NJ.US
Subject: Re: FSG - PRINTING PROBLEM
Under help- Viewmyrequest - report option - you can choose
VIEW - FONT - SMALLEST. This would help you to shrink your report
considerably, but I am not too sure whether you would still be able to see
all
13 columns.
If you do come to know other solutions, please let me know.
Balaji
Date: Thu, 22 Jul 1999 07:16:59 PDT
From: "rashmi potdar" rashmipotdar@hotmail.com
Subject: Re: FSG - PRINTING PROBLEM
Hi All,
We had a similiar problem here. Actually anyone with System Administer
reponsibility can go the printer setting setup and map the smallest printer
fonts in there. In doing so one can get the smallest
fonts available and that will make the report output (all the necessary
columns) fit on the landscape size paper. Hope this helps.
Rashmi