In this blog, we will see what the basic test scenarios for ETL testing are. However, before we go to the ETL test scenarios, let me first tell you what ETL is and how it works, along with the process involved with it. WHAT IS ETL? ETL stands for Extract-Transform-Load, and it is a process […]
Oracle
How to Convert Blank Values to Null in Flat File Source in SSIS Package
SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]
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, […]
HFM to FCC – Financial Reporting in FCC, Part 3
Finance leaders from Cardtronics and Allegis Group with more than three years of combined experience using Oracle Financial Consolidation and Close joined Perficient and Oracle for a panel discussion regarding their cloud journey. Richard Ng, Director, Financial Systems, Cardtronics, and John Oliphant, Financial Developer Lead Allegis Group, shared the stories of their organizations’ migration from […]
HFM vs FCC Consolidation Times, Part 2
Finance leaders from Cardtronics and Allegis Group with more than three years of combined experience using Oracle Financial Consolidation and Close joined Perficient and Oracle for a panel discussion regarding their cloud journey. Richard Ng, Director, Financial Systems, Cardtronics, and John Oliphant, Financial Developer Lead Allegis Group, shared the stories of their organizations’ migration from […]
HFM to FCC – Oracle Cloud Benefits From the Customer’s Point of View, Part 1
Finance leaders from Cardtronics and Allegis Group with more than three years of combined experience using Oracle Financial Consolidation and Close joined Perficient and Oracle for a panel discussion regarding their cloud journey. Richard Ng, Director, Financial Systems, Cardtronics, and John Oliphant, Financial Developer Lead Allegis Group, shared the stories of their organizations’ migration from […]
Why Implement Incorta Analytics for Oracle Fusion Cloud ERP Reporting?
Oracle Cloud ERP offers several built-in tools for reporting. While native reporting tools like Oracle Transactional Business Intelligence (OTBI) and Oracle BI Publisher are well-suited for specific types of operational reporting, they do have limitations when it comes to performing complex and enterprise-wide reporting. It is therefore crucial to complement the Oracle Cloud ERP application […]
Oracle Cloud (Fusion) Tax Automation
In the nearly four years since the South Dakota vs. Wayfair decision, economic nexus laws have swept through the United States. Every state with a sales tax has passed an economic nexus law. With these changes, companies selling products or services in multiple states are much more likely to be required to charge and remit […]
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 […]
Enhance Oracle EPM Reporting with Incorta Financial Dashboards
Are you looking to supplement your Oracle EPM applications with enhanced analytics capabilities? If you find yourself trying to achieve one of the following, this blog post introduces you to a Perficient solution that leverages the Incorta Direct Data Mapping technology. Mash up EPM data with data from other systems like ERP, Sales, etc… Drill […]
Data Conversions to Oracle Cloud Supply Chain Management is as easy as 1 – 2 – 3
Implementing enterprise-level software has its challenges. Traditionally, a few of the most demanding and challenging milestones of an implementation project have been the conversions and integrations. Oracle has been quite generous about open “import” interfaces in E-Business Suite (EBS). The new generation of Oracle’s enterprise software solution, Oracle Fusion, especially Oracle Cloud Supply Chain Management […]
[Webinar Recording] Projecting Supply Chain Performance with Incorta Analytics
Proactively monitoring and addressing upcoming supply chain bottlenecks can have a direct impact on realizing revenue targets and meeting customer expectations. Leveraging Incorta Analytics, Perficient’s supply chain management solution for Oracle E-Business Suite provides a forward-looking view of inventory projections with increased visibility into SCM, order management, purchasing, and manufacturing. Watch the on-demand recording for […]