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

« December 2019 | Main | February 2020 »

January 28, 2020

Flabbergasted with hefty taxation at last moment! EPM Tax Reporting is your partner to save you!

Corporate tax function will be effective and transparent only if there is proper access to financial data and processes. Tax Reporting is a one-stop tax provisioning solution for multi-national organizations reporting under GAAP or IFRS principles to calculate tax provision by legal entity.  Solution involves several stages of Corporate Tax Provision, which includes automation of tax, collection of data, calculating tax provision, automating return-to-accrual, reporting and analysis for tax, Country-by-Country (CbCR) reporting.  

Tax Reporting uses platform as firm close process and can directly be integrated using the same metadata. When organization accounting finalizes period end close process with all required numbers--such as permanent and temporary variances, tax rates, currency exchange rates--feed into system, Tax Reporting module automatically calculates tax provisions.

Tax provision Process

Tax_Flowchart_1.png

         

















 Steps involved Tax Provisioning:

  •        Administrator loads trial balance data in Tax Reporting and triggers tax automation process
  •          Load tax rates and non-automated amounts using pre-build web-forms or Smart View
  •          Load Any other provisions
  •          Load Return to Accrual numbers
  •          Adjustments for removing trial balance differences  

After inputs, the system calculates mainly:

  •          Current Provision number
  •          Deferred Provision number
  •          Effective Tax Rate

Below reports and forms mainly will be available after Tax Provision process for the business:

·         Current Provision numbers

·         Deferred Tax numbers

·         Tax Journal Entry and Tax Footnote


Tax Reporting Home screen :

Tax_2.png

 











Current Provision Web-Form :

Tax_3.png


















Deferred Tax Web-form :

Tax_4.png

















Integration with Business Process:

Tax Reporting built in EPM cloud has seamless integration with Oracle ERP cloud, Oracle E-Business suite, PeopleSoft, JDE etc and other on-premise Hyperion products like Hyperion Financial Management.

Reference(s):

https://docs.oracle.com/en/cloud/saas/tax-reporting-cloud/agtrc/GUID-D15DDEC8-E4AC-47C4-9548-195FAB9CEE7C.pdf




January 24, 2020

Driver Based Planning for Confectionery/FMCG Business

Driver Based Planning for Confectionary/FMCG Business

For any FMCG/Confectionery Major to grow continuously and to maintain its position in the market, the organization has to develop the DNA to innovate and invest on new markets to arouse new consumption habits, aiming a growing target, especially with the Research and Development department, one of the main forces of the company, bringing daily new confectionery concepts. One of the Key areas is to get the profitability of their various brands and even SKUs in different geographies or regions and even by customers. The organization can then make their long term decisions based on this analysis. These decisions could be:

list1.png

And many more, based on the organizations needs and requirements.

To gather such analysis, we would require several data points at a regular intervals and we need to analyze the cost of collections of these data points should be less than the benefits that we accrue by making decisions from them.

We had provided a similar solution to one of our clients. The client ask was very specific as below:

Getting Profit and Loss statements at the below levels:

BE.png

 

Now, with so much data coming at regular intervals, it may be easy to get the revenues generated for each SKU, region, Customer etc, but it becomes quite difficult to manually enter costs for the same and there we would need drivers which would not only help us allocate various costs spend at overall organization level to each SKU, but also specific spends at brand level to be allocated to each SKU. Similarly, FMCG business requires a lot of spending on developing the sales channels in terms amount invested on Modern trade, Traditional trade, stockiest and distributors and at the end it becomes quite difficult to identify right drivers so that all these costs would be allocated to right product level.

The biggest challenge in implementing this driver based planning/budgeting/forecasting is getting the people of the organization to be aligned around the basic framework. Each employee of the organization should be provided the clarity as what is their accountability and ownership. Once they have their roles and responsibilities defined and the use of drivers as why we are using them and what their impact would be in the overall scheme of things, they would be able to contribute which would be beneficial to the organization. Though each region or market may have some different drivers but we would have to find some commonality amongst them and simultaneously give options for custom features specific to the market.

Some of the common calculations used are:

Gross Sales(KG) = Volumes(KG)*MRP*ConversionFactor

Conversion Factor(KG) = 100/(No. of units in Each SKU * Grammage of Each unit within SKU)

Calculations of Realization for each SKU based on the channel mix and Market Mix

Calculations of Freight both primary and secondary based on the truck used and the volume of SKU that could be placed on that Truck Volume.

Sea freight in case the Product is imported and the custom duty involved.

Returns, Damages as a percentage of Production.

Expired Products and cost of destruction of returned and expire goods as a percentage of Goods Sold.

Warehouse costs and overhead costs would also matter on the turnover as they are more or less fixed over a tenure with little variable costs. So greater the turnover, lesser the per kg cost allocated.

Taxes and product grants provided to the customer based regions.

Green points based on the norms set by government for each region and geography.

 

The serious problem is if we have good data on drivers. Getting the ratios right for all brands and different SKUs involved. Generally, organizations may use a common driver across all brands and Products involved, but doing so may not result in effective allocations of costs. It is necessary to identify the fixed parts and the variable parts and once we have that clarity we can bring them in the calculations. This would in turn help us perform the break-even analysis and the profitability of each SKU/Product/Brand. If we can gather data to build models to include data from distribution outlets and sales channels, it will be practical to bring that kind of insights into the model which would provide the extra edge to take meaningful decisions. But, we need to be cautious that while building these models is to get too much involved into it theoretically and spreadsheets and not able to correlate this drives with actual business. We would be able to add all the additional details, but it may not bring in that benefits which would help you take insightful decisions. For line items that do not see much movements, driver-based planning is perhaps not the best choice. Traditional or choice-based planning would be better, depending on whether you're dealing with a discretionary or non-discretionary expense.

 

 

 

 

January 23, 2020

Synopsis of EPM Cloud Updates and Upcoming Changes - January 2020

 

EPM Cloud Update - Jan 2020 and Upcoming Changes

 

"EPM Cloud Updates"

"EPM Common"

1." ESSBASE FUNCTIONS SUPPORTED BY CALCULATION MANAGER":

Essbase functions supported by "Calculation Manager in block storage applications" are now included in Calculation Manager Guide and links to all functions is in the Essbase Technical Reference.

2." NEW DOCUMENTATION: ADDITIONAL TROUBLESHOOTING PROCEDURES FOR EPM CLOUD":

For troubleshooting common issues in EPM Cloud are available in "With new sections allowed, start with Oracle EPM Cloud for administrators."

"Financial Consolidation and Close" Service

N/A

"Profitable and Cost Management" Cloud Service

"PCMCS TROUBLESHOOTING CALCULATION ISSUES": To troubleshoot Calculation Issues a new chapter have been included in Administration Guide.

"Account Reconciliation Cloud Service (ARCS)"

N/A

"Enterprise Data Management Cloud Service (EDMCS)"

N/A

"NARRATIVE REPORTING"

N/A

"PLANNING"

N/A

"Tax Reporting"

NEW DATA EXCHANGE CARD FOR DATA INTEGRATIONS: Data Sharing is available now under Applications from the "Information Exchange" card. You may construct a data sharing from the Data Integration tab, or execute an existing integration.  

UPCOMING CHANGES

 "NEW EPM CLOUD INTERFACE"

A redesigned gui with improved navigation, and introduced theme named Sky Blue, will be accessible in a future update.

In EPM Cloud the following business processes must embrace this implemented theme as their default interface:

  • Planning

  • Profitability and Cost Management

  • Account Reconciliation

  • Strategic Workforce Planning

  • Sales Planning

  • Financial Consolidation and Close

  • Tax Reporting

The updated interface maintains existing features and enhances the experience with a more modern, responsive look and feel, and design. Upon resizing, the Welcome Panel and the Global Header re-adjust,which means less scrolling. An updated Welcome Panel includes notifications and announcements Home Page contains arrows to utilize you navigate easily between the pages of the Springboard and the dashboard infolet. A larger Navigator Menu has improved usability, many customization themes are added & larger area of work has more maneuvering space and greater visibility. The interface also complies more closely with other Oracle products, like Fusion Applications.

Once the interface is released, all new customers will benefit from the new lighter-colored Sky Blue theme and existing customers will keep their current theme. Using Tools, you can switch themes, and then Appearance.

"PLANNER ROLE TO BE RENAMED AS USER"

Oracle will rename the predefined role of Planner EPM Cloud as User in a forthcoming update. This update will have no functional impact.

Subscriptions issued prior to the May 2016 update used the Planner role, which was retained for continuity in subsequent updates. The Planner role in subscriptions that were activated after May 2016 was already replaced by the User role.

"NOTE: This change will affect Planning, Financial Consolidation and Close, and Tax Reporting only."

"REMOVAL OF INSTANCE NAME FROM PREDEFINED ROLE NAMES"

Now, in the EPM Cloud Environment Access Control screens, the predefined role names prefix the instance name to the INSTANCE NAME ROLE NAME format. These are stored in this format also in the snapshots, making it hard to move snapshots from one instance to another.

To allow security migration through EPM Cloud environments, Oracle is planning to rename the predefined function names displayed within EPM Cloud applications by removing the prefix for the case name. For instance, if the instance name is Plan1, predefined role names are Plan1 Service Administrator, Plan1 Power User, Plan User, and Plan Viewer, the new role names will be Service Administrator, Power User, User, and Viewer.

NOTE: This update won't impact how the role names are displayed in the "MyServices customer portal".

The transition will not affect customers who currently use predefined roles to handle the provisioning and access to resources at application-level. Oracle should make sure that all assignments to task positions and protection assignments for objects are modified automatically after the roles are renamed. This move makes it easy to move objects from EPM Cloud to different environments. This change is implemented to address feedback from the customers. Please contact Oracle Support if you have any concerns regarding this change.

 "PREDEFINED ROLE NAMES AS EPM CLOUD KEY WORDS"

Starting with an update soon, Oracle intends to consider the roles below as keywords for EPM Cloud, which should not be used in the name of any custom artifacts you create; for instance, as a group name in Access Control.

  • Service Administrator

  • Power User

  • User

  • Viewer

  • Planner

  • System Administrator

  • Application Administrator

  • Library Administrator

  • Reports Administrator

If you have any classes or objects called using these keywords, Oracle recommends that you rename or delete them; otherwise they will be renamed by Oracle to ensure there is no effect due to this move. A group called Power User, for example, will be renamed Power User1 without changing the current role assignments. If you don't want Oracle to rename these classes automatically, you need to rename them.

 "ALL BUSINESS PROCESSES TO SUPPORT AN IDENTICAL SET OF PREDEFINED ROLES"

Oracle is planning to implement the following predefined functions for Narrative Reporting in a coming update. Many business processes in the EPM Cloud already avail these specific predefined roles, which as a result of this change will become the standard set of predefined roles. This update will allow Oracle to resolve client problems related to moving services to EPM Standard Cloud from current environments

  • "Service Administrator, Power User , User  , Viewer"

This change is automatic; current role assignments don't need to be updated. If you have any queries about this change, kindly contact Oracle Support by creating a Service request to get clarified on your concerns.

Current non-conforming Narrative Reporting predefined roles will be deleted; users assigned to those roles, the specific set of predefined roles will be automatically remapped as follows.

Remapping for Narrative Reporting Roles

Current Non-Conforming Roles  

Common Remapped Roles

System Administrator

Service Administrator

Application Administrator

Power User

Library Administrator

Power User

Reports Administrator

Power User

 

NOTE: Such change does not impact user function assignments. Users won't be assigned the Viewer role.

"QUERY GOVERNOR ON BSO AND ASO CUBES"

In a future update, Oracle will implement a database governor on Essbase BSO and ASO cubes to protect against excessive server load created involuntarily by running ad hoc queries which take a long time to complete. The new governor must restrict all requests to an execution time of no more than 30 minutes. This governor only affects data recovery, for example, ad hoc queries on Smart View

NOTE: This change of function affects just Planning, Financial Consolidation and Close, Tax Reporting, Profitability and Cost Control.

"UPDATE TO THE EXCEPTION RESPONSE IN REST APIS FOR PLANNING AND PLANNING MODULES"

Oracle will delete the internal package and class names from the following fields in a forthcoming release in early 2020, in the exception answer in REST APIs for Planning and Planning modules:

  • Message

  • localizedMessage

 "REMOVAL OF .XLS FORMAT AS REPORT EXPORT OPTION"

The following export options for the report are currently available: csv, xls, xlsx, pdf, and html.

In a forthcoming release the xls alternative for account reconciliation and tax reporting will be withdrawn. Customers who have generated custom reports should make sure that their reports are exported to one of the residual formats: csv, xlsx, pdf, or html.

 "FUTURE NEW CONNECTION TYPE AND ADVANCED OPTIONS FOR EXTERNAL CONNECTIONS FOR TAX REPORTING"

In the upcoming update, the Tax Reporting Service Administrators will be able to use the connections created for external web services, with optional query or header parameters defined. In the Groovy script, these links could be referenced or used to establish a communication link between the Groovy script and external Web resources. Users are advised when to fortify this incipient feature in Tax Reporting.

https://www.oracle.com/webfolder/technetwork/tutorials

January 2, 2020

Road-Map and New Upcoming Features In EPM Cloud - 2019 & 2020

For EPM cloud, any recent update will be rolled out to the production instance on the first' Friday of every month to check instance' and on the third' Friday of every month.' The update will be implemented during the regular activity period.

New monthly release should be rolled out by Oracle to the Test instance at the first regular activity on or after "23:00 UTC (15:00 PST)" on "Friday, January 3, 2020." During the first regular activity at or after 23:00 UTC (15:00 PST) on "Friday, January 17, 2020," New monthly release should be rolled out by Oracle to your Production instance. Access to new documents is supported by Oracle Help Center. The updates are available at the "Friday, January 3, 2020" Help Desk. Some of the connections in this orchestrating document to incipient feature documentation will not work until the Oracle Avail Center update is plenary.

"EPM Cloud Updates - January 2020"

"EPM Common"

1."ESSBASE FUNCTIONS SUPPORTED BY CALCULATION MANAGER":

Essbase functions supported by "Calculation Manager in block storage applications" are now included in Calculation Manager Guide and links to all functions is in the Essbase Technical Reference.

2."NEW DOCUMENTATION: ADDITIONAL TROUBLESHOOTING PROCEDURES FOR EPM CLOUD":

For troubleshooting common issues in EPM Cloud are available in "With new sections allowed, start with Oracle EPM Cloud for administrators."

"Financial Consolidation and Close" Service

N/A

"Profitable and Cost Management" Cloud Service

"PCMCS TROUBLESHOOTING CALCULATION ISSUES": To troubleshoot Calculation Issues a new chapter have been included in Administration Guide.

Details of "EPM Cloud Updates - December 2019"

For the "December update," the latest test instance changes will be applied on "Thursday, December 6, 2019 and on December 20, 2019 to the production instance."

EPM Common

1."New Access Control Feature to Assign a User to Many Groups"

With this, Service Administrators can allocate a user to multiple groups. Application roles and access control will be helped by group-based assignment.

2. "New Select All Option in the Financial Reporting Web Studio and Book Editor Select Members Dialog Box".

In the Cull Members dialog box "Financial Reporting Web Studio," we can pick all members currently assigned to a report or book rather than choosing one member at a time. If you have a multi-member report or book and plan to abstract all members to update the report or book rather than abstract one party at a time, this would prevent uncompulsory time consumption.

3."Financial Reports Renamed to Reports"

Financial Reports have been transmuted to reports.

"Financial Consolidation and Close"

1."Task Manager Audit Enhancements"

Audit records are included for the Holiday Rules established in the Task Manager to be engenderment, modified and expuncted.

2."Ability to Disable Ratio Calculations"

To manage consolidation performance, Ratio calculations of "FCCS_Days Sales in Receivables" and "If you don't use these calculations, "FCCS Days Sales in Stock" can be unchecked for selected scenarios. This can only be used during testing of the Asset Management function.

3."Dynamic Children Support is not Available for Business Rules Created Using Calculation Manager"

"Create Dynamic Members and Delete Dynamic Members" options are unavailable for FCCS applications, whilst utilizing Calc Manager to engender a business rule.

4."Accumulate Export Mode Available for "Financial Consolidation and Close" Users in Data Management and Data Integration":

Incipient accumulate export mode is now available in Data Management and Data Integration for FCCS users.

 "Profitable and Cost Management"

N/A

"EPM Cloud Updates - November 2019"

For the Nov update, on "Friday, Nov 1st, 2019 and on Nov 15th, 2019," Oracle will implement the latest changes to Test instance and Prod instances subsequently.

EPM General

1."New User Group Report":

This version has added the User Group Report. Report shows the direct / indirect participation in Access Control of users allocated to classes. They will be called direct members if they are mapped to the party. They will be kenned as indirect participants, if they are assigned to a group that is a child of another group.

For every user, below details will be captured.

"Login ID, First and Last name, Email ID, Name of the groups on where the user is directly or indirectly assigned".

The CSV report certifies whether the consumer is allocated directly or indirectly to a category through the use of Yes or No.

2."New EPM Automate Utility Version":

This update contains the incipient "userGroupReport" function, which produces a CSV file listing the groups allocated to users in Access Control. The report denotes either direct or indirect user assignment to party.

3."Planning Label in Migration Changed to Core":

From this version, Planning has been replaced with Core in the artifact categories listing that is shown when we perform Migration. Due to this, it reflects the type of artifacts included in this category and does not have any functional impact.

4."Group Export / Import Options Removed  - Access Control"

Export and Import buttons will not be shown in the Manage Groups screen as Oracle has excluded ability to export and import groups from Access Control. This is because, import and export groups can be done through Migration and EPM Automate. Migration for interactive export & import of groups and EPM Automate for automated import & export of groups should be used instead.

5."New Dashboard Icon for Shifting Navigation Flows at Executiontime":

To change navigation flows at runtime, a new Dashboard icon has been supported.

6."Provision to Data Integration Extended":

Any Cloud users provisioned with Power User and User predefined roles for the Planning business process will now access the Data Integration user interface, unlike earlier the users delegated to the Service Administrator predefined role had access to the Data Integration user interface.

7." EPM Cloud Groovy Rules Java API - revision"

Members can be excluded in Smart Push while using Groovy. We can run a calc script first and return to the Groovy script for the more execution. The name of the API is cube.executeCalcScript().

8." Engendering a Drill-Down without a Source System Landing Page Utilizing the EPM Integration Agent":

Through Data Integration in EPM Integration Agent, run an SQL query and display the results in a pop-window to drill down to an on-premises source system without a landing page.

9." Generate a User Group Report using New REST API":

REST APIs can be used to create a User Group Report about the users in the system and write the report to a provided file name. This will include the direct or indirect membership of users mapped to groups. It can be done using the Download REST API.

"Financial Consolidation and Close"

1."Opening Balance Ownership Change (OBOC)":

The OBOC Framework Act controls the income from the Opening Balance of Proportion and Elimination carried forward from the previous period's Closing Balance when the consolidation number varies from time to time. These adjustments show that total opening balances + related OBOC adjustments = closing balance reflecting the current percentage period of consolidation in the current period. Before this surrender, all OBOC changes were declared to the member of the Elimination Consolidation Dimension. "The OBOC adjustments are posted to the member of the movement "FCCS Mvmts Acquisitions" when the percentage of ownership increases over the period and to the member of the movement "FCCS Mvmts Disposals" when the percentage of ownership decreases over the period.

2."Decimal Precision in Intercompany Eliminations":

The total amount of removal of an intercompany transaction does not surpass the proportionalized sum. If an intercompany account's net contribution magnitude has been truncated to zero, there can be no more rejections. Computerized system probably couldn't /doesn't exactly record an amplification to zero. All computer systems have an issue called "decimal precision" because of this. The trial and error as to whether added intercompany eliminations should be processed must be predicated on the net contribution being "approximately equal" to zero rather than precisely equipollent to zero. FCCS applies "decimal precision of four decimals" while applying the trial and error by default. The net contribution of 0.0001 is measured "as zero and no additional eliminations" are applied to the data. This level of accuracy should provide ample accuracy in "most cases and for most currencies". However, if accidental eliminations do occur, to adjust the decimal precision added to the check, a Supersession Variable can be inserted into the specification.

3."Translation Calculations":

If POV source and destination are identically tantamount currency / language, the aggregation and conversion execution source data set is not bulwarked by any of the translation processes. Consolidation and Translation will apply translation processes to the source data when the POV source and destination represent different currencies.

4."Performance Substitution Variables":

To amend performance below Substitution Variables can be checked :

"EnableSimpleAggregation":  This Substitution Variable avail to ameliorates the performance while the child entities are accumulated into parent entities. To optimize the consolidation performance, this should be utilized in combination with the "OptimizeYTDCalculation".

"OptimizeDBRefresh": Use this vector over the DB refresh to modify the way when moving the exchange rates to the consol cube.

 

"OptimizeYTDCalculation":

This Supersession Variable can be utilized to eschews redundant and perpetual calculations. To enhance consolidation performance this should be utilized in combination with "EnableSimpleAggregation". To check the Supersession Variables, "set the parameter Cube = Consol", in integration to setting Value = true.

"Profitable and Cost Management"

N/A

"EPM Cloud Updates - October 19"

Test instance will get the recent updates on "Friday, Oct 6th, 2019" and Production on "Oct 20th, 2019."

EPM General

1."New EPM Integration Agent in Data Integration":

EPM Integration Agent has been included to create connectivity between the EPM Cloud and on-premises sources including SQL data sources like Oracle and Microsoft SQL Server, E-Business Suite GL, and PeopleSoft GL. Third-party REST API established systems / systems that can be accessed using a Jython or Groovy script to bind to practically any source of data. Responds when the data load rules for data management & system integration are implemented by a user and provides the details required.

2."Warning for Snapshot Imports":

From this release, a red flag info will be displayed in the import process in Migration on the below scenarios":

If the snapshot being imported is not from current release or from release one month prior or from next month release.

Snapshots can be upgraded from other month releases for business processes other than ARCS and EDMCS to make them compatible with the current version of the instance.

3. "Loading Data from the Oracle ERP Cloud - Adapter":

"Non-general ledger data from Oracle Financials ERP cloud sources" can be extracted and loaded to an EPM server using data integration and data management. The updated "Oracle cloud ERP adapter" allows one of the "cloud business processes" in the EPM to use cloud ERP data extracts as a "data source". "BI Publisher data extract" can be defined as being directly referred via data management from sources such as "payables, receivables, fixed assets, and supply chain".

"Financial Consolidation and Close"

1."Ability to Specify Name of a Report in the Input Arguments for Generate Report REST API Call":

Availing a supplemental input argument called generateReportFileName, an incipient designation can be designated by an Utiliizer, Whilst utilizing the engender report REST API call.

2."Supplemental Data Ad-Hoc Forms": They can develop Supplemental Data Forms, such as Administrators does if the correct security rights given for the Utilizer. Administrators can designate if Users can generate Ad-Hoc forms and abort those users who can generate Ad-Hoc forms when generating Ad-Hoc forms.

3."Creating Supplemental Data Form Attributes":

"Supplemental Data Forms" attributes can be created by an administrator in the "form templates" once0020 without creating "the attributes" in the data sets. In addition, attributes will be included in Data Sets.

4."Task Manager Audit Enhancements":

Two new columns are included in Task Manager Audit to show more information about tasks. Utilizing Task ID, and Source, you can switch to see the audit details.

5."Delegate Action in Approvals":

Consolidation Bottom-Up prototype works by testing Delegate activity in the Approvals option. This allows a user to own an acceptance approval unit regardless of whether they are on the promotional route or not. They can promote, dismiss, sign off, or dismiss units of approval.

6."Enhancement for Unlocking Entities in Approvals":

Any owner, "including the current owner", can be a "new owner in the previous promotional path". Unlocking the entity in Approvals will be able to do by them. When an entity is released, "the new owner will be the current owner of the entity if the Automatic option is chosen".

7."Configurable Equity Pickup Movement Members":

Default entries can be modified from the movement aspect "to single level 0 members" by an administrator over "FCCS Mvmts Subtotal". "The rule-set will now" extend to any modes of kineticism to which "data has been" applied by the device law.

8."Input Currency Journals":

Below options can be leveraged which utilize "Input Currencies, in addition to journals that" avail Entity Currency.

"Create, Approve

Post

Unpost

Reject journals"

Next, "create new Data Source members under FCCS TotalInputAndAdjusted and" map the "Source Data Type and Source Currency Type custom attribute values for" input currencies.  "When creating a journal or journal template, you will be able to select the new Data Source members" you created.

"Profitable and Cost Management"

1."Updated Exportqueryresults EPM Automate Command and REST API":

"New Version of EPM Automate"-

This package includes changes to the command exportQueryResults, which now agrees with the optional parameter roundingPrecision. This argument spotted the no. of decimal places to be used when exporting the results of the query (rounding precision).

"Export Query Results REST API "

A recent available roundingPrecision attribute has indeed been modified to the Export Query Results REST API for retrieving information, that enables to configure the decimal places to be used when exporting results.

"EPM Cloud Updates - September 19"

For the Sep update, it uses the latest changes to trial and error instance on "Friday, Sep 6th, 2019 and to production instance on Sep 20th, 2019."

EPM General

1."New Version of EPM Automate":

This contains these commands importAppSecurity, roleAssignmentReport, setDailyMaintenanceStartTime, setManualDataAccess, and setEncryptionKey.

"importAppSecurity": Loads utilizer or community access sanctions from a CSV script. Importing sanctions overwrites current assignments only for imported representatives, data types, directories for data type, task lists, business rules and folders for Calculation Manager.

"roleAssignmentReport":  Engenders and stores a "Role Assignment Report (CSV)" in the default location of the file from which you can access your contract. The report lists the responsibilities and task functions assigned to the users. This report is consistent with the Access Control Function Assignment Report version of the CSV.

"setDailyMaintenanceStartTime": Sets the UTC period when the instance's routine maintenance starts.

"setManualDataAccess": Specifies that Oracle is authorized to manually access an instance database in emergency cases where an instance is non-responsive and the client has not yet submitted a request for service to evaluate and provide the instance.

"setEncryptionKey": Sets a custom database authentication encryption key. Utilizing this command sanctions customers with such a "Bring Your Own Key (BYOK)" approach to include "EPM Cloud" in their standard rotation of key management.

2."New Feedback Activity Report": "When a user submits feedback using the Provide Feedback Tool, Oracle EPM Cloud produces a new operation log". It is separated by prefixing input to the name of the report. The report shows user-submitted information, such as screenshots and problem description, as well as the information available in the Incident Report.

3."Activity Report as a JSON File and New Activity Report Sections":

In order to facilitate the activity report, "Oracle EPM Cloud" additionally engenders a "JSON version of the Activity Report". It is engendered during the circadian maintenance process together with the Activity Report. Listfiles "EPM Automate command" can be acclimated to find the JSON-formatted activity report and replicate it to a own desktop folder. In additament, adscititious metrics including "manual database access information, Essbase design metrics, application size details, Essbase BSO and ASO cube statistics, and quantifications" in each cube have been integrated to the Activity Report. "This amendment does not apply to Narrative Reporting, which does not engender the Event Report". "This will consist of: Manual Database Access Information, Configuration Size, Essbase Layout Metrics, Essbase BSO and ASO Cube Statistics, Dimensions in Each Cube"

4."Support for Different Identity Domains for Test and Production Instances"

By design, one concrete identity domain is utilized in the EPM Cloud test and development instances to enable utilizer management and task assignments for each instance. Now migrate "EPM cloud instances to relocate the instance of development, test instance, or both to different identity domains". This is a shift in how the transfer of the territory has been treated historically.

5."Smart View for Office new features (Mac and Browser)"

"There is a new version of Oracle Smart View for Office (Mac and Browser)". "It includes the ability to save an ad hoc grid as a template, support on saving using Submit and Calc to run business rules, and help in member selection for members of the Dynamic Time Series".

"Save an Ad Hoc Grid as a Form

Submit and Calc

Support for Dynamic Time Series Members in Member Selection"

6. "Current Oracle NetSuite Seeded Searches Data Management Available"

New "indexed saved searches for metadata and data" were released by "Oracle Netsuite". Customers who want to load "data or metadata from the Oracle NetSuite Cloud ERP Platform" will have sancture to more "predefined content" to strengthen their current integrations.

7. "New REST APIs to support the development of your own main solution and the output of roles"

Two new REST APIS are now listed; "Set Encryption Key and Role Assignment Report". The REST API Set Encryption Key helps incorporate a "Bring Your Own Key (BYOK) solution" to add EPM Cloud in the regular rotation of key management. "This can be used to set and remove a user-defined encryption key to an instance of Oracle EPM Cloud".

"Financial Consolidation and Close"

1."Task Manager Schedule Status Displayed on Tasks":

The task status is now shown under the schedule name in the Task Manager on the Task Properties page.

2."Increased Character Limit for Task Manager Messages":

By viewing Tasks from the Tasks card, up to 3000 characters can now be shown in the messages within a task.

3."New Data Exchange Card for Data Integrations":

Data Integration has been included in "Data Exchange" card under Applications. From the Data Integration page, data integration can be created, or can run an existing integration.

4."New REST APIs for Oracle "Financial Consolidation and Close":

REST APIs can be availed to sancture journal information and other journal behavior.

Following actions could be performed:

"Retrieve Journals, Retrieve Journal Details, Submit, Approve, Post, Unpost, and Reject Journals, Update Journal Periods (open or close periods)"

5."Support for Additional Functions in Configurable Calculations and On-Demand Rules":

In both "Configurable Calculations and On-Demand rules", additional Essbase functions are enabled.

Supports these additional functions now: "@MIN, @ANCEST, @ILANCESTORS, @INTERSECT, @ISIBLINGS, @MERGE, @CREATEBLOCK"

"Profitable and Cost Management"

N/A

"EPM Cloud Updates - August 2019"

For the August version, latest changes will be used to trial and error instance on "Friday, Aug 2nd, 2019 and to production instance on Aug 16th, 2019."

"Financial Consolidation and Close"

1."Ability to Create Rate Accounts for Translation Overrides":

Besides the seeded "framework rate accounts (Average and Ending), additional rate accounts" can be generated to be utilize as part of the rules for "configurable Translation Override".  You can build, edit, or delete user-defined rate accounts from "Manage Translation Override Rules."

2."Scenario Override Option for Opening Balance":

"Now it is possible to determine a different scenario from which to derive the data on the closing balance in the first quarter of each year". "The default deportment is to carry forward from the same scenario the closing balance as the aperture balance to which the data is being submitted".

3."Simplified Seeded Balance Sheet and Movements Option":

You can cull an incipient "Basic" Balance Sheet option whilst developing an application. This alternative includes simpler hierarchies for the min set of representatives of the Account and Kineticism Division and a min set of seeded forms. Withal included are the incipient Traditional and Net Asset Strategy hierarchies.

4."Event Monitoring Integrations for Oracle Fusion General Ledger":

"Task Manager now provides out-of-the-box Event Monitoring tasks for Oracle Fusion General Ledger.  It is possible to monitor these events"

 "Accounting Period Closed, Accounting Period Opened, Accounting Period Re-opened, Journal Batch Approved, Journal Batch Posting Completed"

 5."Task Manager Limits on Object Instances":

Maximum limitations on the "number of templates, schedules, attributes, tasks per template, and tasks per schedule" have been implemented to boost Task Manager application performance. When such objects are created, the device enforces maximum limits. Furthermore, during the Migration import process, the program also enforces the max no., of such objects.

"Profitable and Cost Management"

1."New Models Cluster in Profitability and Cost Management":

A new Profitability and Cost Management Models cluster provides an improved user interface to create, manage and measure model rules. Designer, execution control, and Job Library screens are included in the Models cluster.

 "EPM Cloud Updates - July 2019"

For the July version, latest changes will apply to trial and error environment on "Friday, Jul 5th, 2019 and to production environment on Jul 19th, 2019."

"Financial Consolidation and Close"

1."New Version of EPM Automate":

A "New Version of EPM Automate"is available with this update. These new commands are now available": addUsersToTeam, and removeUsersFromTeam.

addUsersToTeam Command": This command adds users listed in a CSV file to an existing team. If a user included in the CSV file is already a member of the team, this command ignores that user.

removeUsersFromTeam Command": "This command abstracts users listed in a CSV file from a team. If a utilizer included in the CSV file is not a member of the team, this command ignores that utilizer".

2."Ability to Export Metadata Validation Results":

"When you validate metadata, you can now export all error messages to a CSV file. The members are displayed in [Parent].[Child] format".

3."Using Calculation Manager in Standard Mode":

Such changes affect the following options for calculation:

"If you are using Standard mode, you cannot launch Calculation Manager from the Advanced Consolidation card". "If you are using Enterprise mode, Calculation Manager will launch from Advanced Consolidation".

4."Configuring the Reference Set of Consolidation Rules":

You can now pick a different member of the Scenario, Year, Period, Organization, Consolidation and Currency for Configurable Consolidations when constructing a rule set and choosing the Reference Dataset for the specifics of the Elimination. "The destination to which the data stored is written will not change and will remain as the case, year, period and person currently being processed"

5." View and filter jobs":

"You can utilize the POV bar to search the list and select a specific job while browsing the Task Manager Jobs page". You may filter by name of the work, rank, generated by (or changed by), date of start and date of end.

6." To create reports, use the REST API":

You can either generate a single predefined "Financial Consolidation and Close" or "Tax Reporting report" using the REST API, or you can create a "custom report"

7." Reports created by email using the REST API":

You can now use REST API to create email notifications from the Task Manager and Supplemental Information Manager.

8."Comma Separate Cost Support (CSV) Reporting System"

In Comma Separated Value (CSV) format, you can now produce a chart. This is available for custom or predefined papers.

9." Tracing users in the workflow of the task manager":

In Task Manager workflows, a new attribute is available for each workflow stage showing the actual user for the completed workflow, for example Assignee (Actual). In the workflow, the Actual column will show who did work on the task, regardless of the user status.

10." Use of the REST API to add or remove users":

If interacting with teams using the REST API, you can now add or remove a group of users.

"Profitable and Cost Management"

1."Better Support for Rule Development and Testing"

The Cloud Documentation Framework Report on Profitability and Cost Control has been improved to better support the development and testing of rules. Previously, "the columns of the Estimated Source Count and Estimated Destination Count of this report showed an estimated number of members included in the accumulation of members for each dimension in the rule by resolving each member included down to their caliber 0 children but without applying the designated member filters". The report uses the required filters to give each member an appropriate number of members for every dimension.

"EPM Cloud Updates - June 19"

For the June version, latest changes will avail to trial and error environment on "Friday, Jun 7th, 2019 and to production environment on Jun 21st, 2019."

"Financial Consolidation and Close"

1."Equity Pickup":

"Equity Pickup" is an other way of quantifying the valuation of assets in companies, calculating the latest value predicated on the portion of net earnings owned by the lender. During application development, or from the "Enable Features" tab, you can check Equity Pickup. Four supplemental seeded aggregation rules and incipient members for "Equity Pickup have been applied to the Account (FCCS EPUSource) and Data Source (FCCS EPU)"

2."Updates to Seeded Configurable Consolidation Rules":

Several vicissitudes were made for the seeded consolidation rules.

The Owner's Equity (Holding) rule-set has transmuted the Owner's Equity source account from the Owner's Equity to the Total Equity account. This move is to promote the coming development that would sanction a minimally seeded account application to be developed. "Consolidated data should not be adjusted as the only accounts included in the set that were not antecedently included are Minority (Non-controlling) Interest and CTA, none of which should be filled at the caliber 0 holding company"

Both Total Equity assets are now added in either the "Owner's Equity Adjustments (pre-acquisition) or Net Income Adjustments (post-acquisition) Regulations" for the abbreviation of equity, to ascertain that all equity transactions are either treated as an equity modification or an adjustment to profit. If the default set-up does not suit the client requisites, the rule sets can be replicated and updated.

The execution requisite has been adjusted for Holding (as afore), plus Subsidiary and Proportional system entities in the two investment rule sets. The move inspirits the utilization of "square" organization structures where the first (and only) parent will omit all investment in subsidiaries.

The subsisting condition of the Intercompany dimension class (# Any ICP being a progeny of the current parent #) must ascertain that the modification operates only on a concrete parent. The POV for the "Data Source dimension has been transmuted from Total Input to Total Data Source for all rule sets". This move is intended to satiate recursive calculations such as minority interest (non-controlling).

3."Support for @Currmbrrange Function in Configurable Calculations":

When you make configurable calculations, now you could utilize this "Essbase Financial feature in Calculation Manager" :  @CURRMBRRANGE.  "This method produces a list of members based on the estimation of the relative position of the latest member".  "It can be used with other features like "@SUMRANGE and @AVGRANGE" as well".

"Profitable and Cost Management"

N/A

"EPM Cloud Updates - May '19

For the May version, Recent changes will be added to the test environment on "Friday, May 3rd, 2019 and to production environment on May 17th, 2019."

"Financial Consolidation and Close" Cloud

1."Approvals Process":

Oracle's "Financial Consolidation and Close" platform also offers a mechanism and workflow for approval. Administrators may control the approval process by establishing an approval unit hierarchy or by changing the standard approval unit hierarchy, setting the promotional course, and status review. Users can use the "promotional path set up for the approval unit hierarchy to start, promote, reject, authorize, and send data."

2."On-Demand Rules":

"On-demand rules sanction you to integrate your own ad hoc rules that can be utilized outside the consolidation process for calculations". The results of quantification can be checked or modified afore consolidation is invoked. Administrators build "-demand rules, and users with launch sanctions" can launch them from data sources, Keenly intellective "View, journals, Supplemental Data, or from the Rules sheet".

3."Metadata Validation Enhancements":

Incipient validations have been applied to the Metadata Validation process.  For instance, now the system  validates to ascertain that primary members subsist afore shared members, "whether a parent member of Custom or Multi-GAAP is shared, or whether members of Level 0 have the Dynamic Calc property"

It is highly suggested that you follow the guidelines for validation errors to minimize the risks associated with "data integrity issues" and take advantage of considerations of good professional practice outcomes.

4."Enhanced Auditing for Task Manager":

Administrators can now show from the Audit Card the history of all changes to the Task Manager. For example, the Audit log also contains all changes to schedules and descriptions of missing assignments, models and other artifacts or settings of the Task Manager.

5."Task Manager Reassignment Requests":

Administrators can pick the system users who can accept requests for task reassignment in the Task Manager System Settings. Including administrators and power users, if the administrator has given them permissions, users can now accept reassignment requests from their Worklist.

6."Task Manager Reminders for Due Dates": Once administrators set up Task Manager email notifications, they can additionally fix the number of days to raise reminders before the deadline.

7."Task Manager Integration Enhancements":

Additional Role Forms for Project Manager Integrations have been introduced.

"Oracle Financial Consolidation and Close" Cloud":

"Approvals, Manage Ownership"

"Oracle Tax Reporting Cloud":

"Approvals"

"Oracle Planning and Budgeting Cloud":

"Approvals, Manage Dimensions"

8."Importing and Exporting Teams and Users in Supplemental Data Manager":

"Instead of updating teams and members individually, administrators and power users can be done bulk update of teams and members". "You can additionally export a list of utilizers from the Manage User page to a CSV script to pull user information".

9."Support for Additional Essbase Functions in Configurable Calculations":

Now, when you build configurable calculations, you can take these extra Essbase Financial functions in "Calculation Manager" : "@ATTRIBUTE, @COMPOUND, @INTEREST, @IRR, @NPV, @SHIFT, @SHIFTMINUS, and @SHIFTPLUS".

10."Audit Entry for Copy Data and Clear Data":

"The related audit entries are now accessible when operating "Copy Data or Clear Data" in the task 

  group Audit Task List Information".

 "Profitable and Cost Management" Cloud

1."New Rest API Resource to Merge Slices of Data":

"A REST API resource, Merge Slices for Oracle PCMCS, combines every incremental slices of data into the main slice of the database & deletes zero-value cells as an option to compact the Essbase cube".

"EPM Cloud Updates - March 19

The latest changes will be included to the trial and error environment for the March update on "Friday, March 1st, 2019 and to production environment on March 15th, 2019."

"Financial Consolidation and Close" Cloud

N/A

"Profitable and Cost Management" Cloud

N/A

 EPM Cloud Updates - Feb 2019"

The latest changes will be included to the trial and error environment for the February update on "Friday, February 1st, 2019 and to production environment on February 15th, 2019."

"Financial Consolidation and Close" Cloud

1."Process Management":

FCCS also offers a workflow and approval process. Administrators may control the approval process by establishing an approval unit hierarchy or by changing the standard approval unit hierarchy, setting the promotional course, and status review.  "Users can use the promotional path set up for the approval unit hierarchy to start, promote, reject, authorize, and send data".

2."Support for Additional Elimination Members in the Data Source Dimension":

A new parent member of "FCCS Total Eliminations" has been included to the Data Source dim & the current member of "FCCS Intercompany Eliminations" is a new Total member's brother. To build more accurate monitoring of consolidation change and exclusion entries, you can add siblings from the original "FCCS Intercompany Eliminations" member (descendants of the introduced Total member)

3."Close Manager Renamed to EPM Task Manager":

In every places in the User Interface, the term "Close Manager" has been renamed "Task Manager."  It covers assignments, job styles, models, schedules, staff, device settings, characteristics, alerts, and reports.

4."Embedded Template Information in Task Manager Templates":

"In order to identify embedded templates, such new columns have been added to the Manage Templatescreen within the Task Manager". "However, if you build a task template, a new option is available in 

the Properties tab to set a template as "Embedded Only."

5."FCCS Translations - Override Entries To Intercompany Accounts Should Also Be Applied To Elims":

If applying an Override number or cost to an already removed Intercompany entry, "the Override will 

also be applied to the removal entry".

 "Profitable and Cost Management" Cloud

1." Easy to use "Web System Section for Profitability and Cost Control":

Current PCMCS Framework tab symbols indicate if the framework is ready to use.

2."Report execution statistics Available from the Work Library in Microsoft Excel Format:

"The PCMCS Execution Statistics Report now supports performance while running in Microsoft Excel file 

format from the Job Library".

 

January 1, 2020

Automation of customized PBCS Data Load

Introduction

 

I am working on the Oracle EPM PBCS implementation project which is focused on integrating Fusion application. The data load process is automated using EPM utility. Users wants to load the data for the specific version in PBCS application. The version value will be set through the substitutional variable. For example, if the version value is set to "Final", then the data should be loaded to Final version in PBCS target application. User will update the version value based on the data load requirements.

 

PBCS Data Load Process

 

The sources files are generated from Fusion cloud system and loaded into PBCS application through data management.

The data load process is automated using EPM utility and PowerShell scripting.

The Account, Entity, Version dimension mappings are updated in the data load mapping of data management.


Picture1.png


Business requirements

Business users are loading the forecast data into PBCS application on weekly basis.

PBCS application has Week1, Week2, Week3, Week4 and Final versions and users are loading the data into these version based on the forecast week.

       To load the data into specific version, the data load mapping should be updated based on the weekly load. If the user wants to load the data for the Week1 version, then the target mapping for version dimension should be updated to Week1 in data load mapping.

But users can't update the data load mapping every time manually. It should be updated automatically based on the weekly load.

 

 

Solution

 

To automate the data load process based on the version, we need to automate the data load mapping update process.

This can be achieved using Version substitutional variables. The data load mapping file is generated based on the substitutional variable value and imported it into Version dimension data load mapping in data management.

PowerShell script is used to get the substitutional variable value and generating data load mapping file.


Data load mapping file template

 

The data load mapping file should be generated automatically based on the version substitutional variable value.

The mapping file should have the below details

 >> Source Value, Target Value, Rule Name, Description, Apply to Rule


Picture2.png


PowerShell Script to generate mapping file:

- The EPM command "getsubstvar" is used to get the substitutional variable value  from the PBCS application.

- The substitutional variable value may be set to "Final" or "Week x". Using pattern matching, we can identify which variable is set.

 

  $ealoc = "E:\Oracle\EPMAutomate\bin"

  $ret = & $ealoc\epmautomate getsubstvar ALL name=ForecastVersion

  $ver = ([regex]::matches($ret, "Final") | %{$_.value})

 

 

- The below PowerShell script generate the data load mapping file based on the

   substitutional variable value.

- The substitutional variable value may be set to "Final" or "Week x". Using pattern

   matching, we can identify which variable is set.

 

 

if ($ver -eq 'Final')

{  $FVersion = $ret[1].Split("=")[1].substring(0,5)  }

Else

{   $FVersion = $ret[1].Split("=")[1].substring(1,6)   }

$FVersion  = "*," + $FVersion + "," + $FVersion + "," + $FVersion + ","

$FVersion > 'FVersion.txt' (Get-Content E:\FVersion.txt) | Set-Content -Encoding Default  E:\FVersion.txt

 

PowerShell Script to import mapping file

The below command import the data load mapping into x location in Data management.

  $ret = & $ealoc\epmautomate importMapping VERSION             inbox/Location/FVersion.txt REPLACE TRUE Location


Picture3.png



Data Load into PBCS

Once the data load mapping is imported into data management , the PowerShell command executes the data load rule in sequence.

  $ealoc\epmautomate rundatarule "Location" $Period $Period REPLACE   STORE_DATA "SourceFile"

The data will be loaded into target application to the specific version based on the substitutional variable value. If the value is set to "Final", then the data will be loaded into Final version.




Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter