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

48 comments:

pavan 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.

jang said...

nice documentation.

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

satish 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

dghnfgj said...

welcome to the wow gold, cheap WoW Power Leveling, service site,wotlk gold buy cheap wow gold,wow gold,world of warcraft power leveling buy wow gold

bel said...

buy wow goldbuy wow goldbuy wow accountbuy wow gold

zhijian said...

buy wow gold,cheap wow gold.09.05.15T

zhijian 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

vijender said...

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

wholsale watches said...

Rolex watches
Zenith watches
Longines watches
Oris watches
Panerai watches
Rado watches
Vacheron Constantin watches
Patek Philippe watches

寵寵 said...

哈啦論壇
浪漫月光論壇
中暑
中暑 abc 急救
BMI
糖尿病
無蝦米正式版
kmplayer繁體中文版
爆爆王無敵程式
mlb中文官方
迅雷5下載
you tube 中文版
smg 軟體
facebook中文介面
免費掃毒軟體
音樂播放軟體 winamp
adobe reader
wwindows 7 序號申請
windows 7 beta
7zip 中文版
PhotoImpact 12
ie8 0繁體中文版
nero 9序號產生器
pigo 遊戲網法
winzip 9 0 繁體中文版
mxie v0 6 0 1 繁體中文版
ewido 線上掃毒版
rocketdock 中文化
quicktime player 繁體中文版
pcman下載
emule 繁體中文版
生份證產生器

wo said...

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . I like it

wo said...

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . good,very good!

wo said...

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . .

This article is very good,I like it !

wo said...

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . good!good!

wo said...

. . . . .
. . . .
. . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
I like it,good,very good!

qcahz said...

You are right, I believe that there will be many readers like you
Chanel Cambon?Christian Louboutin?Chanel Bags Chanel Clutches Jimmy Choo

Chanel Denim Handbags?Manolo Blahnik Chanel nappa handbags

Yves Saint Lauret?Christian Louboutin Boots Gucci Handbagsdiscount christianlouboutinManolo Blahnik Gucci Bags?Jimmy Choo? Gucci Wallets?Louis Vuitton BagsYves Saint Lauret? YSL?Christian Louboutin?http://www.bestlouisvuitton.com/http://www.buylouboutin.com/http://www.yitingbuy.com/http://www.discount-christianlouboutin.com/
 

lixiang said...

I like your blog, it's very good!
By the way, do you like spyder down jackets, I think they are very fashionable and chic, especially the spyder ski jackets, I love them so much. In my spare time, I also like playing tennis rackets, it can keep healthy, what do you like to do?
kids north face jackets
polo vest
polo jacket
abercrombie fitch mens shirts
polo jackets for men
polo jackets for women
burberry shirts for men
polo hoodies for women
columbia jackets women
polo sweatshirts for women
north face jackets on sale
polo shirts for women
polo shirts wholesale
spyder jackets
ralph lauren polo shirt
polo pants for men
abercrombie fitch shirt
wholesale abercrombie fitch shirts
polo vests
polo jackets
polo hoodies for men
burberry shirts for women
burberry shirts on sale
polo shirts for men
north face jackets cheap
north face jackets for women
north face jackets for men
polo sweatshirts for men
columbia jackets for men
columbia jackets discount
spyder jackets for men
discount spyder jackets
cheap spyder jackets
spyder jacket
spyder jackets for women
tennis racquets
cheap tennis rackets
discount tennis rackets
tennis rackets on sale
prince tennis racquets
head tennis racquets
wilson tennis racquets
babolat tennis racquets

lady said...

I like the side of the article, and very like your blog, to write well and hope to continue their efforts, we can see more of your articles. ed hardy clothes. After reading this article has strong feelings, the future will be ed hardy womens longsleeve.ed hardy longsleeve
ed hardy hoodies
ed hardy jeans
ed hardy
ed hardy clothing
ed hardy t-shirts
cheap ed hardy clothing
ed-hardy.co.uk
ed hardy shirts
wholesale ed hardy clothing
ed hardy outerwear
ed hardy mens outerwear
ed hardy womens outerwear
ed hardy clothes
ed hardy boots
ed hardy outerwear
ed hardy hoodies
ed hardy Jeans
ed hardy hoodies
ed hardy jackets
ed hardy womens jackets
ed hardy mens jackets
ed hardy bags
ed hardy trousers
ed hardy shoes
ed hardy longsleeve
ed hardy mens longsleeve
ed hardy womens longsleeve
ed hardy jackets
ed hardy suits
ed hardy clothing
ed hardy shoes
ed hardy jeans
ed hardy boots
ed hardy mens sweater
ed hardy womens cotton
ed hardy womens boots
ed hardy
ed hardy womens clothing

chaoyang said...

Your blog is very good, it's the best blog I've ever seen, thank you!
By the way, do you like polo shirts, which are very chic, especially the polo t shirts, I love them very much. I also like playing tennis rackets, it can keep healthy, what do you like to do?
polo t shirts women
polo t shirts on sale
polo t shirts for women
polo shirts on sale
polo shirts men
men's polo shirt
men polo shirt
mens polo shirts
mens polo shirt
cheap polo shirts
discount polo shirts
men's polo shirts
women's polo shirts
cheap tennis racket
discount tennis racket
prince tennis racquet
head tennis rackets
wilson tennis racket
babolat tennis racquet

Online Pharmacy said...

Buy Generic Cialis Online For Full Customer Satisfaction. Order Cheap Cialis Prescription or Buy Tadalafil at the Best Prices from 8pills.com.
Online Pharmacy | Buy Viagra | Buy Tramadol | Buy Cialis | Buy Fioricet | Buy Ultram | Buy Soma | Buy Tamiflu | Buy Levitra

My store said...

coach sneakers sale,coach tennis shoes,coach joss sneaker,coach katelyn sneakers,coach sneakers on sale,

coach sneakers macy's,coach sneakers shoes,coach sneakers for women,coach sneakers for men,coach sneaker.com,

coach sneaker sale,coach sneaker sizing,coach sneaker size chart,

My store 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.

liu said...

When I surf the net, I come across your blog, and after I read your articles, I love your blog deeply.
Are you a fashion chaser? And do you like polo shirts, which are very chic, especially the polo t shirts, I love them very much. I also like playing tennis rackets, it can keep healthy, what do you like to do?
We are so honour to say that we are the outlet of
polo t shirts women
polo t shirts on sale
polo t shirts for women
polo shirts on sale
these products are warmly welcomed by our customers. And what's more we also sell
polo shirts men
men's polo shirt
men polo shirt
mens polo shirts
mens polo shirt
and the high-quality
cheap polo shirts
discount polo shirts
men's polo shirts
women's polo shirts
Our store are also famous for
cheap tennis racket
discount tennis racket
and the main product is
prince tennis racquet
head tennis rackets
wilson tennis racket
babolat tennis racquet
In this case, if you have time, you can buy many excellent things in our store, and we can assure you that we will not let you down.

Penis Enlargement Pills said...

http://www.bestpenisproducts.com is an all-natural Penis Enlargement, safe, and guaranteed alternative to painful and dangerous Penis enlargement methods such as surgery, straps, or rings.
penis enlargement pills or male enhancement pills will immediately boost your performance, improve your orgasms, and increase the penis size within just a few weeks!
VISIT OUR BEST PENIS ENLARGEMENT PILLS PRODUCTS:

VIGRX PLUS PILLS
VIMAX PILLS
MALE EXTRA PILLS
MALE ENHANCEMENT PILLS

brinkka said...

Erectile Dysfunction FAQ's

Impotence, or penile erectile dysfunction, in men is not as rare as one would think it is.
In fact, one out of ten men around the world is affected by this condition. It is not exclusive to old men either. Impotence is caused not just by physical factors,
but mental factors as well.
Exercising on a regular basis and eating healthy food will increase your ability to sustain prolonged physical effort and we all know that sex is effort.
Smoking, frequently drinking large quantities of alcohol, taking recreational drugs and lack of exercising will sap your stamina and also slow down the flow of blood.
Penis exercises can be used for maintaining fitness, preventing or controlling premature ejaculation and increasing the length and girth of the penis.
by penis enlargement pills you can overcome these problems and not only that you can also enlarge, extend also to strengthen your penis and premature ejaculation will not exist anymore for you.
visit http://www.factspenisenlargement.com for more info.

brinkka said...

Erectile Dysfunction FAQ's

Impotence, or penile erectile dysfunction, in men is not as rare as one would think it is.
In fact, one out of ten men around the world is affected by this condition. It is not exclusive to old men either. Impotence is caused not just by physical factors,
but mental factors as well.
Exercising on a regular basis and eating healthy food will increase your ability to sustain prolonged physical effort and we all know that sex is effort.
Smoking, frequently drinking large quantities of alcohol, taking recreational drugs and lack of exercising will sap your stamina and also slow down the flow of blood.
Penis exercises can be used for maintaining fitness, preventing or controlling premature ejaculation and increasing the length and girth of the penis.
by penis enlargement pills you can overcome these problems and not only that you can also enlarge, extend also to strengthen your penis and premature ejaculation will not exist anymore for you.
visit http://www.factspenisenlargement.com for more info.

Best Penis Enlargement Pills said...

We just wanted to share information about best penis enlargement that are busy talking about people who want a bigger penis size, stronger and able to increase stamina.
http://www.sizepenisenlargement.com
Penis Enlargement Pills
Top Penis Enlargement Pills
Method Penis Enlargement Pills

marcoz 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!

2010 Wedding Dresses said...

thanks for your sharing! great helpful!!!Thank you
Louboutin Shoes 
Christian Louboutin Shoes
Christian Louboutin Pumps 
louboutin
Christian Louboutin Boots 
Christian Louboutin Pumps
Christian Louboutin Heels 
Christian Louboutin Sandal
Pigalle Christian Louboutin 
christian louboutin studded bow
halter neck wedding dresses
louboutin pink bow studded heels
christian louboutin fur boots
loubitan studded bow peep
christian louboutin studded bow peep-toes
christian louboutin studded heels with bow
christian louboutin white shoes with bow
Wedding Dress Shops
vintage wedding dresses 
wedding dresses
cheap mobile phone
Wedding Dress Shops
Wedding Dresses 2011
Wedding Dress Shops
Off the Shoulder Wedding Dresses
bridal jackets
wedding jackets for the bride
loubitan studded bow peep
bridal jackets
wedding jackets for the bride
halter neck wedding dresses

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

Vinny said...

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

DorHam 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

neelu said...

I really wanted to send a small word to say thanks to you for the fantastic points you are writing on this site. My time-consuming internet lookup has at the end been honored with extremely good ideas to exchange with my pals. I ‘d express that many of us site visitors actually are extremely endowed to exist in a notable community with so many lovely individuals with useful points. I feel really fortunate to have used your webpage and look forward to so many more fun moments reading here. Thanks a lot again for a lot of things.
Hotels In Rimini

boy said...

Pretty nice post. I just stumbled upon your blog and wanted to say that I have truly enjoyed browsing your blog posts. After all I’ll be subscribing to your rss feed and I hope you write again soon!
London Hotels

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

David bone said...

It was really nice to study your post. I collect some good points here. I would like to be appreciative you with the hard work you have made in skill this is great article.singapore hotel deals

youjioa rs said...

It is better to give than to receive. It is easy to be wise after the event.

Hey , what you say is really informative and funny, i like it and hope for more update.buy runescape gold

I think you just did a right thing to make this choice, rs gold you know that's really funny and i am sure you will not regret.

runescape gold

Buğra Şilte said...

great thanks admin shares
Çelik Kapı şilte

dolinna said...

That is really cool. Thanks for finding it. Some really good ideas there, this is going to be a real time sink. I am a china tour lover,You can learn more: China tourism | China travel service | China vacation packages