Oracle released EPMAutomate v15.09 this month.

Although you don’t have to upgrade EPMAutomate you should be aware of one new key feature/change and the potential impact if you don’t upgrade in the next few months.

History: 1st came EPMCopy.exe as the automation tool for PBCS.  Very soon after EPMAutomate was released and most of the functionality was removed from EPMCopy.

EPMCopy was left standing with a single purpose.  The remaining purpose was to talk to FDMEE on PBCS.  It would load files to FDMEE Inbox and execute Data Load Rules.

Not a big deal, however if you had to do multiple steps, like clear data in planning, load data using FDMEE and finally calculate and/or aggregate the data you had to leverage two tools in a script:

Sample script:

____________________________________________________________

Call epmautomate login %USER% %PASSWORD% %URL% %DOMAIN%

Call epmautomate runbusinessrule Int_Clear_Act_data_befload_from_HFM Period=%Period% Year=%FY% GCurrency=”Local_$”

REM FDMEE PROCESS:

C:\Oracle\EPMCopy.exe USERNAME=%USER% PASSWORD=%PASSWORD% IDENTITY_DOMAIN=ABC123 FROM=E:\Oracle\PBCS_Data_Loads\Load_Files\HFM_to_PBCS_Local_FY%2_%1.dat TO=https://ABC123.pbcs.us2.oraclecloud.com/files/inbox/HFM_to_PBCS_Local.dat LOADDATA=HFM_to_PBCS_Actual:%1-%2:%1-%2:REPLACE:STORE_DATA

Call epmautomate runbusinessrule Int_Agg_data_aftload_from_HFM Year=%FY% GCurrency=”Local_$”

____________________________________________________________

So you can see EPMAutomate and EPMCopy being called right?  I know not a big deal.

Here are some issues:

1.  Minor issue: Oracle is not supporting any new development on EPMCopy.  If you read my post on EPMAutomate encryption, you are aware that you can now encrypt passwords.  The encryption feature does not work with EPMCopy, so you are stuck with passwords hardcoded in the script.  (Assuming you are not using a 3rd party tool or feature I am not aware of)
2. Major issue: per Oracle “the File Transfer Utility will be deprecated starting with the January 1, 2016 service update.” As a result you will need to update any scripts using EPMCopy.

EPMAutomate now works great with FDMEE.

Here is the same script from above re-written using EPMAutomate.

____________________________________________________________

Call epmautomate login %PBCS_UID% %PBCS_PWD% %URL% %PBCS_DM%
REM IF %ERRORLEVEL% NEQ 0 goto :ERROR

Call epmautomate runbusinessrule Int_Clear_Act_data_befload_from_HFM Period=%Period% Year=%FY% GCurrency=”Local_$”
REM IF %ERRORLEVEL% NEQ 0 goto :ERROR

REM FDMEE PROCESS:
CALL EPMAUTOMATE UPLOADFILE E:\Oracle\PBCS_Data_Loads\Load_Files\HFM_to_PBCS_Local_FY%2_%1.dat inbox
Call EPMAUTOMATE RUNDATARULE HFM_to_PBCS_Actual %1-%2 %1-%2 REPLACE STORE_DATA HFM_to_PBCS_Local_FY%2_%1.dat

Call epmautomate runbusinessrule Int_Agg_data_aftload_from_HFM Year=%FY% GCurrency=”Local_$”

____________________________________________________________

Here is the url for the EPMAutomate command line:

http://docs.oracle.com/cloud/latest/pbcs_common/CSPGS/epm_automate_command_ref.html

I hope this is helpful information and you read it before 01/01/2016.

I would hate to start the new year off with calls, emails and texts about jobs failing.

Thanks for visiting.