You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    HDL Load Errors Report

    edited Mar 20, 2019 9:20AM in HCM Integrations 6 comments

    Summary

    HDL Load Errors Report

    Content

    Oracle provided me SQL to show errors from a HDL data load which has been working fine for months, but now all of a sudden its stopped bringing any results - maybe the tables have changed following an upgrade ! Any ideas on how I can amend the below sql so when I add it to my data model it works and brings results ?

    SELECT msg_text, text
    FROM fusion.HRC_DL_MESSAGE_LINES MESSAGE_LINES
    JOIN fusion.HRC_DL_PHYSICAL_LINES PHYSICAL_LINES ON PHYSICAL_LINES.PHYSICAL_LINE_ID = MESSAGE_LINES.MESSAGE_SOURCE_LINE_ID

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!