ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
FINANCIAL STATEMENT GENERATOR

FSG Summary accounts

Date: Fri, 19 Mar 1999 10:32:30 -0800
From: Rama Krishna

Hi Sridhar, Did you recreate the Summary Template after this 77 started having the balances for the period in question. What is the parameter you set for this account assignment on the row set. I mean Total, Expand or Both which is set for this account assignment.

Is you parent 77 part of the rollup group "Total Cost" you made use of in the summary template.

Finally, try querying the balance for this d-d-d-Total Cost-d online and find out more on this. Rama

-----Original Message-----

From: Sridhar Vedala [mailto:vedala@yahoo.com]
Sent: Thursday, March 18, 1999 5:52 AM

Hi I have a query on FSG.

Accounts Set up

Account Roll up 77 Total Cost 7700 Cost 1 7710 Cost 2

Cost 1 and Cost 2 roll up to Total Cost.

In FSG the row set accounts are defined as

xx-xx-xx-77-xx and summary flag set to true and profile option of expand parent values set to yes.

The summary template is like d-d-d-total Cost-d

I am expecting this to give me the output as

xx-xx-xx-77-xx amount $xxx

xx-xx-xx-7700-xx xxxxx

and so on. But this is not giving any output in the report. Help! Vedala

Sort by Account

Date: Mon, 22 Mar 1999 07:13:24 -0800 (PST)
From: Sridhar Vedala
Subject: FSG: Sort by account

Hi The account structure is
company-costcenter-account
01-111-1500
01-111-2000
01-222-1600
01-222-1700
But in the FSG repost I want the output to be
01-111-1500
01-222-1600
01-222-1700
01-222-2000
i.e sorting by account. In Fsg I could do this if I change the sequence to
Account-Company-Costcenter
But I want the display to same as before i.e
Conpany-Costcenter-account
but the sorting should be by account segment. How can this be achieved??? Thanks Vedala

Date: Mon, 22 Mar 1999 09:20:43 -0600
From: "Kanakam, Venkat (c)"
Subject: RE: Sort by account

Hi Your requirement can not be achieved in FSG.
In FSG, the sorting order always follows account segment display order in roworder definition. HTH Venkat Kanakam Consultant CIBER, Inc.

Format Mask

From: Roger Drolet[SMTP:rdrolet@netscape.net]
Sent: Tuesday, March 23, 1999 11:06 AM
Subject: FSG Reports - Format Mask

I developed several FSG reports and I have defined row sets and column sets using a format mask of 999,999,999.99 and I still can't generate comas with every number.

Has anyone found a way to ensure that all numbers print with comas? If so, please tell me what I might be doing wrong.

Roger Drolet Managing Associate Conley, Canitano & Assoc., Inc.

Date: Tue, 23 Mar 1999 13:47:02 -0600
From: "Kanakam, Venkat (c)" vkanakam@Carlson.com
Subject: RE: [RE: FSG Reports - Format Mask]

Hi, If you specify format mask as 999,999,999.99 then you column width shoud be atleast 16 to take care of ( ) for negative numbers. Is your width more than this and still not printing commas correctly?

Set the profile option "Currency:Thousands seperator" YES.
Do you have any observation that you get this problem only for calculated rows and not rows with account assignments?

HTH Venkat Kanakam Consultant CIBER, Inc.

From: Roger Drolet [SMTP:rdrolet@netscape.net]
Sent: Tuesday, March 23, 1999 12:30 PM
Subject: Re: [RE: FSG Reports - Format Mask]

Yes, the columns are wide enough, however, some numbers print without com as while most print with comas.

Roger

FSG Printing Problem

Date: Mon, 29 Mar 1999 12:07:14 -0600
From: Nancy Gaudette nancy.gaudette@esoftsolutions.com
Subject: Re: FSG Printing Problem

Nicole, The column set for this report is requiring 255 characters across the page. If the individual column widths cannot be adjusted, perhaps the column set itself can be split, otherwise you will need to create a special printer driver. You should still be able to view the report online, and you could also import the text file into a spreadsheet.

Nancy Gaudette www.esoftsolutions.com

Date: Fri, 26 Mar 1999 14:13:29 -0800
From: Nichole Lewis nlewis@fmt.com
Subject: FSG Printing Problem

I'm having a problem printing FSG reports. The user is running the FSG reports by submitting request 'Program - Run Financial Statement Generator'. I'm receiving the message: This request finished with a warning and produced the following completion message: APP-01243 &ROUTINE cannot print the output file for your concurrent request &REQUEST .

Failed to get print style with dimensions f:
columns 255
rows 1 to 66
for printer: \\utility\ishp5si
I'm using a HPLJ5SI printer on Windows NT. I'm able to print all other reports OK.
Do I need to setup a special driver or style to print FSG reports?

x-------------x

Date: Wed, 7 Apr 1999 10:22:12 -0700
From: Lynn Eckert LynnEckert@FairIsaac.com
Subject: RE: FSG Print Problems

There was an FSG patch that needed to be applied when we upgraded to 10.7 Character. Have you applied this patch? It fixed the Column Heading field; extra spaces were being added in the format line. Oracle Support should have the latest patch number, I know that it has changed since we upgraded last July.

*******************************************************************
Lynn Eckert Fair, Isaac and Company Inc. Financial Information Systems

FSG Tranfer to new database

From: server@ibm6000.cpa.qc.ca [mailto:server@ibm6000.cpa.qc.ca]
OnBehalf Of Bill Keenan
Sent: Tuesday, April 06, 1999 4:06 PM
Subject: FSG Tranfer to new database

Hi,
I am upgrading the G/L from v.10.7SC to 11.0, and will need to move the FSG components over from the 10.7SC database (7.3.4) to the 11.0 database (8.0.5). There is a standard report in the GL 11.0 called "Program: FSG Transfer". I was wondering if it is possible to copy over the FSG reports this way? If not, is there any automated way to do this. Some of the columnsets and rowsets are quite complex and large, and the last thing I want to do is manually re-create them on 11.0.

Once again, any help is greatly appreciated.
Bill Keenan

Date: Tue, 6 Apr 1999 17:33:56 -0400
From: "Joe Maliszewski" jmaliszewski@csi.com
Subject: RE: FSG Transfer to new database

Bill,
You left some things out of your question.
Why are you not upgrading the 10.7 DB instead of what sounds like a fresh install? This would eliminate the problem, and a whole host of additional problems.

The FSG Transfer program works great, but the AFF must be exactly the same. Exactly! Plus it only works one way. I cannot see how it would work from 10.7 to 11. The transfer program would have to reside on the source side of the Apps (In your case 10.7).

Fill us in if you have more info.
Cheers, Joe Maliszewski Consultant jmaliszewski@csi.com

Date: Tue, 6 Apr 1999 18:52:03 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Re: FSG Transfer to new database

Hi Joe,
The reason we are doing a "fresh" install, as apposed to a simple upgrade, is that we needed/wanted to change some of the setup in the apps (one being GL Calendar). We changed the calendar, and a few other minor items, nothing that would effect the FSG components, AFF, or AFF values. 10.7SC has the GL standard report "Program: FSG Transfer", and that is my source database. So, is it possible to run this report and somehow have the data transfer from the 10.7DB to the 11.0DB???

Thanks again for your help. Bill Keenan

Date: Wed, 7 Apr 1999 09:30:10 -0400
From: "Joe Maliszewski" jmaliszewski@csi.com
Subject: RE: FSG Transfer to new database

Yes, You can. You need to have your DBA set up a DB link. The rest is pretty self explanatory.

Joe Maliszewski Consultant jmaliszewski@csi.com

Date: Wed, 07 Apr 1999 10:30:53 -0500
From: Nancy Gaudette nancy.gaudette@esoftsolutions.com
Subject: Re: FSG Tranfer to new database

Bill, Have you considered converting your data to a new 10.7 instance with the new GL calendar, etc, then upgrading this instance to release 11? It increases the likelihood that the FSG transfer program would work properly if the source and target instances are both of the same release of the apps and RDBMS version.

Nancy Gaudette www.esoftsolutions.com

FSG through Standard Report submission screen

"Sridhar Goteti" wrote:
Hello FSG Gurus,
I have three questions for now.
1) Is it possible to pass parameters to reports created by FSG's other than Period and Currency? If so how?

2) When u create a FSG by a row set and a column set is it automatically creasting code in Reports 2.5 format? If so can we use that code to modify the report?

3) Are any of the standard reports in GL developed by FSG's?

Thanks for ur help, Mark

Dinesh Chandra wrote:
Hi,
FSG Reports are not normal Reports 2.5 reports. For these we define Row Set and Column Set and based on condition defined for Accounting Flex Fields in Row Set and Column Set, a SQL is generated and temporary data is stored in a table from where it is selected and presented in the user requested format.

The Row Set/Column Set and other definitions are stored in APPS tables.

Standard Reports are in Report 2.5 or SQL*Plus.

FSG Reports are not available to be submitted through 'Submit Report' Form.

Cheers Dinesh Chandra

Date: Wed, 14 Apr 1999 19:06:50 +0800
From: Rhys Arnold rhysa@pacific.net.sg
Subject: Re: FSG in GL

Hi Dinesh/Mark,

You can submit FSGs through the standard report submission screen by adding the

Financial Statement Generator program to the GL Concurrent Program Report Security Group.

Based on Rel 10.7....
1] Login as System Administrator
2] Navigate to the Report Security Group Form
3] Query up the "GL All Concurrent Programs" report security group (I cant remember the name exactly) .
4] Add a new row for the "Program" called "Program - Run Financial Statement Generator" and save your new row.
5] Then change to your GL responsibility and submit a request under "Program - Run Financial Statement Generator"
(you will find that you can select the FSG name and other FSG parameters etc as the request parameters)

The big advantage of this are that users can select number of copies, the printer name etc which they cannot do on the FSG form (at least in Rel 10.7, I am not sure about Rel 11). They can also use the scheduling features and set-up report sets (although you can do the latter with FSGs anyway).

Regards, Rhys Arnold rhysa@pacific.net.sg

Date: 14 Apr 99 15:19:29 EDT
From: Dinesh Chandra dchandra@usa.net
Subject: Re: FSG in GL - Tech

Hi Arnold,
Thanks a lot. This thought never came to my mind. Though, it appears quite possible to define RGRARG - FSG Reports through standard report, but, technically, I may not agree with you.

Standard reports are submitted through FNDRSRUN forms which calls FNDRSSUB, an immediate, program linked to Concurrent Manager FNDLIBR and report is submitted.

RGRARG - Financial Statement generator is PRO*C program and is submitted RGXGRRST form which is compatible with RGRARG parameters. This forms takes parameter inputs like Report Name and breaks this input into multiple inputs like Row Set, Column Set, Order Set and others, formats these inputs and passes to FNDRSSUB and then RGRARG. The feedback from this is Request Id which is displayed on the screen of RGXGRRST form.

Using your procedure, defining parameters on parameter zone will be very difficult.

Cheers Dinesh Chandra Work - 516 231 2609

Stack underflow

Date: Thu, 15 Apr 1999 10:03:54 -0400
From: Rollin_R._Ross@FirstEnergyCorp.com
Subject: FSG: Stack Underflow message

We set up a new column set. When a report is run using it we get a Stack Underflow on every line of the 2 right most columns in this set of 4 columns. How do we get the column set data that we want to appear in place of this error ? Our column sets are PTD-actuals for Jan. Feb. March and QTD-actuals for Quarter to Date.

Data for the 2 left most columns of Jan and Feb appear but the 2 right most columns contain only Stack Underflow in place of data for what we thought would have been March and Quarter to Date. What is Stack Underflow telling us and how do we correct it ?

From: Nancy Gaudette nancy.gaudette@esoftsolutions.com
Sent: Thu, 15 Apr 1999 11:51:18 -0400 (EDT)
Subject: Re: FSG: Stack Underflow message

Rollin,
For what period did you request the FSG report? What offset number did you use for the March and QTD columns? If the number is greater than zero, and the future period has not been defined in the calendar, it could cause this error.

Nancy Gaudette www.esoftsolutions.com

Date: Thu, 15 Apr 1999 20:42:25 -0400
From: "Juan Camara" camarj@erpcentral.zzn.com
Subject: Re: Re: FSG: Stack Underflow message

From my experience, I have usually found out that the Stack Underflow me ssage has been linked with either an erroneous calculation (such as not being able to round off because of size of the decimal).

Other times we have also encountered that the parent-child relationship on those specific accounts may not be computing the amounts correctly.

To fix it I have usually reviewed and re-entered the calculation and/or the accounts associated with those lines - though I must also admit this method has not always worked

- jc

FSG to display description of only the Natural Account Segment

I want my FSG reports to have only the Natural Account Segment Descriptions. I am trying to achieve this by attaching a ROW ORDER to the report. But this is not solving the problem and I am getting the heading for all segments and I am getting the segment value for account segment. Can anybody help me with this. Thanks in advance

From: Rajendra Gutta CMCIRPG@njtransit.state.nj.us
Subject: Re: Re:FSG
Date: Mon, 19 Apr 1999 16:17:43 -0400 (EDT)

In the row order screen give the other segments also with sequence #,but with width being 0.Then the other segments/headings would not be displayed. Raj.

Hi Rajendra,
Thanks. The solution given by you(stated below) works. However the heading for the balancing segment still appears like:

Company-------------PTD-Actual
........

Can I remove this too. Further is there a way to remove system generated messages on top like "No specific Account requested".

Thanks and regards

Date: Tue, 20 Apr 1999 08:41:53 -0400 (EDT)
From: Rajendra Gutta CMCIRPG@njtransit.state.nj.us
Subject: Re: Re:FSG

Hi Sunil,
You could play around with the headings by the icons (build column set,default column headings) on the define column set screen,but i dont think you could really modify the system generated headings,let us know if you find a way for that,since i also have a identical requirement.

Thanks Raj.

Calculating averages

From: fierosrcul@yahoo.com [SMTP:fierosrcul@yahoo.com]
Sent: Thursday, May 13, 1999 7:45 AM
Subject: GL: FSG Reports (how do I calculate AVERAGE)

I'm new to FSG Reporting in 10.7 and would like to calculate various montly / quarterly and YTD averages.

Is there a way that the average can be automatically calculated without me manually changing the denominator each month?? For example: In April the YTD average should take the YTD total and divide it by 4, however in May the YTD Total should be divided by 5.

I'd like to automate this so the user doesnt have to monkey with the FSG definition.

Thanks

From: Kanakam, Venkat (c) [SMTP:vkanakam@Carlson.com]
Sent: Thursday, May 13, 1999 9:27 AM
Subject: RE: FSG Reports (how do I calculate AVERAGE)

I had a similiar requirement earlier. But it is not possible in a straight way. Finally we have to drop such calculations in FSG.

Date: Thu, 13 May 1999 11:24:07 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
Subject: RE: FSG Reports (how do I calculate AVERAGE)

Can do this thro' GLDI, of course user has to make corrections in Excel or you can write a macro. For one of our clients for a "12 months trailing report without adjustment period", we created one column set for Jan and copied 11 times ( means you will have 12 column sets).

Thanks Ravi Jagannathan (MIS) Tel : (305) 816 4831