MSAMM
Back to course

Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 8 · HDL for HCM data

Loading, monitoring and the error report

Lesson 82 of 177 · 2 min

Load, watch, and read the failure — and the failure names an OBJECT rather than a row, which is the difference from FBDI. The load is submitted as a process and produces a status and counts per business object: how many Worker records succeeded, how many Assignment records failed. Read the counts per object, not just the overall status, because a load where Workers succeeded and Assignments failed reports as a partial success and leaves the estate in the half-loaded state Lesson 3 warns about. The error report groups by object and message. A single underlying cause — one missing position — produces a rejection for every assignment referencing it, so a thousand errors are frequently one problem. Sort by message and count the distinct ones first; that number is how many problems you actually have. The message names the object and the attribute, and rarely the reason — the

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Oracle Fusion Technical: Reports, Data, Integrations and Extensions, with a certificate on completion and a fourteen-day refund window.

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 8 · HDL for HCM data

  1. 1Why HCM has its own loader
  2. 2The .dat file format
  3. 3Business objects and their dependencies
  4. 4Effective dates: the part that catches everyone
  5. 5Source keys and matching existing records
  6. 6Loading, monitoring and the error report
  7. 7Corrections and the delete you cannot do
  8. 8HDL versus HSDL, and when to use each
  9. 9What breaks: four HCM load failures
  10. 10Lab briefing · Load a workforce, then correct it