In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]
Posts Tagged ‘Oracle’
February Updates for Oracle EPM
Can you believe it?… January is behind us and February is here! And with February comes Valentine’s Day… (just a friendly reminder for those of us who tend to mistakenly overlook this holiday 🙂 ). But lucky for customers, Oracle is not getting distracted by Cupid and is instead providing a laundry list of enhancements […]
2023 Initiatives for the CFO & CIO
2023 is going to be a challenging year for CFOs. Rising inflation (and interest rates), labor shortages and workplace transformations, continued supply chain complications, and increasingly complex and controversial external reporting requirements are all just a few of the major obstacles facing organizations in the new year. With so many issues at the doorstep and […]
SQL Best Practices and Performance Tuning
The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]
Year in Review: Must Read EPM Posts
2023 is almost here! New goals, new projects, and technological advancements are right around the corner. But before we look forward, we should reflect on the past year. There has been some great insight posted by my Perficient colleagues that can be great resources for managers, analysts, and administrators within the Enterprise Management Performance space. […]
Oracle’s New Features for EDM (December 2022 Release)
Oracle has released over 25 new features this month for EDM (Enterprise Data Management). At the top of the list is a pre-built application type for Enterprise Profitability and Cost Management. The details for this new application type can be found here. But there are a number of other updates which warrant discussion as well. […]
Oracle EDM Expands to Enterprise Profitability and Cost Management
A big benefit of Oracle EDM (Enterprise Data Management) is all of the pre-built application types contained within the solution. These application types greatly decrease the development time required by customers during EDM projects. Properties, validations, and exports are provided out-of-the-box with these application types. And starting with this month’s release, EDM now has a […]
3 Reasons to Join the Perficient CPM Team
Whatever the technology, everything revolves around three main components: Process, People, and Tools. And while “Tools” receive the majority of focus in any discussion in the technology arena, it’s the People that are the crucial component of successful organizations. We understand this here at Perficient and is a major reason why we continue to be […]
Oracle EDM and FreeForm Planning
Oracle’s September new features list for EDM (Enterprise Data Management) contains quite a few exciting items. One particular new feature that Oracle EPM customers should be aware of is EDM’s ability to support FreeForm Planning applications. Starting this month, EDM now contains an new application type specifically for FreeForm Planning applications! The application registration […]
Key Features Recently Made Available in Oracle Enterprise Data Management
The most recent release of new features for Oracle Enterprise Data Management contain some great capabilities. Continue reading below to find out more! Viewpoint Querying The ability to search for nodes within Oracle EDM has been greatly enhanced with the recent addition of Viewpoint Queries. Now, users can easily find nodes within a viewpoint […]
Navigating from EBS Journal Lines to Originating Transactions – Part II
In our last post we discussed the linkages between Journal Entries and the source transactions in Accounts Payable, Accounts Receivable, and Fixed Assets. This post continues the discussion with the linkages for the Purchasing, Project Accounting, and Cost Management applications. As noted in the prior posting, since most organizations employ summary posting of Journal entries, […]
Important April Updates for Oracle EPM Cloud Customers
BETTER DATA MOVEMENT ACROSS APPLICATIONS Smart Push is a Forms feature available in Planning, Financial Consolidation and Close, and Tax Reporting which permits the movement of data from one cube to another. This movement, or push, occurs instantaneously during execution (click here for options on configuring when the push occurs). Smart Push uses Data Maps […]