Oracle Apex: Interactive Grid gives "must have some value" errors when adding rows (even when values have been supplied)

 Problem

You are adding rows in an IG, and even when you are clearly supplying all values, you get the below error.

Solution

In your SQL definition you are using aliases, which confuses the Apex validation logic.

Remove those, putting aliases in your column titles instead.