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

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.

Do-It-Your-Self Demo - PSKeePass

​Introduction

This post will provide a do-it-your-self demo in order to understand the basics and potential of the PSKeePass PowerShell module. Completion time is about 10 minutes.

What will you learn?

After completing the demo you will have a basic understanding on how to use the module and how it can be applied.

Set all Oracle EPM Windows Services to Manual

It is best practice to set all Oracle EPM Windows services to manual. In most situations maintenance on the Windows servers is performed scheduled and unattended. That means e.g. when installing Windows patches, the servers might be rebooted at any time in any order. In most cases the shutdown is forced. That means all running processes that do not end within a specified time, are killed. In my experience this can damage the Oracle EPM installation. Hence my recommendation. When you perform as many installations as I do, you start to appreciate some automation of certain tasks during installation and configuration.

Below a simple, but effective PowerShell script that finds and disables all Oracle EPM Windows Services. Only works on EPM 11.1.2.2.0 and up.