I am working in Apex 21.2 On Apex.Oracle.com.
I need to import data from Excel, add some Page Item values to the imported data and save the results into an existing table.
One method that I thought might work is to add SQL Expression columns to my Data Load Data Profile page where fields are mapped.
I added a column named GROUP_QUOTE_ID to the profile and set it as type SQL Expression. The SQL code is SELECT :P33_GROUP_QUOTE_ID FROM DUAL. I was hoping this would pull the Pate Item value from Page 32 which is open when the import runs.
I'm getting an error after clicking Load Data on my data load page (configured as Model Dialog to float overtop of Page 32. The error ORA-01008: not all variables bound.
GROUP_QUOTE_ID is column name in the Target Table.
Any help is appreciated!