Bring back Direct Database Query

Shyam Patel

In Normal, Data Set Can not use more than 1000 Expression, and It gives following Error, Then I need to Limit data and split
ORA-01795: maximum number of expressions in a list is 1000
 

rob1604

this is critical functionality for our client

User_R6A85

We need this feature

Raymund Jerome

Agree 100%

Sylvain Lemay CPA

This is absolutely a MUST. Oracle also will remove in 20D dynamic query we are using this with a custom tool that we have built that passes the sql query through a WEB services and returns the results but this will be decomission in 20D. So we do not have other alternative to use BI publisher or data model with the limitation of 200 rows

 

AnsumanM

Hi All,

I think this thread is kind of dead, as I do not see any response from Oracle. If anyone knows there is plan to revert this feature or bring another optimized feature, then please let me know. If Oracle has already done something then pardon my ignorance.

Below is the case study why this again came to my mind and I again started searching the forum with a hope,

There are more than thousand lines of PO matched to an invoice and the invoice went wrong. Oracle asked me APLIST, the APLIST fails as it has lot of lines and unable to render the output. Oracle is asking me to pull the records from individual tables like header, line and distribution etc.

Now I hope everyone can understand how painful for someone to pull output from these tables through OTBI data model and provide to Oracle.

Thanks

Julie Watson

Totally Agree, would make life so much easier

Ahmed Maher K.

Very helpful idea.

Rajeshwar Vuppala

Also vote for following Idea on the similar topic, issues with Query Screen

https://community.oracle.com/customerconnect/discussion/610761/full-large-sql-query-datamodel-and-record-count-for-all-cloud-screens-incl-bip-for-sox-audit-drls

Query Screen.png

Ahmed Maher K.

@Rajeshwar Vuppala Done. I would like to see those enhancement implemented.