Issue with column orders when revising SQL on data models
I have an issue with data models and wanted to ask for advice here.
I'm using Oracle BI Publisher Enterprise (e.g. URL https://this.oraclecloud.com/xmlpserver/xdmeditor.jsp?f=/~myname/a.xdm).
I have noticed that I can be working on an SQL query on a data model (the issue happens with any data models, be it a new one or one I've previously saved and am editing), and the SQL might contain, for example:
select okhab.contract_number , oklb.line_number , ppav.segment1 from okc_k_headers_all_b okhab join okc_k_lines_b oklb on okhab.id = oklb.chr_id and okhab.major_version = oklb.major_version join pjb_cntrct_proj_links pcpl on okhab.id = pcpl.contract_id and okhab.major_version = pcpl.major_version and oklb.id = pcpl.contract_line_id join pjf_projects_all_vl ppav on pcpl.project_id = ppav.project_id where 1 = 1 and okhab.version_type = 'C' and oklb.version_type = 'C' and pcpl.version_type = 'C' and ppav.segment1 = '12345'