Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« May 2020 | Main | July 2020 »

June 29, 2020

Journey towards New Age Manufacturing


Manufacturing is no longer about making some product and shipping it to the customer. It begins with Sales from identifying Leads and ends with service activities which are a lifecycle by themselves and establish strong customer relationship and potential growth prospects not just from repeat business but industry references.

 

With new age technologies at disposal on Subscribe instead of Build options, organizations can make a quantum leap towards acquiring the desired Efficiencies using Automation tools, Continuous Build and Leverage Knowledge using Artificial Intelligence and IOT while providing far better Reach towards internal and external stakeholders using Mobility. We strongly believe that with a blend of all these technology advancements, organizations will be more than ready to take that huge leap towards that paradigm shift in how business is done and customers delight is achieved.

Here we are connecting Salesforce and Oracle cloud the best of breed applications.

 

Solution Overview:


Jayeeta.jpg



Product manufacturing cycle:

The cycle begins with Lead creation, management of Configuring, Pricing and quotation (CPQ) and eventually creation of Opportunities in Salesforce Sales. The opportunity gets converted as a 'Project' in Oracle PPM Cloud (This is done with integration (Middleware: Mulesoft or OIC)). Project specific budgets will be created in Oracle PPM Cloud in planning phase. Project Execution starts with Project specific Requisitions and Purchase Orders in Procurement cloud. Items will be received in project specific Inventory and all the project costs will be accrued to the project with help of Project Costing Cloud.

From the sales perspective, we will use the Forecasting tools present in Salesforce Einstein AI to predict future leads and opportunities.

Eventually, Project Contract will be initiated with association of project and will take care of customer Billing and Revenue recognition for the project in Project Contracts Cloud.

Customer payments will be carried out in Receivables Cloud which is totally integrated with PPM cloud and Project contracts.

Maintenance cycle:

Once the Products are placed in service (post Erection and commissioning), Service tickets will be created in SFDC Service and simultaneously Maintenance project will be activated in PPM cloud with each Service ticket created as new task in the maintenance project. (as part of integration from SFDC to Oracle)

The process of maintenance project cost tracking is similar to Main project. Oracle Project Contracts offers multiple billing and Revenue methods to meet customer specific billing requirements.

Work Orders created in SFDC will be scheduled in Field Service Console and will be pushed to Technicians Mobile applications for them to act upon. Technicians can also raise purchase Requisitions which will be pushed back to Oracle Procurement cloud with maintenance project tag.

Preventive maintenance will be achieved with orchestration for IOT integration. Installed machines will be continuously monitored for any performance slippage and on any slippage new cases and work Orders will be automatically created.

 Preventive maintenance will also be achieved with Analysis of existing service tickets with various predictive models and Dashboards using Einstein AI.

Significance:

  • Entire end to end best in class cloud based solution with Oracle and Salesforce.
  • Preventive Maintenance with IOT and AI
  • Predictive analysis with Einstein AI
  • Effective Project cost tracking with Oracle PPM Cloud
  • Multiple Project Contracts billing methods to meet customer requirement with Project Contracts.
  • Mobility based solution
  • Google map integrated to view various Sales Work Orders

 

About the Authors:

Jayeeta Shenoy is a Lead Consultant with Oracle Practice

Mager Guilbert Loze T. is a Senior Consultant with Oracle Practice

June 25, 2020

Best Practice: Oracle Primavera P6 EPPM Cloud Migration

Introduction:

Oracle Primavera P6 EPPM is the most powerful Project Management scheduling tool used extensively in project intensive industries across the globe. In today's fast paced world; there is dire need to enhance technology landscape and reduce cost of ownership on hardware infrastructure by moving it to cloud. Oracle has also moved most of the products from Primavera umbrella to cloud and providing that as Software as a Service (SaaS).

This blog contains the details regarding migration of Primavera On-premise environment to Oracle P6 EPPM Cloud which can be used as reference for future cloud migrations.

Typical Cloud Migration Flow:

Following is typical and recommended overall solution approach for P6 EPPM cloud migration

Cloud Migration Methods:

There are 2 different methods which can be used for Oracle Primavera P6 EPPM cloud migration:

  1. Lift and shift (Moving the database) i.e. In place upgrade and migrate

    • This option is recommended approach to migrate an entire legacy database to Cloud with minimum risk and issues
    • Minimum user involvement and quick turnaround time is key benefits of this approach
    • MS SQL database needs to be first converted in to Oracle DB for handing over to Oracle for DB upgrade

  1. Using standard Primavera export/import functionality

    • This option is suitable for organizations having multiple On-premise environments and selected data is required to be migrated from Legacy environment to single consolidated Cloud environment
    • The process will require strict coordination between IT and Business representative to determine which projects and data to migrate hence will need better planning
    • Certain user specific data will have to be manually re-created and comprehensive testing is required to ensure data is correctly migrated without any losses & error

Method 1: Lift and Shift Database:

Lift & Shift database approach has following main elements:

    • Take backup of existing On-premise Database
    • Convert MS SQL DB to Oracle DB; if using SQL DB as Oracle cloud does not support any other DB except Oracle
    • Upgrade Oracle DB version compatible to latest On-premise version i.e. P6 R19.12 in On-premise environment
    • Unit Testing on upgraded DB along with application for P6 R19.12 On-premise environment as per legacy environment compatibility; if needed
    • Handover upgraded Oracle DB to Oracle cloud team through Oracle Secure File Transfer (SFTP) protocol
    • Oracle cloud team to upgrade Oracle DB from On-premise R19.12 to DB version which is compatible with latest Oracle P6 EPPM Cloud version i.e. P6 R20.x and release cloud environment

Above steps needs to be followed typically in 2 iterations respectively i.e. Non PROD and PROD environments as per customer need


Method 2: Primavera export/import functionality

1.       Exporting Primavera Projects to P6 XML:

    • Preparing to Export: Consolidate database instances, check version compatibility and clean data, if required
    • Export data: Export Project Data from either P6 Web or P6 Professional client to P6 XML 

2.       Importing P6 XML into Oracle P6 EPPM Cloud:

    • Import Objects: Determine global and project data that needs to be imported into Primavera P6 EPPM Cloud using the P6 XML file format.
    • Import Actions: Finalize on handling of project data when they are imported into the application. Different actions can be taken depending on whether client want to create new project, update an existing project or ignore an importing project.
    • Preparing to Import: Complete all master configurations, import template finalization and check the P6 XML file size to ensure that environment is ready to import projects
    • Import P6 XML Data into Oracle P6 EPPM Cloud: Use the P6 EPPM Cloud web or the Professional desktop client module to import project data
    • Post-Import Steps: Complete import log review, project data validation, schedule & baseline projects to ensure that the imported data is accurate and complete. 

Primavera export/import functionality is applicable method for cloud migration for following scenario:

    • This method is applicable for organization where selected data needs to be migrated from legacy On-premise environment to Cloud
    • Also this method can be used for the organization where multiple Primavera environments are present and there is a need for single consolidated environment which will help in reducing clutter and overall database size
    • Since only select data is being migrated, it will significantly reduce occurrences of data anomalies resulting in a more stable environment for users 

Comparison:

Various implementation factors determine which is the best method to be adopted for cloud migration. Given following are few factors to be considered while deciding on approach.

 

Summary:

This blog explains different approaches available when addressing Oracle Primavera P6 EPPM cloud migration requirement of the customer. Consultants can weigh the options objectively using the comparison table and arrive at the best suited approach for migration of P6 EPPM On-premise to Oracle EPPM cloud instance.

June 20, 2020

Synopsis of EPM Cloud Updates - June 2020

Oracle Enterprise Performance Management Cloud June 2020 New Feature Summary


ENTERPRISE PERFORMANCE MANAGEMENT CLOUD


EPM CLOUD COMMON

This section contains announcements related to the common EPM Cloud components such as EPM Automate, Migration, Access Control, Data Integration, and Smart View for Office.

NEW TOPICS IN EPM CLOUD OPERATIONS GUIDE:

The EPM Cloud Operations Guide has been enhanced with additional topics.

Making EPM Cloud-Related Requests:

Ø      Requesting Design Comparison for On-Premises Planning Application Migrated to EPM Cloud

Ø      Submitting an Enhancement Request

Ø      Requesting an Increase in Financial Consolidation and Close Dimension Governor Limits

Ø      Requesting Root Cause Analysis (RCA) for a Resolved Issue

Ø      Requesting an Old Backup Snapshot of an Environment

Ø      Requesting an Increase in Capacity

Ø      Requesting a Health Check for an Environment

Ø     Requesting EPM Cloud Roadmap Information

Ø     Making Other Requests

Asking How-to Questions.

EPM AUTOMATE UPDATES:

A new version of EPM Automate, which contains the runRuleset command is available. This command, which launches a ruleset, works only with Planning, Financial Consolidation and Close, and Tax Reporting environments. Additionally, the sortMember command has been updated to work with Planning Modules applications.

CHANGE IN EMAIL ADDRESS FOR OUTGOING EMAILS:

Emails originating from EPM Cloud applications will now use no.reply@oraclecloud.com  instead of oraclecloudadmin_ww@oracle.com  as the from address.

Emails from other Oracle Cloud sources, for example, New Account email sent from the Identity Domain, will continue to use the current From email addressses, for example, oraclecloudadmin_ww@oracle.com.

SIMPLIFIED SEARCH IN ACCESS CONTROL:

Access Control now uses a simplified, intelligent search function across screens that supports search for artifacts such as users and groups. This search function, unlike the previous version, does not use wildcard characters with partial search strings. Instead, it searches using a partial string from one of the user (user name, first name, last name, and email ID) or group (group name) attributes to retrieve all artifacts that contains the search string. For example, using the string st to search for groups displays groups such as Test, Cast, Analysts, and so on. Similarly, using the search string Fr displays user names of Frank, Freddy, Alfred, and so on.

FLASH DISABLED BY DEFAULT IN CALCULATION MANAGER:

Flash is now disabled by default in Calculation Manager. You can still enable Flash temporarily, if desired.

MANAGE DIMENSIONS WITH ADMIN EXTENSION IN SMART VIEW (MAC AND BROWSER):

Service Administrators can now deploy and use the Admin Extension in Oracle Smart View for Office (Mac and Browser) to import and edit dimension and member metadata in a Smart View grid.

SET USER PREFERENCES IN SMART VIEW (MAC AND BROWSER):

You can now set user preferences in Oracle Smart View for Office (Mac and Browser) to control many aspects of function and display. The changes you make in Smart View (Mac and Browser) are saved to the EPM Cloud business process and are remembered the next time you log in to either the web interface or Smart View. User Preferences apply to Planning, Financial Consolidation and Close, and Tax Reporting.

REST API TO REVIEW REJECTED DATA AFTER IMPORT:

While using a REST API to import data, you can now get the errored out records. To do this, you specify an error file that captures the data records that are not imported for each dimension. If an error file is specified, a separate error file is created for each dimension. The error files are then zipped together and the zip file is stored in the Outbox where you can download the file using Inbox/Outbox Explorer or tools like EPM Automate or REST APIs. This applies to Planning, Financial Consolidation and Close, and Tax Reporting.

NEW APPLICATIONS OPTION IN DATA INTEGRATION:

A new Applications option is now available in Data Integration (the simplified user interface). Use the new option to register new applications, or select an existing application and update application options, delete it, or refresh application definitions.

REGISTERING APPLICATIONS FOR CUBES IN DATA INTEGRATION:

In Data Integration, customers can now register more than six cubes as applications.

NEW ORACLE NETSUITE PBCS SYNC SUITEAPP SAVED SEARCHES:

In this update, two new Oracle NetSuite PBCS Sync SuiteApp Saved Searches are supported in Data Integration and Data Management.

REPLACE MODE FOR ALL DATA TYPE WITH SECURITY LOAD METHOD NOW SUPPORTED:

In Data Management and Data Integration, Replace mode for the All Data Type with Security load method is now supported.

LCM MIGRATION OF DATA LOAD MAPPINGS IN DATA MANAGEMENT:

In order to improve the performance of export and importing large data load mappings, Data Management now exports the mapping by individual locations. When importing the mappings to the target environment, the existing mappings are completely replaced with mappings from the source environment. Prior to this update, data load mappings from the source were merged into the target environment.

CONNECTING DIRECTLY FROM ORACLE ANALYTICS CLOUD TO EPM CLOUD PLATFORM:

 With this release, you can connect directly from Oracle Analytics Cloud Enterprise Edition or Professional Edition 5.6 to EPM Cloud Platform, provided you have both services. When you've configured the connection, you can visualize data from EPM Cloud business processes (Planning, Financial Consolidation and Close, and Tax Reporting) in Oracle Analytics Cloud. You no longer have to model EPM data in a metadata repository (RPD) file to create visualizations and dashboards in Oracle Analytics Cloud.

ABILITY TO WRITE TO UPPER-LEVEL MEMBERS USING GROOVY:

Using Groovy's new setForcedEditable()method, you can now write to upper level members that are dynamic Calc in both ASO and BSO cubes within an application. You can then use custom allocation logic in Groovy to push data to lower level members. To implement this, follow the steps to create a Groovy business rule in "Creating a Groovy Business Rule" in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud.

SUPPRESS MISSING ROWS WHEN BUILDING GRIDS USING GROOVY:

You can now use Groovy to apply row suppression at the Essbase level when building grids using DataGridDefinitionBuilder. This benefits you by reducing the amount of data on the Planning side and eliminating the impact on query thresholds. To implement this, follow the steps to create a Groovy business rule in Creating a Groovy Business Rule in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud.

USE HSGETVALUE AND HSSETVALUE TO RETRIEVE DATA IN SMART VIEW (MAC AND BROWSER):

The Smart View functions, HsGetValue and HsSetValue, can now be used in Smart View (Mac and Browser). This feature applies to Planning, Financial Consolidation and Close, and Tax Reporting.

 

ACCOUNT RECONCILIATION

 

ABILITY TO SPLIT AN UNMATCHED TRANSACTION AMOUNT IN TRANSACTION MATCHING:

Splitting transactions allows you to manage timing differences for 1 to Many, Many to 1, or Many to Many matches by allowing you to match part of a transaction, leaving aside only the split remaining amount unmatched. This helps keep the number of unmatched transactions as low as possible at the end of each day and allows a reviewer to look at a reconciliation with fewer unmatched transactions.

DATABASE TABLES AND VIEWS GUIDE AVAILABLE FOR HELP WITH CUSTOM REPORTS:

A new Account Reconciliation Tables and Views guide is available to help with developing custom reports. This guide outlines all the database tables and views for Reconciliation Compliance, Transaction Matching, and common tables so that you can more easily develop queries for custom reports.

DELETE ALL TRANSACTIONS FUNCTIONALITY ADDED TO RECONCILIATION COMPLIANCE:

You can now choose to delete all the transactions associated with a reconciliation from the Actions dialog without needing to select them individually.

SETTING DASHBOARD MAXIMUM ROWS FOR RECONCILIATION ACTIONS DIALOG:

The system setting for Maximum Rows now applies to the number of rows of transactions to display in the Reconciliation Actions dialog. Previously, this system setting applied to the Reconciliation, Transactions, Profile, and Matching Lists.

 

FINANCIAL CONSOLIDATION AND CLOSE

 

PERFORMANCE SUBSTITUTION VARIABLES:

The following Substitution Variables can be enabled to improve performance: 

Ø      EnableSimpleAggregation

Ø      OptimizeDBRefresh

Ø      OptimizeYTDCalculation

Ø      OptimizeConcurrency

NOTE: The degree of performance improvement varies widely across different applications as it is purely driven by the application design and data distribution.

ABILITY TO AUTOMATICALLY OPEN AND CLOSE JOURNAL PERIODS USING TASK MANAGER:

 A new Task Manager Integration Type is available that enables you to use Task Manager to open or close Financial Consolidation and Close journal periods automatically during the close period.

ITEM COUNT ADDED TO SUPPLEMENTAL DATA LISTS:

An item count has been added to the lists for Supplemental Data Tasks, and Supplemental Data Analysis. This enables you to see at a glance how many items are contained in that list.

ABILITY TO SELECT LEVEL 0 DESCENDANTS FOR JOURNAL REPORTS:

 When you run a Journal report, you can now directly select the Level 0 descendants of a parent member. For example, from the Member Selector, you can select Level 0 Descendants of the Total Geography Entity parent member, without needing to first select all the entities for that parent.

INTERCOMPANY ENTITY AGGREGATION OPTIONS:

Two additional Intercompany dimension aggregation methods "Subtraction" and "Ignore", in addition to the existing default "Addition" have been added to the Create Application options. If Subtraction or Ignore are selected, then the selected consolidation operator will be applied to the "Intercompany Entities" member when aggregating to the "Intercompany Top" member. The default selection is Addition. The system entries generated by the Standard Eliminations process will also be amended to post the required additional entries should Subtraction or Ignore be selected. Note that the seeded consolidation rules are designed to work with the Addition option so will need to be amended should the Subtraction or Ignore options be selected. Also note that these options are only available during application creation and cannot be enabled after an application has been created.

YEAR-TO-DATE AND JOURNAL-TO-DATE JOURNAL ENTRIES:

 In addition to existing Periodic journal entries, you can now post Year-to-Date and Journal-to-Date journal entries. When you create a journal, you can now select YTD_Input for the View dimension, and then select either of the YTD or JTD options. You can also select Periodic or YTD journals when you run a journal report.

REST API FOR IMPORTING SUPPLEMENTAL COLLECTION DATA:

You can now use a REST API to import supplemental collection data from a file to a collection.

APPLICATION SETTING TO DISABLE VIEW CALCULATIONS:

 Starting with this update, a new option to disable the View calculations is available in Application Settings. This option disables computation and storing of YTD, HYTD and QTD data for data inputs (through forms, data import, Data Management, etc.) in the YTD, HYTD and QTD members.

IMPORTANT! This setting is powerful, and it is recommended that you assess the potential impact before enabling the setting.

 

NARRATIVE REPORTING


UPDATED NARRATIVE REPORTING EXTENSION FOR DISCLOSURE MANAGEMENT:

An updated Narrative Reporting Extension for Oracle Disclosure Management is now available. This update includes general improvements and bug fixes. Download and install the latest Narrative Reporting extension for Disclosure Management to get these changes.

UPDATED NARRATIVE REPORTING EXTENSION FOR SMART VIEW:

An updated Narrative Reporting Extension for Oracle Smart View for Office is now available. This update includes a new message that notifies you if a more recent version of a doclet is available at checkout time, along with other accessibility-related and general improvements and bug fixes.

 

PLANNING

 

WORKFORCE RULES AND FORMS SUPPORT DIFFERENT PLANNING YEARS FOR PLAN AND FORECAST SCENARIOS:

In the Workforce module, rules, templates, and forms have been updated to allow different planning years for the Plan and Forecast Scenarios.

NEW SYNCHRONIZE MENU COMMAND WHEN CREATING DATA MAPS THAT INCLUDE STRATEGIC MODELING MODELS:

In Strategic Modeling or Planning, when you're creating a data map that includes a Strategic Modeling model, if a newly created Strategic Modeling model doesn't appear in the Model list, a new menu command-- Synchronize--is available.

NEW AUDIT TYPE TRACKS CHANGES TO VARIABLES:

There is now an audit type, called Variables, that tracks changes, additions, and deletions to user and substitution variable definitions and values.

REST API TO SORT MEMBERS FOR MODULE APPLICATIONS:

You can now use a REST API to sort members for Module applications. Previously, this feature was only available for Planning and Free Form applications. For example, you can alphabetize a list of child members by sorting in descending order to help users quickly locate members in hierarchies in the dimension editor. This feature is only supported for Planning, Module, and Free Form applications. In Module applications, you cannot sort these dimensions: dense dimensions and the Plan Element dimension from Financials and Project Element dimension from Projects (even if they are renamed).

MANAGE APPLICATIONS WITH ADMIN EXTENSION IN SMART VIEW (MAC AND BROWSER):

Service Administrators can now deploy and use the Admin Extension in Oracle Smart View for Office (Mac and Browser) to create and manage applications in Planning and Planning Modules.

DISPLAY OF LONG ALIAS NAMES WITHIN MEMBER SELECTOR:

You can now see full alias names within member selector in the Web interface without these values being truncated.

NEW PLANNING FORMULA EXPRESSION IN CALCULATION MANAGER:

Calculation Manager now supports a new Planning Formula Expression to leverage the Module Scenario Fiscal Year setting: isPlanStartYearSameAsCurrentFiscalYear.

 

TAX REPORTING

 

ITEM COUNT ADDED TO SUPPLEMENTAL DATA LISTS:

An item count has been added to the lists for Supplemental Data Tasks, and Supplemental Data Analysis. This enables you to see at a glance how many items are contained in that list.

REST API FOR IMPORTING SUPPLEMENTAL COLLECTION DATA:

You can now use a REST API to import supplemental collection data from a file to a collection.

NEW CONSOLIDATED ETR IFRS TAX RATES BY ENTITY FORM:

With this release, you can now override Consolidated ETR IFRS global tax rates (National and Regional/Local) to calculate Consolidated ETR IFRS rates by Entity using a specific entity-level tax rate. You select the specific Entity on the new Consolidated ETR IFRS Rates form, and enter the override National and Local tax rates for the calculation.

TAX AUTOMATION BY INTERCOMPANY PARTNER AND RELATED TAX CALCULATIONS:

With this release, customers can select data from an Intercompany Partner source (for instance, ICPTop, Intercompany [Member], and so on) to perform intercompany eliminations for tax reporting, such as Intercompany dividends, revenue and expense. When performing intercompany eliminations by setting an attribute on the profit account, you can now tax effect the elimination, for instance, intercompany dividends.  

TAX AUTOMATION BY SCENARIO:

With this release, customers can select data from a Source Scenario, and automate the data to a different selected Scenario. As a result, customers will be able to automatically copy data from one Scenario to another. For instance, copy data from a GAAP Scenario to a Statutory Scenario.

Synopsis of EPM Cloud Updates - May 2020

ENTERPRISE PERFORMANCE MANAGEMENT CLOUD - MAY 2020 UPDATE

 

EPM CLOUD COMMON

This section contains announcements related to the common EPM Cloud components such as EPM Automate, Migration, Access Control, Data Integration, and Smart View for Office.

 

NEW TOPICS IN EPM CLOUD OPERATIONS GUIDE:

Ø      The EPM Cloud Operations Guide has been enhanced with these additional topics:

Ø      Best practices for designing business rules

Ø      How to avoid the functional errors in business Rules.

Ø      Managing Content Upgrade Issues

Ø      Handling Issues with Cross-Environment Connections

Ø      Troubleshooting ERP Integration Functional issues

Ø      Requesting Merge Back of Environments

Ø     Requesting Oracle to Apply Monthly Update to Production Environments Prior to the Third Friday.

NEW ROLE ASSIGNMENT REPORT FORMAT:

The Role Assignment Report has been modified to include ional information such as the user login, first name, last name, email address, pre-defined and application roles of EPM Cloud users, and how these roles are granted. Previously, the Role Assignment Report listed user logins, roles, and how the roles were granted only.

PRE-DEFINED ROLE NAMES AS EPM KEYWORDS:

Starting with this update, Oracle will treat certain pre-defined role names as EPM Cloud key words, which cannot be used in the name of any artifacts that you create; for example, as a group name in Access Control.

ADDRESS FOR OUTGOING EMAILS:

Starting with this update, emails originating from EPM Cloud applications will use no.reply@oraclecloud.com  instead of oraclecloudadmin_ww@oracle.com  as the from address. Emails from other Oracle Cloud sources, for example, New Account email sent from the Identity Domain, will continue to use the current From email addresses, for example, oraclecloudadmin_ww@oracle.com.

EPM AUTOMATE UPDATES:

A new version of EPM Automate with these changes is available:

The roleAssignmentReport command now generates a report that lists the first name, last name, email address and pre-defined and application roles of EPM Cloud users. Previously, the Role Assignment Report listed user names and roles only.

The replay command now accepts an optional parameter to encrypt all passwords included in the replay replay file. The replay command works only with Planning, Financial Consolidation and Close, and Tax replay Reporting business processes.

NEW EXCEL SERVER SETTINGS IN FINANCIAL REPORTING:

Three new Excel server settings are available to use in Financial Reporting reports.

MANAGE USER POINT OF VIEW:

New Functionality to Manage the User Point of View in Financial Reporting Web Studio.

ABILITY TO FILTER EXCLUDED MEMBERS FROM SEGMENT DROP-DOWN MEMBER SELECTOR:

Service Administrators can now choose to display or filter out excluded hierarchy members in the row dimension drop-down member selector on a form. To filter out the excluded members, Service Administrators set the new application configuration option, "Filter Out Excluded Members in Segment Dropdown," to Yes. To display the excluded members and allow users to select them from the member selector drop-down, set this option to No.

REST API TO MANAGE PERMISSION FOR MANUAL ACCESS TO DATABASE:

You can now use a REST API to manage permission for manual access to database by Oracle. This gives you the ability to allow or disallow Oracle personnel to manually access your database in emergency situations when an environment is unresponsive and you have not yet created a service request to investigate the issue.

RUN INTEGRATION ENHANCEMENTS IN DATA INTEGRATION:

Several enhancements have been added to the Run Integrations page such as the placement of the Run Integration icon, new Source Filters tabs, and new processes submitted icons on the execution pop-up.

NEW EPM INTEGRATION AGENT SQL QUERY CONDITIONS:

New SQL Query Conditions are Supported in the EPM Integration Agent

INITIALIZING ORACLE NETSUITE APPLICATIONS:

Oracle NetSuite data source application names are modified after initialization.

EIGHT NEW ASO FUNCTIONS IN CALCULATION MANAGER:

Eight new ASO functions: @FIRSTSIBLING, @LAGGEN, @LAGLEV, @LASTSIBLING, @NEXTLEVMBR, @LEADGEN, @LEADLEV, and @PREVLEVMBR are now available in Calculation Manager.

 

ACCOUNT RECONCILIATION

 

AGGREGATING TRANSACTION MATCHING DATA USING DATA MANAGEMENT:

There is now an option available in Data Management to allow aggregation of Transaction Matching transactions that enables you to roll up transactions to a summary (higher) level of detail. NOTE:  To use this feature, a new Target must be created.

NEW LENGTH FUNCTION TO CALCULATE LENGTH OF A STRING:

A new LENGTH function is now available to calculate the length of a string. This function takes a text value as a parameter and returns an integer, which is the number of characters in the text.

CSV (FORMATTED) OUTPUT TYPE AVAILABLE FOR REPORTS:

You can now generate a predefined or custom report in CSV (Formatted) output format that supports template based CSV file generation.

ITEM COUNT ADDED TO LISTS:

An item count has been added to the following lists in Account Reconciliation:  Profile List, Reconciliation List, Transactions List, Reconciliation Balances List, Detail Balances List, and Matching List to enable you to see at a glance how many items are in that list.

DISABLING THE AMORTIZATION/ACCRETION FEATURE FOR ADJUSTMENTS:

A Service Administrator can now disable the amortization/accretion feature in Balance Explained or Adjustments using a checkbox in the Transaction Detail of a Format.

NEW DATA EXCHANGE CARD ADDED FOR DATA INTEGRATIONS:

A new "Data Exchange" card is available under Applications that allows you to access the EPM Integration Agent functionality. Using the EPM Integration Agent, you can extract data from your on-premises data sources and then load the data directly to the Oracle Enterprise Performance Management Cloud.


ENTERPRISE DATA MANAGEMENT


COLLABORATE WITH USERS ON REQUESTS IN SUBMIT STAGE:

To facilitate multiple users participating on a request, the request assignee can ask additional users to collaborate on Draft and Pushed Back requests in the Submit stage. Collaborators can be added or removed from a request. Collaborators are notified of requests in which they were asked to collaborate.

CONCURRENT EDITING OF REQUESTS:

When multiple users are collaborating on the same request, those users may be working on the request at the same time. Concurrent editing allows users to work simultaneously on the request while ensuring data integrity and alerting users of changes made by others.

CONFIGURE BINDING KEYS FOR IMPORT AND EXPORT:

Binding keys are configurable to allow for customization of how data is imported into and exported from bound viewpoints. Binding keys are displayed and edited in the Binding Inspector.

CUSTOM BRANDING, APPEARANCE OPTIONS, AND NEW DEFAULT THEME:

Appearance options are available to customize the look and feel of the Enterprise Data Management Cloud user interface. Service administrators can upload their own logo image and background image as well as choose a theme. These custom settings are applied to the user interface for all users.

DATA TYPE PARAMETER OVERRIDES FOR NAME AND DESCRIPTION PROPERTIES:

Data type parameters for the core Name and Description properties can be edited at the application or node type level to override the original values set during application registration. This is helpful to customers who need to ensure that these data values conform to their business rules.

DEFAULT AND ALTERNATE ASSIGNEES FOR SUBSCRIPTIONS:

Subscriptions can be configured with default and alternate assignees to allow subscription requests for target viewpoints to be assigned to multiple users. The default assignee is a single user who has subscription requests normally assigned to them. Alternate assignees are users or groups who can be assigned requests when there is no default assignee for a subscription, or the user is out of office.

INSPECT PROPERTY DEFINITION FROM PROPERTY PANE:

A property can be inspected directly from the property pane for a selected node in a viewpoint. A link is available in the Property Details popup window to inspect the property. This allows the property inspector to be easily accessed in order to verify and make changes to property parameters.

PROCESS DELETES AND REORDERING OPTIONS FOR MERGE IMPORT:

Additional options are available for the Merge import mode, giving the user the ability to process deletes and reordering of nodes which may happen in an import source. These actions do not happen during a normal merge import process but are sometimes necessary for Enterprise Data Management to match the import source.

REMOVE AND DELETE TRIGGER ACTIONS FOR CUSTOM VALIDATIONS:

Custom validations can be configured with Remove and Delete as trigger actions to enable the validations to run for request items which include those actions. This allows specific custom validations to run only for nodes which are removed or deleted from a viewpoint in a request. This is helpful when you want to prevent nodes from being removed or deleted, or to prevent invalid data resulting from a removed or deleted node.

REQUEST ITEM VALIDATIONS FOR DERIVED PROPERTIES:

Derived property values are now validated for request items in a request to prevent invalid values resulting from changes made in a request. System, application-specific, and custom validations are run for derived properties of nodes in viewpoints where request actions were performed. Derived properties can be validated for any type of request including interactive, subscription, and import requests.

RESIZABLE PROPERTY PANE:

The property pane for a selected node in a viewpoint can be resized using a drag and drop splitter located between the grid/tree and property pane for the viewpoint. This enables properties with long labels or values to be more easily viewed in the property pane.

USER MENTIONS IN REQUEST COMMENTS:

Users can be mentioned in request and request item level comments providing a way for collaborators to ask questions or make other users aware of what they did to a request. When @ is entered into a comment, a list of request users is available to select from. After the comment is saved, mentioned users are notified of the comment so they can review it and take immediate action on the request.

USER PREFERENCES FOR PROFILE IMAGE, LANGUAGE, AND OUT OF OFFICE:

Users can configure their own preferences for profile image, language, and out of office. The Profile Image is displayed for the user on pages where an avatar is used. The Language preference controls the language for labels and messages displayed in the user interface for the user. The Out of Office preference signifies the user is unavailable and requests should not be assigned to them. User preferences are accessible for a logged in user from the Settings and Action menu.

VALIDATIONS DISABLED FOR PREDEFINED MEMBERS IN EPM CLOUD DIMENSIONS:

For Planning or Financial Consolidation and Close viewpoints, many application-specific validations have been disabled for nodes imported as predefined members (Enterprise Predefined Member = True).


FINANCIAL CONSOLIDATION AND CLOSE


NEW EPM AUTOMATE VERSION:

A new version of EPM Automate is available. This version includes the copyOwnershipData, exportOwnershipData, importOwnershipData, recomputeOwnershipData, and importSupplementalCollectionData commands. This version also contains changes to the replay command, which now accepts an optional encrypt parameter to encrypt all passwords included in the replay file. Additionally, the roleAssignmentReport command now generates a report that lists the user login, first name, last name, email address, pre-defined and application roles of EPM Cloud users, and how roles are assigned. Previously, the Role Assignment Report listed only the user log in, roles,and how roles are assigned.

PERFORMANCE SUBSTITUTION VARIABLES:

The following Substitution Variables can be enabled to improve performance: EnableSimpleAggregation OptimizeDBRefresh OptimizeYTDCalculation OptimizeConcurrency NOTE: The degree of performance improvement varies widely across different applications as it is purely driven by the application design and data distribution.

NOTE: The degree of performance improvement varies widely across different applications as it is purely driven by the application design and data distribution.

SUPPLEMENTAL DATA MANAGER ENHANCEMENTS:

Supplemental Data Manager has been enhanced with several new features, including configurable collection intervals, form-related changes, deployment enhancements, and dashboard capabilities.

Ø      New Collection Intervals allow you to customize your data collections tailoring the POV to your specific collection needs.

Ø      Data sets have been renamed to Collections and have been enhanced to allow Sub-Collections which allow finer detail data collections.

Ø      New Collection option to ensure data collection security which will prevent the sharing of data entered on different collection forms.

Ø      Forms have been enhanced to include header data and multiple detailed line item data entry areas on a single section.

Ø     The redeployment process has been optimized to minimize the impact to any ongoing collection process preserving the current workflow and data entered on existing forms.

TASK MANAGER - ABILITY TO VIEW INSTRUCTIONS IN TASK LIST VIEWS:

You can now easily see if a task includes instructions within the Schedule Task and Template Task lists. Users can add a new Instructions column to their list view and see the textual instructions for the task.

MODIFYING SEEDED ACCOUNTS - ACCOUNT TYPE AND CONSOL OPERATOR:

Service Administrators can now make property changes to seeded members of the Account dimension to customize them as needed. You can change the Account Type and the Consolidation Operator (for the Consol cube only). Ensure that you run Metadata Validation after making the changes to confirm that the changes are valid.

To export and import the changes for the seeded member, you must use the Module Customization Migration artifact (LCM). Exporting and then Importing CSV files will not retain your attribute changes for seeded members.

RUNNING ON-DEMAND RULES IN A FIX:

By default, On-Demand Rules are run in FIXPARALLEL. The FIXPRALLEL will include members from the six Run Time Prompts (RTP): Scenario, Year, Period, Entity, Consolidation, and Currency. If you need to run same ODR in a FIX, you can define a substitution variable.

You can add a substitution variable by name _FP. For example, if rule name is ODR - Calculate Sales, you should name the variable as ODR_CALCULATE_SALES_FP. Note that the hyphen in rule name is replaced with underscore in variable name and there are no spaces in the variable name.

ITEM COUNT ADDED TO LISTS:

An item count has been added to the following Task Manager lists: Schedule Tasks, Alerts, and Template Tasks. This enables you to see at a glance how many items are contained in that list.

NEW LENGTH FUNCTION TO CALCULATE LENGTH OF A STRING:

A new LENGTH function is now available to calculate the length of a string in Calculation Attributes in Task Manager and Supplemental Data Manager. This function takes a text value as a parameter and returns an integer, which is the number of characters in the text.

CSV (FORMATTED) OUTPUT TYPE AVAILABLE FOR REPORTS:

You can now generate a predefined or custom report in CSV (Formatted) output format that supports template based CSV file generation.


NARRATIVE REPORTING


EXTENDING THE DOCUMENT ENTITY INFORMATION NETWORK FOR SEC:

In Disclosure Management, you can now add the missing elements to the Document Entity Information (DEI) Element to the Taxonomy Template DEI Sheet, which are supported to match the SEC validation requirements.

UPDATED NARRATIVE REPORTING EXTENSION FOR DISCLOSURE MANAGEMENT:

An updated Narrative Reporting Extension for Oracle Disclosure Management is now available. This update includes general improvements and bug fixes. Download and install the latest Narrative Reporting extension for Disclosure Management to get these changes.


PLANNING


NEW OPTION IN FINANCIALS TO MAKE PAST PERIODS READ ONLY:

When you enable weekly planning in Financials, you can now specify an option to make past weekly periods read only in the Forecast scenario.

NEW CHART TYPE SETTING IN DASHBOARDS - PLOT MISSING VALUES AS ZERO:

There is now a dashboard chart type setting for select chart types, called Plot Missing Values as Zero, that allows you to disable plotting missing or suppressed data as zeros.

NEW EXAMPLES FOR RUNNING RULESETS WITH PARAMETERS USING REST APIS:

You now have access to additional examples that illustrate how to run rulesets with parameters using REST APIs. Adding parameters gives you greater flexibility, and the examples help you quickly get productive when running this job.

NEW CAPABILITIES FOR CREATING GROOVY BUSINESS RULES:

When working with Groovy business rules, you can take advantage of new features to execute ASO allocation scripts and custom calculation scripts against a cube. You can also use new utility APIs in EpmScript. This gives your business rules more power and flexibility.


PROFITABILITY AND COST MANAGEMENT


There are no new Profitability and Cost Management specific features in this update.

 

TAX REPORTING


SUPPLEMENTAL DATA MANAGER ENHANCEMENTS:

Ø  Supplemental Data Manager has been enhanced with several new features, including configurable collection intervals, form-related changes, deployment enhancements, and dashboard capabilities.

Ø  New Collection Intervals allow you to customize your data collections tailoring the POV to your specific collection needs.

Ø  Data sets have been renamed to Collections and have been enhanced to allow Sub-Collections which allow finer detail data collections.

Ø  New Collection option to ensure data collection security which will prevent the sharing of data entered on different collection forms.

Ø  Forms have been enhanced to include header data and multiple detailed line item data entry areas on a single section.

Ø  The redeployment process has been optimized to minimize the impact to any ongoing collection process preserving the current workflow and data entered on existing forms.

TASK MANAGER - ABILITY TO VIEW INSTRUCTIONS IN TASK LIST VIEWS:

You can now easily see if a task includes instructions within the Schedule Task and Template Task lists.  Users can add a new Instructions column to their list view and see the textual instructions for the task.

OWNERSHIP CONSOLIDATION METHODS:

The Ownership percentage ranges for the system Consolidation methods have been changed.  The ownership ranges and system methods are: 0% - Not Consolidated > 0% to <=50% - Proportional > 50% to <=100% - Subsidiary

NEW LENGTH FUNCTION TO CALCULATE LENGTH OF A STRING:

A new LENGTH function is now available to calculate the length of a string in Calculation Attributes in Task Manager and Supplemental Data Manager. This function takes a text value as a parameter and returns an integer, which is the number of characters in the text.

CSV (FORMATTED) OUTPUT TYPE AVAILABLE FOR REPORTS:

You can now generate a predefined or custom report in CSV (Formatted) output format that supports template based CSV file generation.

ITEM COUNT ADDED TO LISTS:

An item count has been added to the following Task Manager lists: Schedule Tasks, Alerts, and Template Tasks. This enables you to see at a glance how many items are contained in that list.

NEW EPM AUTOMATE VERSION:

A new version of EPM Automate is available. This version includes the new importSupplementalCollectionData command and changes to the replay command, which now accepts an optional encrypt parameter to encrypt all passwords included in the replay file. Additionally, the roleAssignmentReport command now generates a report that lists the user login, first name, last name, email address, pre-defined and application roles of EPM Cloud users, and how roles are assigned. Previously, the Role Assignment Report listed only the user log in, roles,and how roles are assigned.

 

June 11, 2020

Coupling the right Business & ERP Strategies - A Road to success in Mergers & Acquisitions/ Divestitures

 

Global businesses keep facing constant challenges both within and outside such as Changing customer behavior, Technological disruptions, Dynamic geo-political landscape, Intense competition, Financing difficulties, Dynamic workforces etc. Global Health Pandemic is the new addition in this list.

Mergers and Acquisition (M&A) is one of the key interventions that these global corporations adopt to cautiously navigate in tough business environments. A comprehensive and fully aligned IT and ERP strategy, that works cohesively with the underlying business strategy, becomes a key ingredient of the success of the M&A.

On a global scale, merger & acquisitions (M&As) have been growing over the years. In 2019, there were about 50,000 transactions valued at US$ 3.8 trillion. (Source: IMAA website)

This point of view is an attempt to throw light on the key aspects pertaining to M&A /Demergers, how the alignment of the ERP strategy with overall M&A /Demerger objectives, had helped these corporations draw maximum benefit out of organizational consolidation transactions.

The typical objectives/drivers for M&A would be

  • Gain access to new markets, geographic locations, consumer groups
  • Achieve synergies through consolidation and collaboration
  • Realize benefits through complementing (as opposed to competing) strengths
  • Achieve non-linear increase in scale of operations and service delivery
  • Pave way for entry to diversified industry segments


Over the years the business strategies after M&A /Demerger had been broadly classified into 3 types:

  The success of the M&A /demerge largely lies on the right ERP strategies and correct coupling and decoupling approach taken up by these entities.

ERP Strategies

  • Need varies for business to business
  • Alignment to overall M&A/demerger objectives
  • Depends on the Line of Business (LoB), Size, Type, Industry operated etc
  • Existing ERP status
  • Existing ERP Product support availability horizon -Example a specific version may not be supported after a year or so.
  • Risk appetite etc
  •  












Choosing the RIGHT ERP system, is the most important decision in M&A or demerger Post-facto operations. It should align with the overall Business Strategy and with a clear Risk and Risk mitigation strategy analyzed for all possible scenarios.

Possible scenarios include

  • Acquired Company adopting acquiring company's ERP / merging entity adopting base entity's ERP

  • Acquiring company adopting Acquired company's ERP / base entity adopting merging entity's ERP

  • Retain existing ERPs, have common reporting platform as an add-on (Example - Hyperion or any BI Reporting Tool)

  • Both moving to a NEW ERP system as applicable to Business (For example - If both are on the verge of Sunset with their legacy systems)

  • Both on SAME ERPs - Simple, BUT YET NOT so simple - Still some synergies may be needed (Diff Processes, Version etc)

At a more granular level it can be

  • Inventory Org Consolidation

  • Operating Unit Consolidation

  • Instance/Environment Consolidation

 

In case if the Target Application would be a NEW ERP, following Key Parameters can be considered in choosing the right one:


The typical challenges in the ERP Integration for M&A /Demerger could be classified into Five main pillars.












 Infosys solution framework/approach revolves around addressing the above key challenges.

High-level framework is as given below:

Key Challenges

Infosys Solution Approach

Business Process Alignment

Business Process Mapping exercise

Ø  Convergence/Divergence exercise

Ø  Classify as Common, Unique, New etc

Ø  Construct a Business Process Reengineering (BPR) wherever possible

Master Data Alignment

Establish

Ø  Clear Strategy

Ø  Data Standards

Ø  Process

·         De-duplication

·         Consolidation

·         Joint Migration

Reporting Mechanisms

Ø  Joint Balance Sheet

Ø  Separate P&L

Ø  Separate Internal reporting

Ø  Define reporting consolidation approach (Live Vs Analytical)

Ø  Standardize processes, tools and data reservoir strategy

Legal/Localization requirements

Depending on the geography - Example - Europe, India.

Data Security (Relevant in the interim period)

       Master Data

       Transactional Data

Options include

Ø  Masking

Ø  Scrambling etc

thus, making data access secure during the co-existence period for both the entities.

 

Infosys also has multiple tools and accelerators that can enable the smooth implementation of the ERP Strategies as part of the M&A /Demerger activities such as process review checklist dos and don'ts, comprehensive business process listing and flows, configuration questionnaire wizard, configuration documents, test scripts, which help the ERP implementation /rollout projects to be done in an accelerated deployment model.

Conclusion:

Dynamics and challenges associated with M&As have been very widely documented, discussed and there is a constant effort by organizations to make them successful. ERP systems integration is a key determinant of M&A success and Infosys, armed with depth of knowledge, learnings & experience gained through multiple engagements is strongly poised to advise and partner with organizations in this compelling strategic intervention.

-----------

Authors

Murali Krishnan Santhanam (murali_santhanam@infosys.com) 

Prabhoo Kannan (PrabhooK@infosys.com)



Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter


Archives