![oracle apex sql query transformation rule oracle apex sql query transformation rule](https://ars.els-cdn.com/content/image/3-s2.0-B9781555583224500084-u06-59-9781555583224.jpg)
Via debug I can see that the PARSE_COL_HEAD, LOAD_COL_HEAD, LOAD_CONTENT, NOT_LOAD_CONTENT collections have all been populated. in our case we are not, we do those elsewhere, so Skip Validations does the trick.Īfter much testing, with different files, copy/paste and upload file, I get the "no data found" message on most every data set, whether I have a date column and enter a date format or not.
![oracle apex sql query transformation rule oracle apex sql query transformation rule](https://us.v-cdn.net/6032257/uploads/jive_attachments/4/5/5/45595654egami.png)
I realize the latter may not be OK is you are relying on the DL Wiz to for validations and transforms. Upload to a stage table w/o the unique keys, than use a custom process to move data to the real tables, or, In the meantime, if someone encounters this issue, try one of these workarounds: I am able to work around this issue by setting Skip Validations in the Data Load Definition to Yes.Ĭarsten identified that this is likely a bug, that will possibly be addressed in a future version.
#ORACLE APEX SQL QUERY TRANSFORMATION RULE VERIFICATION#
The 3rd unique column either not in the upload data set OR selected as Do Not LoadĪND in the Data Load Definition, the Skip Verification setting is No. There are 3 Unique columns defined in the Data Load Definition I was able to track down the "no data found" error on Next moving from the column mapping page to the summary page, when: