Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Issue with column orders when revising SQL on data models — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with column orders when revising SQL on data models

Accepted answer
edited Apr 9, 2020 11:20AM in Applications Security 2 comments



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'

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!