Oracle Planning and Budgeting Cloud (PBCS) - August 2018 Updates

The following announcements and considerations are outlined in the upcoming Oracle Planning and Budgeting Cloud (PBCS) update:

Oracle Planning and Budgeting Cloud (PBCS) and Enterprise Planning and Budgeting Cloud (EPBCS). August 2018

Monthly Update Schedule:

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (15:00 PDT) on Friday, August 3, 2018 and to your production environment on Friday, August 17, 2018, also starting at 22:00 UTC. The updates will be applied to your environments during the first subsequent daily maintenance.

Backing up the daily maintenance snapshot and restoring the environment as needed are self-service operations. Oracle recommends that you download the maintenance snapshot every day to a local server. Refer to Backing Up and Restoring an Environment Using the Maintenance Snapshot in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

Planning and Budgeting Cloud and Enterprise Planning and Budgeting Cloud:

• Incremental Export and Import Behavior Change.
• Restrict Currency Calculations in Forms Based on Scenario Definition.
• New Infolets Designer Properties Panel.
• Folder Support for Dashboards and Infolets.
• New Server Setting in Financial Reporting Web Studio.
• Financial Reporting Studio Desktop Client.
• Updated Vision Sample Application.
• New Documentation on Optimizing Business Rules.

 Upcoming Changes:

• Classic Dimension Editor.
• Ability to Create Composite Forms

Defects Fixed:

• Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)

Considerations:

• Financial Reporting User Preferences
• Only for Smart View for Office with Microsoft Office 365 ProPlus.

Thanks for your time in reading this, meet you all in the next post!!!!

Best Regards,

SST.!

EPM AUTOMATE UTILITY – copyfilefrominstance, listfiles & deletefile

Oracle added a new EPM Automate utility with July-2018 update. A new version of the EPM Automate Utility is available with this update. This version includes the copyfilefrominstance command, which copies a file from a source environment to the target environment from which you run the command.

This version also includes changes to the following commands to make them consistent with other file operation commands:

listfiles: now lists snapshots and files available in an environment.

deletefile: now deletes snapshots and files from an environment.

Let’s explore the new version of the utility & try these commands.

copyfilefrominstance: Copies a file from a source environment to the environment (target) from which you run this command. Before running this command, start an EPM Automate Utility session and sign into the target environment.

Syntax:

epmautomate copyfilefrominstance SOURCE_FILE_NAME USERNAME PASSWORD_FILE URL IDENTITYDOMAIN TARGET_FILE_NAME

where:

• SOURCE_FILE__NAME is the name of the file (including extension) that you want to copy from the source environment.

• USERNAME is the user name of a Service Administrator of the source environment.

• PASSWORD_FILE is the name and location of the file containing the encrypted password of the Service Administrator of the source environment.

• URL is the URL of the source environment.

• IDENTITYDOMAIN is the identity domain of the source environment.

• TARGET_FILE_NAME is a unique name for the file (including extension) in the environment from which you run this command.

Example:

epmautomate copyfilefrominstance "abcd.zip" username "C:\users\documents\ EPMAutomate\password.epw" https://test-cloud-pln.pbcs.us1.oraclecloud.com IdentityDomain "target data file.zip"

listfiles: Lists the files in the

·       default location,

·       Data Management folders,

·       inbox/ outbox.

·       Also lists incremental and backup export files, and Migration snapshots.

Syntax:

epmautomate listfiles

deletefile: Deletes

·       a file

·       or a snapshot from the default upload location,

·       a Data Management folder,

·       or from profitinbox/profitoutbox.

To delete a file from a location other than the default upload location, you must specify the file location.

Syntax:

epmautomate deletefile "location/FILE_NAME"

Thanks for your time in reading this, meet you all in the next post!!!!

Best Regards,

SST.!

How to Encrypt the Admin Password When Used on a Batch Script

Hi there :)

In this post we will work on encryption of administration password for cloud by using the EPMAUTOMATE utility which we use in batch scripting. Below are the steps we have to follow to encrypt it.

Before continuing, ensure the EPMAUTOMATE has been installed on the computer from which you are running the utility.

1. Click Start, then All Programs, then EPM Automate, and then Launch EPM Automate.

2. Generate a password encryption file. You use the password encryption file to pass encrypted password to initiate a session.

Command Line Example:

epmautomate encrypt P@ssword1 myKey C:\Oracle\EPM\bin\password.epw

• PASSWORD is the password of the Service Administrator in the service. You cannot use corporate credentials with the EPM Automate Utility.
• KEY is the private key that is to be used to encrypt the password.
• PASSWORD_FILE is the name and location of the file that stores the encrypted password. The password file must use the .epw extension.

3. Start a session as a Service Administrator. Use a command line as describe.

epmautomate login adminid C:\Oracle\EPM\bin\password.epw

https://test-cloudpln.pbcs_us1.oraclecloud.com IdentityDomain

4. Sign out of the Service instance.

epmautomate logout


Thanks for your time in reading this, meet you all in the next post!!!!

Best Regards,

SST.!