Angelo Santagata's Blog
-
Oracle Fusion
June 11, 2013
Exporting Items
Following on from the previous article, an easy way of exporting the InventoryItemIds is to use the Embedded BI Publisher in Fusion Applications
Login as a Fusion Systems Administrator, and select Reports and Analytics
Create a Report
Create a new data model
Give the Data Model a name and store it in a folder
Now select the data set and create a "SQL Query"
Enter the SQL query. For items there are two tables we need to be concerned with egp_system_items_b (the base table) and egp_system_items_tl (contains the translated descriptions). We need to query both tables even if we dont have any translations as the base language description is stored in the translations table.
Select the datasource to be "ApplicationDB CRM", although this might change for your installation/version
After saving this dialog and hitting the screens save button on the far right hand side
Then select the XML icon, this allows us to run the query AND export the data as XML
The result!
and yes you can export it to a file
