A Cloud vs. On-Premise Comparison for Profitability: All You Need to Know

In a previous blog post, the history of Hyperion Profitability and Cost Management (HPCM) was discussed along with which modules made it to the Cloud. If you are after a more clear-cut comparison between Cloud and on-premise, the below table should fit the bill. Tables generally cannot provide all the needed context, yet they are, at times, the best starting point to understand the benefits and capabilities of one solution compared to another.  The below PCMCS vs. HPCM table is not exhaustive, and if you have questions on any of the items covered, email us and we will provide further details.

PCMCS 12-11 Image 1

Choosing between on-premise and Cloud depends on which factors are the most significant barring the overall licensing cost.

Allocations and data assignments cannot have “If” statements attached to them in the on-premise version of the software – a feature fundamental to supporting Tax transfer pricing capabilities.

The cross-dimension mapping is a functionality that is not available in HPCM. This mapping ensures the assignment of data sets to the same ID/name across multiple dimensions by using the “Same as Source but Different Dimension” option within PCMCS to support intercompany activities. This feature alone, or the lack of it, may significantly impact the design of an application and the overall complexity of allocation flows.

Features available in the Cloud but not yet released in on-premise solutions could tip the scale to favor the Cloud option when all other aspects surrounding a Cloud implementation no longer appear to be as pressing. Out-of-the-box content such as overnight backups, full application, and data restores that are at the business users’ fingertips – not to mention the reporting and dashboarding included in the Cloud version – are all differentiators of a product that enables business users to control their allocation process and methodology from its inception.

While there may be exceptions to the trend where on-premise solutions can have advantages (modules not available in the Cloud, for example) and, therefore, represent the best option at a given moment in time, the reality is that the future is being developed in the Cloud and for the Cloud, and at some point the shift will most likely no longer be an option, but a necessity.

If you need help making a decision with an existing implementation or you would like more details about HPCM vs. PCMCS to make a better informed decision, email us at infosolutions@alithya.com. Our PCM Center of Excellence team is ready to share leading practices and industry-specific solutions that accelerate the ROI and expand the capabilities of your chosen software.

Worry No More! Say Goodbye to Pain and Frustration when Submitting Service or Enhancement Requests with Oracle for PCMCS

While nobody likes submitting Service Requests (SR) on the Oracle support site, this is a necessary task that we must get comfortable with, whether our applications are on-premise or in the Cloud.  After 12 years of consulting, I can say that I have seen or pursued many wrong ways of submitting an SR which, in turn, yields results along similar lines – a lot of back-and-forth emailing with Oracle’s support staff, personal frustration, misinformation, and most importantly – time wasted on all sides.

Worry no more!  Here is a list of things you can do to avoid further pain and frustration when submitting Service Requests or Enhancement Requests with Oracle for Profitability and Cost Management Cloud Service (PCMCS).

  1. Where do I start when submitting SRs and ERs for PCMCS?

You can still use the generic Oracle Support website to open either an SR or an Enhancement Request (ER) with Oracle for Cloud applications, but the right way to do this is to first gain access to the Oracle Cloud Support website which looks slightly different and has a couple of new fields to complete. The email associated with the Oracle account should be the same email that has access to specific Cloud subscriptions.

Standard Oracle Support website

PCMCS Image 1

Cloud Support website

PCMCS Image 2

  1. Provide feedback

Login in to the Cloud application for which you want to create the SR or ER, and once you are logged in to PCMCS, navigate to your user name (top right) and select “Provide Feedback.” A new screen will appear enabling you to highlight the area of concern to provide context for the reason you are submitting the SR or ER.

Provide details around the area of concern. This gives context to the issue at hand and creates a reference for future troubleshooting. For example, if the issue is related to one specific Rule, ensure that the last screen open before you click on Provide Feedback is on the rule itself, or open to the job library listing the execution of the rule. You will only be able to highlight areas on the last screen open before launching the “Provide Feedback” screen.  The details you provide here will not automatically be copied into your SR. If you want to describe the issue in detail within this section, you can copy the same text within the SR itself – save it locally before submitting the feedback.

  1. Options for your feedback.

After you submit your feedback, a new panel will come up and will contain the following 3 sections:

  1. Environment: a listing of your Browser, Platform, Version, Locale, Resolution, Time zone, Cookies enabled (Y/N), URL of the instance, and the User Agent. You do not have to fill in anything in this section. All information is filled in for you.
  2. Plugins: a listing of enabled plugins, if any. You do not have to fill in anything in this section. All information is filled in for you.
  3. Confirm Application snapshot submission: this is the only section where you must provide input.

PCMCS Image 5You have a choice of Yes / No – depending on how comfortable you feel about Oracle using your daily maintenance snapshot for regression testing in upcoming releases. Giving Oracle access to your maintenance snapshots means you are agreeing to them using the model and any related data for their testing going forward. If your hierarchy structures and data are not sensitive, then you may choose to select “Yes.”  My personal preference is to select “No” and provide the static/current moment in time archived snapshot within the SR . When the SR is closed, the contents of said snapshot will be archived and not used for further regression testing.

  1. Generate a Diagnostic Report (UDR) ID

When clicking the “Submit” button on this screen, a unique alphanumeric reference is generated. This reference will be required when submitting an SR or ER on the Oracle Cloud Support website. Write down or, preferably, copy and save this UDR string of characters on your workstation in a txt file.

  1. Log in to the Oracle Cloud Support website and proceed with opening a new Cloud SR/ER.

Select the “Create Service Request” button on the lower left-hand side of your screen.

PCMCS Image 6

Select “Service Type” from the drop-down list of available Cloud services to which your user has access.

PCMCS Image 7

Once you have selected “Oracle Hyperion Profitability and Cost Management Cloud Service,” a listing of all available instances will be displayed in the new “Service Name” section:

PCMCS Image 8

Make sure you select the appropriate “Service Name” with the instance where you generated the related UDR (see previous steps).

Add “Problem Type” and select based on the type closest to your issue:

PCMCS Image 9

The above choices will not trigger related content or a list of options – this is merely to ensure that the ticket goes to the appropriate team during the investigation process.

In the “Problem Summary” section, reference the Cloud product for which you are creating the SR or ER. This will be the subject of your ticket, and it will help administer and keep track of multiple tickets at the same time.

  1. Attach all System Reports available for your PCMCS app.

To avoid multiple back and forth email exchanges with the Oracle Support staff, provide them with all the available information. Here is a current list of all available reports for troubleshooting PCMCS applications.

  1. Execution statistics for the last model / allocation execution connected to the SR – if SR is related to calc performance, calc troubleshooting or rule setup. (PDF or XLS format preferable)
  2. Program Documentation (with details; not with aliases) (XLS or PDF format preferable)
  3. Dimension Statistics (PDF format preferable)
  4. POV Statistics (PDF or XLS format preferable)

All these reports can be generated from PCMCS – Navigator menu – System reports.

PCMCS Image 10

  1. Attach the Diagnostic report

From the “Navigator” Menu, select “Application,” click on the drop-down in “Actions” and select “Export Supplemental Diagnostics.” This report is very useful to the development team troubleshooting your issue.

PCMCS Image 11

When selecting this report, a new job will be launched that can take anywhere between a couple of minutes to 20+ minutes, depending on the size of your application and the amount of logging involved.

An archive of the diagnostics reports will be generated in the File Explorer within the Application menu.  Some of the reports in this archive will be a repeat of the other reports mentioned in the previous step, but if you provide all this information simultaneously, the redundancy should not cause any issues. If you are not open to launching such process in your environment during business hours, and yet you still want to submit the SR in a timely fashion, you can skip this step and provide this report only upon request from Oracle Support staff.

  1. Error description

If you can replicate the error, capture each step via screenshots and save them in a Word doc. The earlier the support staff understands what you are dealing with, the faster the entire troubleshooting process will be completed.

Refer to menu options precisely as what they are called within PCMCS.

For example, to submit an SR or ER related to the Calculation Rules menu, refer to it as Calculation Rules – Rules Express Editing, as both names appear in the PCMCS menu.

PCMCS Image 12

  1. Establish the SR level appropriately.

There are 4 options to choose from, and you should choose based on urgency as well as level of importance.

PCMCS Image 13

Choose severity 1 and 2 only when applicable. You may be inclined to select such severity options so that your issue is resolved quickly, but use your own criteria to distinguish between something that is really a show stopper and something that is not. Time is of the essence for both you and the Oracle Development team.

When choosing severity 1, you will open your calendar for potential phone calls that can occur at any time, regardless of your time zone.

  1. My request is really an ER, not an SR.

If your SR is an Enhancement Request, provide a lot of supporting detail in the “Business Justification” section. Not doing so will delay the Enhancement Request submission by up to 2 weeks. If further business justification is requested, respond promptly to make things move along and ensure that your request makes it to the next patch release sooner rather than later.

Once an Enhancement Request is recorded, your SR will be updated with the ER ID (which will differ from the SR ID originally assigned the moment you submitted the ticket).  The original SR will be closed, and you can open a new SR quoting the ER ID 48 hours after the moment your request was accepted. The Support staff will confirm whether the ER will make it in the next monthly patch release.

  1. Bedside manners for SR/ER submitters.

Try to reduce the number of communications within the SR. Taking the above steps will get you closer to achieving a near-perfect SR submission. Be mindful about how to communicate efficiently. The higher the amount of back-and-forth communication, the more difficult it will be for the development team to follow the conversation trail and ensure efficient troubleshooting.

Whether you are a service provider or a PCMCS administrator who inherited an application at the end of a project implementation, we all tap the same Oracle Support resources which are, as are most things, finite. The more efficient your SR/ER submission is, the faster these resources provide a response with accurate and detailed troubleshooting steps. For any time-sensitive issues or further escalation, leverage your Oracle representative and your implementation partner. Their existing relationship with Oracle Product Management will help direct your query to the right resources and ensure your SR is not stuck because of lack of clarity regarding which team should own it. This will ensure that your SR/ER is fast-tracked to the appropriate team and given the right level of attention. For any critical issues you encounter with PCMCS or other Cloud subscriptions where there is no solution in sight, reach out to Alithya at infosolutions@alithya.com so that our team can provide a fast end effective assessment.

Full Circle Planning, Cost Management, & Profitability in the Manufacturing Industry

This post corresponds to the webinar “Full Circle Planning, Cost Management & Profitability in the Manufacturing Industry.” You can access the recording here.

As we are all aware, today’s manufacturing industry faces multiple ongoing challenges, including:

  • Changing customer/consumer demands
  • Shrinking operating margins
  • Ever-changing compliance and regulatory pressures
  • Increasingly globalizing economy
  • Lowered availability and visibility of detailed information

Now more than ever, manufacturers’ focus is not just on growth, but, more specifically, on profitable growth.

 

Managing Profitable Growth

When it comes to profitable growth and insight into profitability, the first place to start is the consolidated P&L.

But while the P&L offers information on profitable growth, it does not help manage profitable growth. The financial P&L provides limited insight into costs, profits and their underlying drivers, from the perspective of their lines of business, products, customers, markets and channels. Cost bases are imperfect and are limited to legacy standard costing and unstructured cost extracts. Results lack a matching of costs and revenue to manage margins at the same strategic view as revenue.

 

The Need to Focus on Strategic P&Ls

To address and contend with these challenges, we recommend a greater focus on more strategic P&Ls for the manufacturing industry.

Strategic P&Ls provide insight into both direct costs and indirect costs.

  • Direct Costs include costs directly associated with:
    • The making of a product or delivery of a service
    • Parts for the product
    • Labor for Service Delivery
    • Costs directly attributed to the selling to a customer or client
    • Shipping and handling expenses
    • Customer processing expenses
  • Indirect Costs include costs that are not directly attributable to the making of a product, delivery of a service, or the selling to a customer:
    • Operating costs (e.g., Call Center, Distribution)
    • Selling costs (e.g., Sales & Marketing)
    • Investment costs (e.g., R&D, Initiatives)
    • G&A costs (e.g., IT, HR, Finance, Admin)
    • Finance charges for Cost of Capital Employed

Measurement of indirect costs in particular can be difficult.

 

What Would A Solution for the Manufacturing Industry Look Like?

With all of this in mind, it’s important to look at the big picture when determining what manufacturers can do to attain strategic P&Ls and overcome their challenges?

The ideal solution for the manufacturing industry would:

  • Design, support and evolve to an integrated financial process
  • Leverage operating metrics and key assumptions to:
    • Link business drivers behind financial performance
    • Modify drivers and assumptions to plan future performance and attain strategic P&Ls
    • Drive accountability to Lines of Business
  • Offer a consistent and transparent framework to support indirect cost attribution
  • Use integrated applications and tools to support and adapt to changing business processes
  • Provide robust reporting to business for transparency into causal factors

A true full-circle planning, costing and reporting solution that aligns and adapts to an integrated financial process includes the following:

  • Driver-based revenue planning and departmental expenses leveraging the actual financial data, operational metrics
  • Integrated costing capabilities that can allocate indirect expenses to lines of business by leveraging the same actuals, plans and drivers used in the planning process
  • Robust and real-time reporting to surface strategic P&Ls by Customer, Product and other Lines of Business

 

Some Solutions are Ineffective and Unsustainable

Our team at Ranzal has seen many manufacturers attempt to piece together a solution using various combinations of spreadsheets, ERP, custom and packaged applications.

Typically, spreadsheets are the most common ingredient given their flexibility and accessibility. But spreadsheets tend to be error-prone, highly manual/labor-intensive and prone also to risk regarding controls and governance. We’ve also seen customizing the ERP as a common solution-oriented approach, but this can be too expensive, overly IT-centric and can also be somewhat of a “black box.” And lastly, custom applications are slow to adapt, can promote high effort and cost and also function like a “black box.”

 

Oracle’s EPM as the Foundation for Full-Circle Planning

We recommend Oracle EPM’s packaged applications to be the foundation to configuring the right full-circle planning, costing and reporting solution that avoids the constraints and risks other avenues bring on.

The specific Oracle EPM offerings that support a full-circle planning, costing and reporting solution involve:

  • Planning & Budgeting Cloud Service (PBCS)
    • Best-in class solution for financial planning, budgeting and forecasting
    • Align top-down and bottom-up processes
    • Consistency of assumptions, calculations and methodologies
    • And many more features here
  • Profitability & Cost Management Cloud Service (PCMCS)
    • Computes Profitability for Units, Segments and Services
    • Pre-Built Framework for profitability modeling: Dimensions, Support for Multiple Cost Allocation methodologies, Validation reporting
    • Graphical Interactive Traceability Maps & Dashboards
    • Measures, Allocates and Assigns Cost and Revenues via User-defined Rules
    • And many more features here
  • Tightly integrated with the Oracle EPM Cloud
    • Consistent Administration with EPM Cloud Offerings
    • Shared Reporting Tools like Financial Reports & Smart View for Office
    • Proven Technology Stack

We believe a comprehensive solution focused on a “Technology Trio” of Integrated Business Analytics, or the convergence of: EPM, BI and BD solutions. Experience and results have shown us that this combination provides the tools and answers needed for improved business performance, increased innovation, better vision, and increased business value.

For more information or to request a demo, email us. Be sure to ask about our complimentary one-day Profitability and Cost Management assessment and how the newly-released Oracle Profitability and Cost Management Cloud Service (PCMCS) can help modernize your solution.