Tuesday, July 24, 2007

Simple Tutorial for Publishing FSG Reports Using XML Publisher

This simple tutorial will show you how to create a custom FSG Report using XML Publisher.

1. Log in to Oracle Applications and select the "XML Publisher Administrator" responsibility (your Applications Administrator will have to grant access to this responsibility).

2. Navigate to the Templates page.

3. Type FSG% in the Name field and click "Go to query" for the standard FSG template supplied by Oracle.

4. Click the "FSG: Basic Template" item.

5. Click the Download icon and, when prompted, save the template (RGFSGXPG.rtf) to your local file system.

6. Using your local file explorer, navigate to the location where you saved the RGFSGXPG.rtf file. Open the template in Microsoft Word – typically you can just double-click the .rtf file.

7. Update the template to suit your needs. A typical task would be to add a logo. The next few steps show how this can be done.

8. Place your cursor in the left-most cell of the title table

9. On the MS Word standard menu, click Insert->Picture->From File.

10. Navigate to and select an image file (.bmp, .jpg, .gif, etc) containing your company logo to insert the image.

11. Save the personalized template with a new file name.

12. Navigate back to the Templates page and select the "Create Template" button.

13. Fill in the required fields similar to that shown in the following figure and click "Apply". Note that Type must be "RTF" and Data Definition must be "FSG program".

14. This template should now work with any existing FSG report.

15. Logon to Oracle Applications and select a responsibility that has access to run FSG reports such as General Ledger Super User.

16. Navigate to Requests and submit a new request.

17. Query on Name = "Program – Publish FSG Report"

18. Fill in the required parameter values and click OK. Note that the value for the Report parameter should be the name of the FSG report to be run. The value for Period is the desired period to be processed. Select the template that was created in the previous steps for the value of the Template field.

19. Submit the request and then query your requests to see the results. Notice that the Program – Publish FSG Report request has spawned 2 other requests. The first runs the selected FSG report to produce XML output. You can view and save the XML data by selecting the first spawned request and then clicking View Output. The second request processes the XML output with XML Publisher to produce the final report. You can view and save the final report by selecting the second spawned request and clicking "View Output". This entire process can also be scheduled using the standard technique for scheduling concurrent requests.

Your final report should now be neatly formatted and complete with your company logo!

Posted on behalf of:
Tim Sharpe | Solution Architect

21 comments:

Unknown said...

Hi,
This article is great. I have a question: custom template is added but how that template is called instead of standard template. Do we have to change any setups so that oracle will pick our custom template?

Please give me some update on this ASAP.
Thanks i appreciate your time.

Janet said...

nice documentation.

for Pavan... check out the XML Publisher documentation. its explains clearly what you are asking

Unknown said...

we are running on 11.5.10 with XML on 5.6.3.
I tried to run an FSG program creating a new template giving the output format as excel. The report runs fine but i cannot see the output in excel. The data opens in text format in a browser.

not sure if its an version problem or if its a bug

i appreciate ur help on this.

Ratnakar Mittal said...

great doc...will help many n many more...

Noel said...

I read the documentation and created FSG templates in Excel and then ran some reports. My question is about security. When an FSG is created for many facilities, will Publisher restrict the LOV for the facilities to just the one or ones the particular responsibility that is viewing has?

Sam33k said...

Everything was working fine till the time concurrent getting completed. 2nd program is getting error as follows:

Oracle XML Publisher 5.6.3
java.lang.NumberFormatException: For input string: "CUSTTEMP"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:468)
at java.lang.Integer.parseInt(Integer.java:518)
at oracle.apps.xdo.oa.cp.JCP4XMLPublisher.runProgram(JCP4XMLPublisher.java:214)
at oracle.apps.fnd.cp.request.Run.main(Run.java:161)


Any help will be appreciated.

Thanks

Anonymous said...

buy health insurance, car insurance quotes rolex fake 09.05.15T

Web Tasarım said...

Sorry my english firstly, i read well but i cant write :), So its useful post for me and i bookmarked your blog.

warez indir, oyun indir, dizi indir, program indir, photoshop indir

web tasarımpremium wordpress themesfotokopi, dijital cikis, ozalit, kirtasiyesesli chat

Unknown said...

Hey...... Thanks Buddy Its really a nice document.Its been really helpfull..

Anonymous said...

UGGs Knightsbridge Boots have various of advantages ugg size chart Fully Sheepskin Lined genuine sheepskin ugg.com offical site soft and insole naturally wicks away moisture to maintain us ugg.com dry and toasty feet.Rear multi-colored zipper provides ugg.com sale easy on/off and major style.ugg.com canada- Ugg Fashion; Read ugg.com us product reviews, or select the ugg.com shoes width, and color of the UGG Collection.

Сергей Лазарев said...

FDA approved mens health medication viagra is not a drug to be taken lighliy you should read all about the pros and cons regarding the medication before you buy viagra!

pedro velasquez said...

After a recent presentation I did within my company on XML Publishing in Oracle Apps,dominical costa rica tours a colleague popped up with this question: How do I integrate FSG report output with XMLP ? I didnt have the answer then since I dont have much experience with FSG reports, but I chanced upon the information below in one of the user guides. It shows that it is actually simple to publish FSG report output using XMLP templates!
http://www.dominicalcostaricatours.com

Unknown said...

I passionately trust that the information and facts presented is related to almost all people . Many thanks .
miami beach fl locksmith

Unknown said...

Hey very nice blog!! I am going to read it again and for that will bookmark this blog for future reference and take the feeds also...Keep writing...Highly Appreciate to you..Great Work!!!!

PropInve//
Buying Investment Property
Point Cook Real Estate

Çelik Kapı said...

great tutorials. Thank you so much for sharing. | yemek tarifi | konut | çelik kapı | çelik kapı | şöförlü araç kiralama | tercüme | seo | şömine |

Leonardo said...

Candida Yeast Infection precisely desired to say thanks again. I'm not certain the things Candida Cleanse could possibly have accomplished in the absence of the advice contributed by you about my area. Certainly was a alarming case for me, but being able to see a expert approach you dealt with it forced me to cry for contentment. Extremely grateful for the advice and believe you are aware of a powerful job that you're accomplishing educating many others all through a blog. I'm certain you've never come across all of us.

reena said...

Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.
USB Disk Security Free Download

Leonardo said...

And it's a question of how far we're willing to go in order to let the ego shine, in order to let that beacon penetrate not only the local scene but the world. Candida Cleanse Diet

saurabh said...

Thanks for your marvelous posting! I genuinely enjoyed reading it, you may be a great author.I will make certain to bookmark your blog and will come back in the future. I want to encourage that you continue your great posts, have a nice afternoon!
Hotels in Venice

Amit said...

Wonderful web-site, in which did you observed this details in this article? I am glad I found it. i am going to be checking out back soon to examine what other content articles you may have.
Spirulina India

Unknown said...

great thanks admin shares
Çelik Kapı şilte