Is there an ideal approach or query for retrieving HDL error lines?

aIgnacio

Hello,

We have a business requirement right now to create a BIP report that will display all the lines/rows that had an error in an HDL flow. So let's say we have an HDL load and in the import and load section we can see that the specific flow has a count of 11 objects that failed. The idea is that if we run the BIP report and filter out that specific flow then display all those lines that had an error along with its error message in the report.

I've attached the current SQL for the data model that we are using however one thing we noticed is that there are gaps with our current logic in a sense that there are some errors that are not being picked up. We wanted to try asking here if there is a better or efficient way of getting these information? Thank you!

Mass Loader Error Report.sql

Sinduja Sekar-Oracle

Hi @User_YU6ZW ,

Thanks for posting in Oracle Communities. This forum is for FDI product. Please post your question in Fusion HCM page below:
https://community.oracle.com/customerconnect/categories/hcm-human-resources