Forum Stats

  • 3,874,225 Users
  • 2,266,686 Discussions


Import folders to Business Areas

TR7 Member Posts: 17 Blue Ribbon
edited Oct 21, 2019 3:01PM in Discoverer

What is the best way to import folders (in the form of .eex files that have been exported from another environment) into a target environment, and ensure that they are added to the correct Business Areas and have the correct owners assigned so that users will be able to access the folders and run the reports?


  • TR7
    TR7 Member Posts: 17 Blue Ribbon
    edited Oct 14, 2019 2:32PM

    Please note that my question pertains to custom folders.

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Oct 21, 2019 3:01PM


    There are 3 options when you Export using Discoverer Administrator, Entire EUL, Business Area, and Selected items.  Use of Selected Items should only be done to move/backup Workbooks.  If you were to select export Folder, only the Folder definition is exported.  You would need to individually select every single item contained in the folder (fields, item classes, etc.) to get the content of the folder too.  If done incorrectly, you will have orphaned folders (not associated with BA) and missing items.
    So, though it is possible to export folders, it is very complicated and not recommended.

    When importing you should import by Name and not identifier.  The reason is every EUL can have a different identifier for the same item (BA, Folder, Field, etc.).  Most Apps Mode (E-Business Suite database) EULs are created by Importing the Oracle EBS supplied content.  So, EULA_US and EULB_US will have different identifiers. As long as the Names match it will work nicely.  If the identifiers do not match, you will have two of everything that was imported.
    One more note, when importing into a Apps Mode EUL, you should never, ever use the EUL owner (a database user).