Tag Archive for: EPM

See how GenAI will work in your ERP and EPM

Oracle is delivering AI as part of the Oracle Fusion Cloud Applications Suite quarterly updates, and that means exciting changes are in store for Oracle Cloud EPM and ERP.

GenAI in Narrative Reporting in Oracle EPM

This demo shows how AI can help financial managers respond to changing circumstances by updating roll-forward reports used for financial planning.


Why it matters: This vision demo shows where Oracle is headed with embedded generative AI in Oracle Cloud EPM. Note that AI-generated output isn’t just reviewable by end users; it is also editable. This preserves oversight by skilled financial professionals. The demo also shows how easy it is to incorporate AI-generated insights into reports: GenAI drafts the content based on simple prompts, live data, and forecasts, and it is capable of creating charts and updating summaries based on new information provided.



GenAI in Project Planning in Oracle ERP

This demo shows how AI in Oracle Cloud ERP Project Management helps build a dynamic project plan that optimizes resources to meet both financial objectives and customer needs.


Why it matters: This vision demo shows how project managers get a fast and efficient way to develop plans with a high degree of flexibility, all with the benefit of human oversight and control. Operations and financial managers will appreciate how AI delivers early visibility into each project’s financial viability and risk profile. And everyone involved will value the ease with which resources and schedules can be adjusted to meet project needs


Oracle Fusion Cloud ERP Generative ERP Feature: Project Planning


Summing up

Oracle are using AI to reshape Fusion Apps, creating valuable use cases across ERP, EPM, and other functional areas.  Don’t miss the recent announcement covering new GenAI capabilities, and be ready for more to come.

Contact us for additional information on how you can use AI as part of an Oracle Fusion Cloud ERP subscription

EPM Data Integration – Pipeline


Case Study

A client expressed the need for an interface with functionality that would allow non-technical professionals to run daily batches. These batches could include tasks like pulling Actuals, updating the Chart of Accounts (CoA), or refreshing the Cost Centre structure and running the business rules, among others, from the source System.

While seeking a solution, we explored numerous alternatives within Data Integration. However, the challenge emerged as several intricate steps were involved, necessitating individuals to possess a certain level of technical understanding of the Data Integration tool.


Exciting developments ensued when Oracle introduced a new feature known as “Pipeline.”


Pipeline in Data Integration

This innovative addition empowers users to seamlessly orchestrate a sequence of jobs as a unified process. Moreover, the Pipeline feature facilitates the orchestration of Oracle Enterprise Performance Management Cloud jobs across instances, all from a single centralized location.

By leveraging the power of the Pipeline, you can gain enhanced control and visibility throughout the entire data integration process, encompassing preprocessing, data loading, and post-processing task.

Yet, this merely scratches the surface. The Pipeline introduces a multitude of potent benefits and functionalities. We’re delving into an in-depth exploration of this novel feature to uncover its potential in revolutionizing your data integration process.

Enterprise data within each application is grouped as multiple dimensions. Each Dimension has its own Data chain. Registering New application results in the creation of various objects and associated dimensions. An A

Note the following Pipeline considerations

  • Only administrators can create and run a Pipeline definition.
  • Pipeline is a replacement for the batch functionality in Data Management and can be migrated automatically to the Pipeline feature in Data Integration.
  • For file-based integrations to a remote server in the Pipeline when a file name is specified in the pipeline job parameters., the system copies any files automatically from the local host to the remote server automatically under the same directory.

This function applies to the following Oracle solutions:

  • Financial Consolidation and Close
  • Enterprise Profitability and Cost Management
  • Planning
  • Planning Modules
  • Tax Reporting

Proof of Concept

  EPM batches to run sequentially are:

Stage 1 – Load Metadata
  1. Load Account Dimension
  2. Load Entity Dimension
  3. Load Custom Dimension
  4. Clear current month Actuals (to remove any nonsense numbers if any)
Stage 2 – Load Data
  1. Load Trial balance from Source
Stage 3 – Run Business Rule
  1. Run Business rule to perform Aggregate & Calculations.

The workflow for creating and running a Pipeline process is as follows:

  1. Defining Pipeline

  1. Pipeline Name, Pipeline Code, maximum Parallel Jobs
  2. Variable page to set the out-of-box (global values) for Pipeline are available from which you can set parameters at runtime. Variables can be pre-defined types like: “Period”, “Import Mode” etc.


  1. You can utilize Stages in the Pipeline editor to cluster similar or interdependent Jobs from various applications together within a single unified interface. Administrators can efficiently establish a comprehensive end-to-end automation routine, ready to be executed on demand as part of the closing process.

Pipeline Stages & Container for multiple jobs as shown below:

Stages & Jobs example


The new stages can be added by simply using the Plus card located at the end of the current card sequence.


  1. On the Run Pipeline page, Complete the variable runtime prompts and then click As shown below:



Variable Prompts


When the Pipeline is running, you can click the status icon to download the log. Customers can also see the status of the Pipeline in Process Details. Each individual job in the Pipeline is submitted separately and creates a separate job log in Process Details.

Users can also schedule the Pipeline with the help of Job Scheduler.

Variable Prompt



Amir Kalawant

Oracle Fusion Cloud EPM – 23.08 Update

EPM Cloud August Update

Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 4, 2023.

Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 18, 2023.



The Oracle Help Center provides access to updated documentation. The updates will be available in the Help Center on Friday, August 4, 2023.

NOTE: Some of the links to new feature documentation included in this readiness document will not work until after the Oracle Help Center update is complete.

Updated documentation is published on the Oracle Help Center on the first Friday of each month, coinciding with the monthly updates to Test environments. Because there is a one-week lag between the publishing of the readiness documents (What’s New and New Feature Summary) and Oracle Help Center updates, some links included in the readiness documents will not work until the Oracle Help Center update is complete.



Software issues addressed each month and considerations are posted to a knowledge article on My Oracle Support. Click here to review. You must have a My Oracle Support login to access the article.

NOTE: Fixed issues for EPM Cloud Common components (Smart View for Office, EPM Automate, REST API, Migration, Access Control, Data Management/Data Integration, Reports, Financial Reporting, and Calculation Manager) are available in a separate document on the My Oracle Support “Release Highlights” page.

The full Oracle advisory note can be found here

Introduction to Oracle Tax Reporting Cloud



Tax reporting (from Oracle) is an incredible application to increase the efficiency of the tax function.

With the rise of digital economies, governments across the world are finding ways to tax the digital income generated from their country. OECD is working on details of the digital tax so that companies and governments can work more efficiently. Meanwhile, France/UK are ready to tax digital companies with their own digital taxes.

In this world of uncertainty, governments are looking to increase their tax revenue and making changes to the tax laws accordingly. It is expected that companies should calculate their tax obligation correctly as per the latest tax codes in that jurisdiction.

However, tax functions in many companies are still using Microsoft spreadsheets to prepare tax calculations. These calculations might be prepared at an entity level in a spreadsheet and then sent to a regional or global the tax function using email. Tax experts review tax calculations at group level and if there are issues with the tax calculation of an entity or formula errors, the spreadsheet is sent back to the local team for correcting or updating. There is so much to and fro of the spreadsheets that tax and finance teams can easily lose track of the versions and corrections. Sometimes tax calculation models refer to many linked spreadsheets which creates further complexity when the spreadsheets need to be updated for a new account, changes in legislation or accounting standards. Formula errors can exist in the spreadsheets that are difficult to identify and correct. The other issue is that the tax models may be maintained and updated by one team member. If that team member leaves the company, there is a big risk to the tax process and financial close. These are a few of the pain points, bottlenecks and risks with using spreadsheets to prepare tax calculations.

Tax reporting is a web-based cloud solution, which has inbuilt functionality for:

  • Configurable tax calculation rules
  • Automatic calculation of tax expense, DTA/DTL
  • Approval process
  • Roll forwarding of tax accounts
  • Loading trial balance data
  • Load fixed assets data
  • Currency translations
  • Consolidation
  • Calculate Effective Tax Rate
  • Reports on local/ regional /state / national tax data
  • Produce tax accounting journal entries
  • Country by country reporting
  • Capture supplemental data for tax calculations and additional disclosure
  • Maintained by the tax and finance users



The tax reporting solution provides tax departments with the ability to meet global tax reporting requirements on an ongoing basis and ensure compliance with changing tax regulations.

We can help with implementing Oracle’s tax reporting solution for your organization and provide guidance on how to get the maximum value out of it.