Issue with column orders when revising SQL on data models

Content

Hi,

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'