Gettingthe latest builds (for the CI Builds panel or Activity Streams) fails with the following message on Oracle.
This is the SQL that is generated by Active Objects to get the ordered list of builds related to an issue.
The problem seems to be that the AO library adds quotes to the table name in the order by claus, even if the table name is actually an alias that should not be quoted.
Jira running on an Oracle DB
It was confirmed via email support that this fix worked on Jira installations running on an Oracle DB