Hi,
Our APEX moved from Apex 5.1 to Apex 20.1.0.00.13. I had interactive grid (editable) with ability to create new records. I have a primary key column in the grid which is tied up to DB Sequence.
I had the column as Hidden and the Default value is chosen as Type as "Sequence" and sequence name in lower case (Example: abcd_seq) in 5.1. It used to work fine but after upgrade to 20.1, the sequence did not work and was throwing error the it needed to be declared. After some trial and error method, I just renamed the sequence to Upper Case (like this -> ABCD_SEQ). It fixed the issue.
Wanted to check if this is a bug in the APEX or it requires the Sequence name to be given in Upper Case in 20.1 version