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

HSDL HDL lines

Received Response
80
Views
1
Comments
edited Feb 4, 2019 4:42PM in HCM Integrations 1 comment

Summary

looking to query HDL lines from a successfully loaded HSDL template.

Content

I was trying to report out on the HDL lines (successfully) loaded from an HSDL execution. Is this possible to do? From what I have seen so far, it does not seem like successful lines are stored.

SELECT HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_ID AS DATA_SET_ID,
       HRC_DL_DATA_SETS.DATA_SET_NAME AS DATA_SET_NAME,
       HRC_DL_DATA_SET_BUS_OBJS.DATA_FILE_NAME AS DATA_FILE_NAME,
       HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_BUS_OBJ_ID AS DATA_SET_BUS_OBJ_ID,
       HRC_DL_FILE_LINES.*
FROM HRC_DL_DATA_SET_BUS_OBJS HRC_DL_DATA_SET_BUS_OBJS,
     HRC_DL_DATA_SETS HRC_DL_DATA_SETS,
     HRC_DL_FILE_LINES HRC_DL_FILE_LINES
WHERE HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_ID =HRC_DL_DATA_SETS.DATA_SET_ID
  AND HRC_DL_DATA_SET_BUS_OBJS.REQUEST_ID=HRC_DL_DATA_SETS.REQUEST_ID
  AND HRC_DL_DATA_SETS.UCM_CONTENT_ID = :p_content_id
  AND HRC_DL_FILE_LINES.DATA_SET_BUS_OBJ_ID(+) = HRC_DL_DATA_SET_BUS_OBJS.DATA_SET_BUS_OBJ_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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