First, run your query separately and check if it is returning records. If returning, then it should show in the card report. To test, you can remove the blob column for now and check with the following columns only:

select
PROP_LOCATION_NM CARD_TEXT,
PROP_LOCATION_CD CARD_SUBTITLE,
PROP_LOCATION_REGION CARD_SUBTEXT
from WADOMASS_PROP_ADRESS;

If the report shows the data, then it means somewhere problem with your blob data.

In Oracle Apex, upload data wizard logs error information in the collection and creates the report using the collection.

So it is better to modify the query to replace the error column usually (c048) using the case statement. Below is an example:

In the “Data Load Results” page, modify the failed records region query as following:

select n001 as row_num,
wwv_flow_lang.system_message( 'DATA_LOAD.' || c049 ) as action,
case when substr(c048, 1, 14) = '-1 : ORA-00001' then
'Duplicate row'
else 
c048
end error,
c001, c002, c003,
c004, c005, c006,
c007, c008, c009,
c010, c011, c012,
c013, c014, c015,
c016, c017, c018,
c019, c020, c021,
c022, c023, c024,
c025, c026, c027,
c028, c029, c030,
c031, c032, c033,
c034, c035, c036,
c037, c038, c039,
c040, c041, c042,
c043, c044, c045
from apex_collections
where collection_name = 'LOAD_CONTENT'
and c047 in ('FAILED') 
order by seq_id

In the above query, you can see, I am checking the first 14 characters of the C048 column, that if the value is ‘-1 : ORA-00001’, then replacing the error message with Duplicate Row. Similarly, you can replace any other errors too.

The following is the output now:

Ok, you can do the following:

Create a region as a parent region; for example, give the name ParentRegion.

Now create a sub-region (under parent region) for the two-page items, which will be above the classic report.

Then create another sub-region (under parent region) for the classic report.

Create another sub-region (under parent region) for the third item.

OR

You can simply create a new region below the classic report region and drag that third item to it.