In this article you will see a step by step instruction to export data into excel spreadsheet, from an OA Framework page. This can be achieved via very simple personalization to OA Framework page. The first step will be to find out the ViewObject Instance name from which data will be exported. This can be found from "About This Page" functionality. For this demo, Oracle iProcurement home page is used. We will be doing personalization to this page to add an "Export Button". When user clicks on this button, data from OA Framework View Object will be exported into excel spreadsheet. For this example, all the currently open notifications for the current user will be exported to excel spreadsheet. The name of the ViewObject used for exporting data from OA Framework Page is "OpenWorklistVO" in this case, and this can be found from "About This Page".
First find out the name of the ViewObject using "About This Page"
This is our About this Page Information. We can see the View Object from which data will be extracted to Excel
Now that we know the View Object Name, we can click on Personalize
Let us Create a New Item for Export Button
Select Export Button
Attach the View Object to the Export Button being created, and give this button a label
Now let us return to the main iProcurement page
We can now see the button created
Click on the button
Excel Spreadsheet will be opened
Subscribe to this comment's feedwritten by Bhavik , January 19, 2009
written by rampaage , February 05, 2009
Is there a way to import data from excel into a custom form that is attached to a specific responsibility.
So the form should be able to read from a excel sheet on the USer desktop.
Thanks
rampaage
written by Sreedhar Gouravelli , March 02, 2009
Thank You for the Good Note, Useful article.
I am reviweing this to implement in HRMS world to help our clients.Will update if any success from our side.
Thanks and Keep up the good work as lot of people are learning from you in true spirit of "what i can give back to community",
instead of thinking and acting of "what i got from community".
--Sreedhar Gouravelli.
written by katepalli.Mohan , March 09, 2009
I am doing the same in 11.5.10.2 but i am facing the problem while ading the button in the page.I am trying to load requistion data into Excel.can you please suggest me where its going wrong
Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = MyReqsGlanceVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;
written by katepalli.Mohan , March 10, 2009
At last i tried i got that but now i am facing the following error.As per my knowledge rowset is available but its saying that no data.
Error
There is no data to export.
written by Srini , March 11, 2009
written by Craig Dacres , April 29, 2009
Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = MyReqsGlanceVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;
written by sunita , June 02, 2009
I added an export button using personalization but the date which is printing at the excel sheet is server date...How do I print the
system date(from the custom table) at the excel sheet as well as how do i get time stamp on it?
looking forwrd to your quick reply
written by Sanujet , August 20, 2009
Love ya
| < Prev | Next > |
|---|
Very nice article.
My query is how can we export data from two different view objects one for master and the other for details.
For example, iSupplier PO Search page lists all the purchase orders as per the entered search criteria. Now I want to provide a button on the search page so that user can export all the POs (the complete PO, including header, lines and shipments) that he has searched.
Please provide necessary guidance if it is possible.