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

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 = oklb.chr_id and okhab.major_version = oklb.major_version
  join pjb_cntrct_proj_links pcpl on = pcpl.contract_id and okhab.major_version = pcpl.major_version and = 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!