SQL Query to get the Approval Workflow Details SELECT fwg.approvalgroupid AS "Group ID", fwg.approvalgroupname AS "Group Name", fwgm.member AS "Member Name (User or Group)", fwgm.type AS "Member Type (USER or GROUP)", fwgm.sequence AS "Sequence (for serial routing)" FROM fa_fusion_soainfra.wfapprovalgroups fwg INNER JOIN…

SQL Query to get the Approval Workflow Details SELECT fwg.approvalgroupid AS "Group ID", fwg.approvalgroupname AS "Group Name", fwgm.member AS "Member Name (User or Group)", fwgm.type AS "Member Type (USER or GROUP)", fwgm.sequence AS "Sequence (for serial routing)" FROM fa_fusion_soainfra.wfapprovalgroups fwg INNER JOIN…

wms_interfaced_flag from wsh_delivery_details CONFIRMED INTERFACED READY select distinct wms_interfaced_flag from wsh_delivery_details

https://community.oracle.com/customerconnect/discussion/774907/how-to-schedule-bip-report-with-increment-date-and-timestamp

https://us.v-cdn.net/6037859/uploads/EZNUHDEB676P/fdi-vs-bi-subject-area.xlsx Hi Sushanta, There are significantly fewer Subject Area FDI supports than in the BIP Subject Area. The FDI team gave our business a trial version. There is still a long way to go. FDI - 66 Subject Area --- No Planning, Services, Maintenance Track…

Following are the Good Free Web Version where we can run the SQL against the Cloud. I hope this will be very useful as there is no Limit to Rows for Extraction and this has very good Featuring to Extract in CSV or XLSX format. https://www.datafusing.com/CloudSQL/…

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

Oracle must revert this Functionality in 20C - August 2020 Release

Must be needed as SQL query limit to 200 lines only and very clumsy. either provide direct database or SQL connectivity to SAAS Application.Hence Either Oracle Re-enable this(Direct DataBase) or Provide the MySQL connectivity for users for faster connectivity to the database if oracle is much worried about the "database…

Hi Chandra, If Oracle insisting to using SQL query then remove the 200 Lines Limit as well. Regards Shyam