Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
20D upgrade - issues being faced with HDL tables
Summary
Some of the conditions that used to work in HDL data loader tables are not working in 20D.Content
Earlier for successful load of element entry ,HDL records DATA_SET_BUS_OBJ_ID of HRC_DL_FILE_HEADERS and hrc_dl_data_set_bus_objs table would be same. But now it is different in 20D instance. Because of which our error reports would need change . We see issue with performance when decode/NVL and other functions are used in select clauses too.
Version
20DCode Snippet
select fr.* from From hrc_dl_stg_file_rows fr , HRC_DL_FILE_LINES fl , HRC_DL_FILE_HEADERS fh , fusion.hrc_dl_stg_physical_lines pl , fusion.hrc_dl_data_set_bus_objs bo , fusion.hrc_dl_business_objects hbo , HRC_DL_DATA_SETS HDDS WHERE fl.line_id = fr.line_id AND fr.header_id = fh.header_id AND hbo.business_object_id = bo.business_object_id AND fh.DATA_SET_BUS_OBJ_ID = bo.DATA_SET_BUS_OBJ_ID AND bo.data_set_id = HDDS.data_set_id AND fr.row_id = pl.row_id AND fl.line_id = fr.line_id AND (HDDS.DATA_SET_NAME = :Dataset_Name||'.zip' OR HDDS.UCM_CONTENT_ID =:P_CONTENT_ID) AND PL.IMPORTED_STATUS = 'SUCCESS' AND PL.VALIDATED_LOADED_STATUS = 'LOADED_SUCCESS'
0