Using 19.1 in RDBMS 12.2
I have a page with an interactive grid based on a single table. Table has several columns including ORDER_SEQ NUMBER and NAME VARCHAR2(50). Just so happens that ORDER_SEQ contains 999 on every row. I edited the default report and added sort by ORDER_SEQ, followed by NAME, both ascending order.
So the resulting page is showing random order, where I expect that since ORDER_SEQ is always 999, the rows should be in order by NAME. So I turned on DEBUG mode, and see in the SELECT that was issued to the database, there is an ORDER BY ORDER_SEQ only. If I edit the report to sort by NAME only, that works but if my users start changing the 999s in ORDER_SEQ, then that won't show the order they want.
Sorting by ORDER_SEQ AND NAME should work, but doesn't.