Oracle

what is ETL? ETL is a process that extracts the data from different source systems, then transforms the data (like applying calculations, concatenations, etc.), and finally loads the data into the Data Warehouse system. The full form of ETL is Extract, Transform, and Load. What is a data warehouse (DW)? A Data Warehouse (DW) is […]

With all the pressure triggered by lacking the right technology, leaders do not have much time to spend on strategic initiatives, for which it is hard to believe that an organization’s work environment significantly impacts employee engagement and productivity. Fortunately, many management teams in these companies have not given up hope. To make their employees […]

Each month Oracle provides “What’s New” publications describing new features across the EPM Cloud stack. Within this publication, Oracle also provides notices about important changes either applied to that month’s release or planned for the future (the intent being to give customers ample time to plan for & address the change). We highly recommend service […]

Oracle’s March 2023 update for EDM (Enterprise Data Management) contains many great new features, but there are a few which are truly exciting for the EDM community! Request Activity Page Provides New Information Customers can now use the Request Activity page to easily view workflow information for all In-Flight requests. Invitees, Approvers, and Committers columns […]

We were presented with this client to build few complicated and lengthy reports. During writing of these reports, we noticed few scenarios that could be challenging to everyone out there who are writing reports in Smart View. Here is a scenario that we encountered to overcome challenges of writing a good report in smart view […]

Are you a part of the Human Resources team, which is tasked with reporting on Equal Employment Opportunity? Are you an Oracle Human Capital Management consultant tasked with configuring the environment setup of this report? The goal of this blog is twofold: demystify EEO reporting by defining the various reports, and outline EEO-1 reporting setups […]

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 […]

It is common practice to update metadata (renames/corrections) in the business world to address changing business needs. Here we will discuss how the Model Validation page in Oracle EPCM can be used to identify the allocation rules referencing the dimension member and update the corrections. Allocation Process and Rules Cost Centers As an example, a […]

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 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 […]

During my 8 years of implementing Oracle Cloud HCM, I have found that many of my clients have shared a similar problem as they approached Go-Live. Months of work go into designing and tweaking so by the time the project ends, my clients are often subject matter experts. The issue they all face is sharing […]

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. […]