Oracle Fusion Analytics is an analytics application that helps you answer key business questions and make better-informed decisions. Cultivating data literacy in your organization and maintaining accurate data in your underlying transaction system are two of the most important elements in becoming data-driven. Fusion HCM Analytics not only helps transform data into an easily consumable format, but it also identifies erroneous data, which helps you clean data in the source transaction system via reject records generated every time the data pipeline runs. This article provides guidance on how you can use this metadata to investigate data anomalies and collaborate with Oracle Fusion Cloud HCM support for data cleanup at the source.
This blog describes how you can
Proceed as follows:
ERROR_CODE |
ERROR_MESSAGE |
Corresponding SQL |
Impacted Subject Area |
GOAL_PLAN_GOAL_ISSUE_A |
The combination of Goal, Goal Plan, Goal Plan Set, and Review Period is not unique |
SELECT goal_id, |
HCM- Goals and Career Development |
ACCRUAL_ENTRY_DETAIL_ISSUE_A |
Accrual Entry is associated with more than one assignment |
SELECT DISTINCT per_accrual_entry_id, |
HCM- Workforce Absence Management |
PROFILE_ITEMS_ISSUE_A |
The combination of Profile, Content-Type, and Content Item records has overlapping date ranges |
SELECT a.profile_id, |
HCM – Talent profile HCM – Workforce Core HCM- Talent Review |
PROFILE_ITEMS_ISSUE_B |
There is more than one row for the combination of Profile, Content-Type, and Talent Review Meeting |
||
WRKFRC_ASG_SUP_ISSUE_A |
A single Manager Assignment Identifier is associated with multiple Manager Person Identifiers |
SELECT DISTINCT manager_assignment_id, |
All Subject areas |
TA_SRC_TRCK_ISSUE_A |
Multiple Source Tracking Details exist for a single job application/submission |
SELECT source_tracking_id, ORDER BY submission_id; |
HCM – Talent Acquisition |
RATING_CATEGORY_ISSUE_A |
Rating categories have overlapping upper or lower boundaries |
SELECT a.category_id, /*Insert the Rejected Record Primary Key Value within the parenthesis */ |
HCM- Performance Management HCM – Talent Profile HCM – Talent Review HCM – Workforce Core |
MNGR_HRCHY_CFDNDH_ISSUE_A** |
For a manager type, multiple records are present on the same day for the same manager and reporter. For this case, bad data is not removed from Fusion Analytics |
SELECT manager_assignment_id, This issue is a result of HCM prerequisites not being executed, Check the section below this table for detailed pre emptive steps**. |
All Subject areas |
WRKFRC_ASG_TERMINATION_ISSUE |
Multiple termination records exist for an Assignment on the same day |
SELECT assignment_id, |
HCM – Workforce Core |
GOAL_ALIGNMENT_ISSUE_A |
The combination of Goal and Aligned Goal is not unique |
SELECT goal_id, |
HCM- Goals and Career Development |
OVERLAP_RULE_A |
The Start Date comes after the End Date |
SELECT DISTINCT person_id, |
All Subject area
|
OVERLAP_RULE_D |
The start date of the current record is the same or less than one of the end dates of the previous records OR the end date of the current record is the same or greater than one of the start dates of the next records |
**Fusion HCM Analytics Prerequisite Steps for Manager Hierarchy
To execute the queries provided above:
Check the results.
To help ensure data integrity, Fusion HCM Analytics blocks anomalous data from being loaded and logs it as rejected. This blog describes the 12 most common data mismatch scenarios you might encounter. Using this information can help you understand and analyze the nature of the data rejects and collaborate with the Fusion Cloud HCM teams on the best approach for reconciling the data.
For more details on reject records, please see Tables with Rejection Details. And to be sure you're set up for success with your Fusion HCM implementation, see Prerequisites for Implementing Fusion HCM Analytics.
I have worked in data management and reporting tech stack for 22 years and more. Currently, I am part of the CEAL team for Service Excellence.
Past roles :
Oracle Analytics - Had been a part Oracle North America Sales engineering team and managed several Oracle Analytics projects for Deloitte, Capgemini, and Oracle consulting services.
Other Roles- Oracle DBA (8.x. to 10g) , HP Neoview product engineering team, architected solutions/managed deliveries in Azure, and AWS tech stack.
Previous Post