In June 2019 Oracle opened up the ability to use Hybrid BSO for EPBCS allowing organizations to drastically reduce calculation times, application size and improve overall performance. Learn how you can take advantage of Hybrid today!
Recently Oracle introduced new functionality to allow Drill-Through to the Data Management Landing Page from PBCS Data Forms and Smart View Ad-hoc to Excel. Previously, the only option was to the web browser. The functionality is available via the Options Ribbon, Advanced tab. The setting is called “Drill-Through Launch” and you can either force it to Excel by selecting “In New Sheet” or have it prompt you by selecting “Prompt Me to Choose Target”. Personally, I like the second option because your not forced into one option. You can choose the “In Web Browser” if you want to check the drill to source or check mapping details or Excel if you want to do Excel analysis on the detail values.
Getting timeout errors in Smart View? Tired of the screen flickering when retrieving data. Built into Smart View are optimizations that could help.
Go to Smart View-> Help-> Health Check.
Health Check provides a menu with recommended settings. Try them out and see if it helps with your Smart View performance issues!
Have you ever used Oracle’s Currency Enabled applications for Planning, PBCS or EPBCS. It’s very straight forward and simple to use. Learn about how you can easily load data through Data Managengement in these enabled applications.
“Leverage the EPM Automate utility to keep your environments in sync:
– The ‘Recreate’ command restores an environment to a clean state.
– The ‘Copysnapshotfrominstance’ command allows the move of an artifact snapshot across cloud instances (i.e. PROD to TEST).
– The ‘ImportSnapshot’ command imports the contents of a snapshot into the target service environment.
By using EPM Automate you’ll avoid any potential browser timeout or file size issues, and you can automate the process by using a task scheduler.”
Always make sure your test environment and your production environment look slightly different to ensure what application you’re working in. A quick recommendation is to change the background color of your test environment to distinguish it from production. In the Cloud you can simply Tools > Appearance and change the Theme color to something different.