div class='cap-left'/>

Geek Stuff (FR) - Let's not press a zillion times on "Yes" during FR import through Workspace, right?

Tuesday, May 3, 2016

Introduction


For those who migrated Financial Report objects using Workspace, will recognize the frustration of having to click "Yes" a zillion times during import.

For those who got spared so far: When LCM is not an option to migrate Financial Reporting objects, you have to use Workspace to export from the source and import in to the target environment. Sadly Oracle still didn't builtin a "Yes to all" option for some of the import activities, resulting in many manual clicks on "Yes" for sometimes over an hour.

Below you will find a solution to automatically click "Yes" when needed.

Solution

This solution is only recommended if you have a large amount of objects to migrate and is based on PowerShell and a PowerShell module called "WASP".

Instructions are assuming Firefox (however Internet Explorer is also supported):
  1. Copy the contents below and name the file "Send-AltY.ps1"
  2. Download the WASP module from here and copy the wasp.dll file in the same folder as the "Send-AltY.ps1" script file
  3. Open Firefox and login to EPM Workspace
  4. Navigate to "Explorer" and start the import process of your ZIP file containing the Financial Reporting objects
  5. Open PowerShell and execute the command below in order to automatically click "Yes" when needed.
  6. When all reports are imported, press CTRL+C to stop the script.

Final Notes

Simple but effective solution. Feel free to alter the script to match your requirements.

Enjoy!

1 comment :

  1. Hehe, been there and done that quite a few times. I will try this next time. :)

    ReplyDelete