Generated by Rank Math SEO, this is an llms.txt file designed to help LLMs better understand and index this website. # SQLConnect | An Oracle Cloud Tool by SplashBI: Oracle Cloud Database Access Tool by SplashBI ## Sitemaps [XML Sitemap](https://sqlconnect.com/sitemap_index.xml): Includes all crawlable and indexable pages. ## Posts - [SQL Connect](https://sqlconnect.com/product/sql-connect/): SQLConnect helps you connect to your Oracle Cloud ERP, Oracle HCM Cloud, Oracle PPM cloud database via standard Oracle API from your desktop. We are Oracle developers at heart. When we started developing with and supporting Oracle ERP/HCM Cloud users, we found various issues that other developers resonate with: - [How FlashAI is Changing SQL Query Generation for Non-Technical Users](https://sqlconnect.com/blog/how-flashai-is-changing-sql-query-generation-for-non-technical-users/): Ever since ChatGPT was launched in 2022, conversational AI has been changing user behavior at breakneck speed. Complex tasks are becoming easier and more accessible. SQL is no different. - [Optimize Your Oracle Cloud Developer Experience with SQL Connect](https://sqlconnect.com/blog/optimize-your-oracle-cloud-developer-experience-with-sql-connect/): The transition from on-premise Oracle E-Business Suite (EBS) to Oracle Cloud is usually driven by the promise of scalability, flexibility, and operational cost savings. While these are excellent reasons for businesses to switch, transitioning to the cloud has completely altered how databases are accessed, and reports are generated. This evolution has brought its own challenges, particularly for developers and IT support staff, who are now faced with new constraints within Oracle Cloud's reporting environment. - [Transform Your Reporting: How SQL Connect for Oracle Cloud Applications Cuts Report Generation Time by 90%](https://sqlconnect.com/blog/transform-your-reporting/): In today's data-driven world, timely access to insights is crucial for businesses to thrive. Traditional reporting methods, often reliant on IT, can be slow and cumbersome. But what if you could slash report generation time by a whopping 90%? Enter SQL Connect for Oracle Cloud Applications, a game-changer for your reporting process. - [Maximising Efficiency: Background Query Execution with SQL Connect for Oracle Fusion Cloud Applications](https://sqlconnect.com/blog/maximising-efficiency/): Explore: - [bipublishersecuritysetup](https://sqlconnect.com/uncategorized/bipublishersecuritysetup-2/): When you are using a local connection and have the admin privileges, SQLConnect will automatically upload BI Publisher Objects for you. You will get following message. You can check if you have administrative privileges or not using instructions listed in Step 5 - [SQL Query to find all active errors reported on Orders in Oracle SCM Cloud](https://sqlconnect.com/query-samples/sql-query-to-find-all-active-errors-reported-on-orders-in-oracle-scm-cloud/): SQL Query to find all active errors reported on Orders. This is the query to see errors reported for Orders entered from UI - - [Organization SQL Query in Oracle Cloud ERP](https://sqlconnect.com/query-samples/organization-sql-query-in-oracle-cloud-erp/): The main table for inventory organizations and parameters is called INV_ORG_PARAMETERS. The MASTER_ORGANIZATION_ID relates back to the same table listing the parent of the organization. Other organization information is stored in Human Resource (HR) tables like HR_ORGANIZATION_UNITS_F_TL. - [Step by step to run a SQL query in Oracle Fusion Cloud](https://sqlconnect.com/product/step-by-step-to-run-a-sql-query-in-oracle-fusion-cloud/): Here is How to run a SQL Query in Oracle SAAS (Fusion) cloud environment. - [On Hand Quantity Query in Oracle SCM Cloud](https://sqlconnect.com/query-samples/on-hand-quantity-query-in-oracle-scm-cloud/): Using this query you can find out On hand quantity for any item in Oracle SCM cloud. It used tables in SCM Cloud such as EGP_system_Items, INVentory tables like INV_units_of_measure, INV_org_parameters, INV_onhand_quantities_detail and INV_item_locations tables. - [Goods Receipt Quantity Query in SCM Cloud](https://sqlconnect.com/query-samples/goods-receipt-quantity-query-in-scm-cloud/): --Goods Receipt Quantity SELECT Distinct pha.segment1 as "PO Number" , ps.Vendor_ID as "Vendor Number" , ps.attribute1 as "Vendor Class" , ps.attribute2 as "Managing Office" , ps.ATTRIBUTE_NUMBER1 as "Supplier Legacy" , ps.vendor_name as "Vendor Name" , rsl.VENDOR_ITEM_NUM as "Vendor Item Num" , rsl.ITEM_DESCRIPTION as "Item Description" , rsl.QUANTITY_SHIPPED as "Quantity Shipped" , rsl.QUANTITY_RECEIVED as "Quantity Received" , to_char( rct.TRANSACTION_DATE, 'DD/MM/YYYY') as "Transaction Date" , pla.UNIT_PRICE* pla.QUANTITY as "Line Value" , HOU.Name as "Organization Name" , pla.UNIT_PRICE as "Unit Price" , To_Char( pha.creation_date,'DD/MM/YYYY') as "PO Creation Date" , gl_flexfields_pkg.get_concat_description (chart_of_accounts_id, PDA.code_combination_id ) as "Code Combination Description" , gcc.segment1 ||'.' ||gcc.segment2 ||'.' ||gcc.segment3 ||'.' || gcc.segment4 ||'.' ||gcc.segment5 ||'.' ||gcc.segment6 ||'.' ||gcc.segment7 ||'.' ||gcc.segment8 ||'.' ||gcc.segment9 ||'.' ||gcc.segment10 as "Concatenated Segments" , RSH.RECEIPT_NUM as "Receipt Number" , pla.QUANTITY as "PO Line Ordered Quantity" , CASE When pha.segment1 LIKE '4%' THEN 'Franchise' ELSE 'Company owned' End as "Business ID" , Null as "DS PO Indicator" , TO_CHAR( rct.Transaction_Date, 'MON' ) as "Fiscal Period" , TO_CHAR( rct.Transaction_Date, 'YYYY' ) as "Fiscal Year" , TO_CHAR( sysdate, 'MON' ) as "Regular Period" , TO_CHAR( sysdate, 'YYYY' ) as "Regular Year" , Null as "PO_USER_FLD_1" , Null as "PO_USER_FLD_6" , rct.COMMENTS as "Receipt Description" FROM RCV_SHIPMENT_HEADERS RSH , RCV_SHIPMENT_LINES RSL , PO_HEADERS_ALL PHA , PER_PERSON_NAMES_F_V PersonName , PO_LINES_ALL pla , PO_DISTRIBUTIONS_ALL pda , PO_LINE_TYPES_B PLTB , POZ_SUPPLIERS_V ps , POZ_SUPPLIER_SITES_V pss , RCV_TRANSACTIONS rct , HR_ALL_ORGANIZATION_UNITS_X HOU , GL_CODE_COMBINATIONS GCC WHERE RSH.SHIPMENT_HEADER_ID =RSL.SHIPMENT_HEADER_ID AND RSL.po_header_id =PHA.po_header_id AND HOU.ORGANIZATION_ID =rct.ORGANIZATION_ID AND GCC.CODE_COMBINATION_ID =PDA.CODE_COMBINATION_ID AND PersonName.PERSON_ID =PhA.agent_id AND pla.po_header_id =PHA.po_header_id AND PDA.PO_DISTRIBUTION_ID =rct.PO_DISTRIBUTION_ID AND PLTB.line_type_id =pla.LINE_TYPE_ID AND pla.PO_LINE_ID =rsl.PO_LINE_ID AND pha.VENDOR_ID =ps.vendor_id AND pss.VENDOR_ID =ps.vendor_id AND rct.SHIPMENT_HEADER_ID =RSH.SHIPMENT_HEADER_ID AND rsl.SHIPMENT_LINE_ID =rct.SHIPMENT_LINE_ID AND trunc( rct.TRANSACTION_DATE) between :Receipt_Date_From and :Receipt_Date_To AND ps.ATTRIBUTE_NUMBER1 =:Sup_Leg_No - [Oracle Cloud Source System IDs for all Business Objects](https://sqlconnect.com/query-samples/oracle-cloud-source-system-ids-for-all-business-objects/): Below listed are some of the queries to get Source System Ids for business objects Person, Periods of Service, National Identified, and Person Legislative Info from Oracle HCM Cloud application. - [HCM Cloud – Time in Job, Time in Position Query](https://sqlconnect.com/query-samples/hcm-cloud-time-in-job-time-in-position-query/): This query in Oracle HCM Cloud provides information on Employees and how much time they have been in a certain job or in a certain Position. - [Direct and Indirect Reports for a Manager](https://sqlconnect.com/query-samples/direct-and-indirect-reports-for-a-manager/): In this query, you can get the details of Managers and their direct/indirect reports from Oracle HCM Cloud. - [SQLConnect Shortcuts](https://sqlconnect.com/support/sqlconnect-shortcuts/): Here is a list of shortcuts - keystroke combinations - that can help you do a number of tasks quickly in OracleCloudTools SQLConnect applications. - [Covid-19 Reporting in Oracle HCM Cloud](https://sqlconnect.com/query-samples/covid-19-reporting-in-oracle-hcm-cloud/): Here is a list and pre-built reports to help Human Resources with COVID-19 Reporting with Oracle HCM Cloud. Hope this helps. - [Comparing OTBI and SQLConnect](https://sqlconnect.com/product/comparing-otbi-and-sqlconnect/): So you need some data out of your Oracle ERP/HCM Cloud? - [Oracle Cloud Reporting Tips and Tricks](https://sqlconnect.com/uncategorized/oracle-cloud-reporting-tips-and-tricks/): Oracle ERP Cloud, HCM Cloud and SCM Cloud are becoming more and more popular and mainstream ERP applications. With the number of increasing users, there are a lot of questions on how to get data our of Oracle ERP Cloud. How do you use OTBI? What are the gotchas with OTBI and BI reporting in Oracle ERP or HCM Cloud. - [SQLConnect Data Security with Oracle Cloud SAAS](https://sqlconnect.com/product/sqlconnect-data-security-with-oracle-cloud-saas/): How do you know that SQLConnect is secure and your data is not at risk? Specially, with your Oracle Cloud HCM data. You do not have to worry. Oracle Cloud Tools SQLConnect helps you connect with HCM Cloud, connect with Oracle ERP Cloud, without compromising your data security. Here are some basics about SQLConnect data security with Oracle SAAS Cloud that might help you understand and make a decision easily. - [SQLConnect 1 Month FREE Referral Program](https://sqlconnect.com/product/sqlconnect-1-month-free-referral-program/): If you are on this page - someone who cares about you has sent you a link to this page. Welcome, to SQLConnect. - [How to connect to Oracle cloud ERP database using SQL developer](https://sqlconnect.com/product/how-to-connect-to-oracle-cloud-erp-database-using-sql-developer/): A lof of Oracle Cloud ERP and HCM users are searching online for ways on how to connect to Oracle cloud ERP database using SQL developer. Unfortunately, there are not many answers they are getting. - [Person Habits in Oracle HCM Cloud Benefits](https://sqlconnect.com/query-samples/person-habits-in-oracle-hcm-cloud-benefits/): A lot of times, we need to find to out the Person Habits for Benefits if an employee is tobacco user or not. You can use and change the SQL with your requirements - [Benefits Life Events in Oracle HCM Cloud](https://sqlconnect.com/query-samples/oracle-benefits-life-events/): SQL to find all the potential and processed life events - [Oracle BI Publisher Security Setup for SQLConnect](https://sqlconnect.com/support/bipublishersecuritysetup/): When you are using a local connection and have the admin privileges, SQLConnect will automatically upload BI Publisher Objects for you. You will get following message. You can check if you have administrative privileges or not using instructions listed in Step 5 - [Person and Assignment in Oracle HCM Cloud](https://sqlconnect.com/query-samples/person-and-assignment-in-oracle-hcm-cloud/): You can use the below SQL Query to retrieve Person and Assignment Information from Oracle HCM Cloud. - [How to connect to oracle cloud database using SQL Developer?](https://sqlconnect.com/product/how-to-connect-to-oracle-cloud-database-using-sql-developer/): A lot of our Oracle Cloud ERP and Oracle Cloud HCM users ask us this question: How do I connect to oracle cloud database using SQL Developer? - [Using Database Browser for Oracle Cloud](https://sqlconnect.com/product/using-database-browser-for-oracle-cloud/): Oracle Cloud Tool's SQLConnect comes with a Database Browser. Using this Database Browser, you can browse most of the Oracle Cloud ERP and Oracle Cloud HCM tables and views. - [SQLConnect Installation Instructions](https://sqlconnect.com/product/sqlconnect-installation-instructions/): STEP 1 - Download Software (Use one of the links from www.oraclecloudtools.com/downloads for Mac/Windows PROD or BETA version). - [Privacy Policy](https://sqlconnect.com/product/privacy-policy/): At Oracle Cloud Tools, we collect and manage user data according to the following Privacy Policy. - [Database Access In Fusion Cloud Applications](https://sqlconnect.com/product/database-access-in-fusion-cloud-applications/): When is comes to accessing Fusion ERP/HCM Data, there any many ways to do it. Ofcourse if you ask us, we will tell you the best way to do it is using SQLConnect application. - [Release Notes](https://sqlconnect.com/product/release-notes/): Email to Request a feature - support@oraclecloudtools.com - [SQLConnect User Guide](https://sqlconnect.com/product/sqlconnect-user-guide/): Online Demo:  https://youtu.be/2X-dQdwzzxs - [Online Demo Request](https://sqlconnect.com/product/online-demo-request/): Please enter your name and email address below to setup a demo for your team. You can watch the online demo of SQL Connect application below and learn how you can connect with Oracle HCM, ERP, PPM Cloud SAAS Application from your desktop. ## Pages - [SQLConnect – An Oracle Cloud Tool by SplashBI! – 2026](https://sqlconnect.com/): ( Try SQL Connect free for 15 days ) - [Features – SQLConnect – An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/features/): SQL Connect combines enterprise connectivity, powerful SQL development tools, visual query capabilities, validation workflows, and enterprise-grade governance in a single SQL workspace. - [Ads Landing Page – SQLConnect](https://sqlconnect.com/ads-landing-page-sqlconnect/): No commitment required, discover how it can streamline your SQL queries and data exports. There's no obligation—just an opportunity to see how SQL Connect can boost your productivity. Start your free trial today! - [SQL Connect Downloads](https://sqlconnect.com/sql-connect-downloads/): Stop wrestling with clunky web tools and slow XML exports. Get the powerful, intuitive IDE you've been missing for Oracle Cloud and start running queries in minutes. - [SQL User Guide](https://sqlconnect.com/sql-user-guide/): This user guide provides information on how to use the Oracle Cloud Tool’s SQL Connect software. - [Installation Instructions](https://sqlconnect.com/installation-instructions/): You can download the latest software from the location below. - [Oracle BI Publisher Security Setup For SQL Connect](https://sqlconnect.com/oracle-bi-publisher-security-setup-for-sql-connect/): Review Oracle Cloud Tools Report Security - [Elementor #168081](https://sqlconnect.com/elementor-168081/): Transform your Oracle Cloud workflow with rapid ad-hoc queries, direct data exports, and effortless database browsing. - [Store Manager](https://sqlconnect.com/store-manager/) - [Order Confirmation](https://sqlconnect.com/order-confirmation/): Ready to download the latest version of SQL Connect? Simply click the button below to get started. - [Pricing](https://sqlconnect.com/pricing/): Find the plan that fits your needs perfectly. Simple choices, powerful results— take your SQL to the next level! - [Downloads](https://sqlconnect.com/downloads/): READY TO UPGRADE YOUR SQL WORKFLOW? Looking for a partner to streamline your data tasks? SQL Connect is here to pull data from multiple Oracle ERP/SCM/HCM Pods. Run ad hoc queries, extract data to CSV or Excel, and make the most of your data. Discover the ease and efficiency of SQL Connect today! Download for Windows Download for MacOS View Installation Guide - [About Us](https://sqlconnect.com/about-us/): Our new website highlights the evolution of SQL Connect, emphasizing our commitment to enhancing SQL querying and data handling. This rebranding underscores our dedication to providing real-time efficiency and versatility with Oracle Fusion ERP, SCM, HCM Pods, all within an intuitive environment. SQL Connect responds to the dynamic needs of SQL professionals, offering a future-proof platform for today and tomorrow’s data challenges. - [Release Notes](https://sqlconnect.com/release-notes/): Release sequence: 20260201 - [FAQ](https://sqlconnect.com/frequently-asked-questions-faq/): SQL Connect is your trusted tool for efficient Oracle Fusion Cloud data querying. We’ve put together some of our most asked questions for you. Browse the FAQs below. - [Terms & Conditions](https://sqlconnect.com/terms-conditions/): Terms & Conditions Download the terms & Conditions - [Privacy Policy](https://sqlconnect.com/privacy-policy/): This privacy statement was last changed on May 22, 2022, last checked on May 22, 2023, and applies to citizens and legal permanent residents of the United States and the European Union. - [Contact](https://sqlconnect.com/contact-us/): You have questions, we have answers. Feel free to reach out! To contact us, simply select a category related to your inquiry, fill out the form, and one our experts will contact you shortly! - [SQLConnect – An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/new-homepage-mock/): ( Try SQL Connect free for 15 days ) - [Protected: Homepage-2023](https://sqlconnect.com/homepage-2023/): SQL Connect by SplashBI is a powerful IDE solution that allows you to quickly and easily connect to multiple Oracle Fusion ERP/SCM/HCM Pods. SQL Connect lets you run ad-hoc queries, extract data to CSV or Excel, and browse cloud database objects, all in one place. With features like Intellisense, SQL Connect streamlines your Oracle Cloud development and boosts productivity. - [Welcome-Message](https://sqlconnect.com/welcome-message/): SQLConnect Application - [Software License Agreement](https://sqlconnect.com/software-license-agreement/) - [Communication preferences](https://sqlconnect.com/communication-preferences/) - [Signup for SQL Connect New](https://sqlconnect.com/signup-for-sql-connect/): You can download latest version of SQL Connect for your Windows or Mac computer. - [SQL Connect- An Oracle Cloud Tool](https://sqlconnect.com/sql-connect-an-oracle-cloud-tool-new/): SQL Connect by SplashBI is a powerful IDE solution that allows you to quickly and easily connect to multiple Oracle Fusion ERP/SCM/HCM Pods. SQL Connect lets you run ad-hoc queries, extract data to CSV or Excel, and browse cloud database objects, all in one place. With features like Intellisense, SQL Connect streamlines your Oracle Cloud development and boosts productivity. - [Privacy Policy](https://sqlconnect.com/privacy-policy-old/): This Privacy Policy describes how SQLConnect and its affiliates and subsidiaries (collectively, “SQLConnect ”) collects, uses, processes, protects, and discloses personal information collected through the use of its software (the “Software’) and the performance of its Services (as defined below). - [Subscription](https://sqlconnect.com/subscription/) - [Oracle Cloud Queries](https://sqlconnect.com/oracle-cloud-queries/): SQL Connect by SplashBI offers connectivity to multiple Oracle ERP/SCM/HCM Pods and lets users run ad-hoc queries, extract data to CSV or Excel. Equipped with Intellisense and a cloud database browser, SQL Connect brings productivity to your Oracle Cloud development. - [Checkout](https://sqlconnect.com/checkout/): First Name * - [Shop](https://sqlconnect.com/shop/) - [Oracle Queries](https://sqlconnect.com/oracle-queries/): Covering Topics on Oracle Queries in a Detailed Way! - [Oracle BI Publisher Security Setup for SQL Connect](https://sqlconnect.com/oracle-bi-publisher-security-setup/): Following information must be reviewed from a data security point of view when deploying/using and adding new users to SQL Connect. - [SQLConnect Installation Instructions](https://sqlconnect.com/sqlconnect-installation-instructions/): Setting Up SQL Connect is a Walk in the Park! - [Refer Your Friends](https://sqlconnect.com/refer-your-friends/): Refer Your Friends to use SQLConnect and win a special gift from SQLConnect.com.Fields marked with an * are required - [Customer Stories](https://sqlconnect.com/customer-stories/): Here we are sharing some of our customer success stories from handpicked customers who have been using OracleCloudTools SQLConnect. - [Oracle Cloud Tools Downloads](https://sqlconnect.com/oracle-cloud-tools-downloads/): Please find the latest SQL Connect Installers below. For any questions, please email support@sqlconnect-com-192955.hostingersite.com. - [SQLConnect User Guide](https://sqlconnect.com/sqlconnect-user-guide/): This user guide provides information on how to use the Oracle Cloud Tool’s SQL Connect software. - [Online Demo Request](https://sqlconnect.com/online-demo-request/): Please enter your name and email address below to setup a demo for your team. You can watch the online demo of SQL Connect application below and learn how you can connect with Oracle HCM, ERP, PPM Cloud SAAS Application from your desktop. - [SQL Connect- An Oracle Cloud Tool Old](https://sqlconnect.com/corporate-creative-landing/): Save Thousands Of Dollars In Efficiency Gains Individual Plan Features Up to 2 Cloud ERP/HCM Connections SQL Formatting Export to CSV and Excel * Limited Support and Updates Email support * All core features included Local Sign-on only Enterprise Plan Features Unlimited Cloud Connections Intellisense and SQL Formatting Export to CSV and Excel Database Browser Regular updates with Priority Beta Release 8x5 Email support Included All core features included Local Sign-on or SSO ## Glossary - [Developer Tools](https://sqlconnect.com/glossary/developer-tools/): Oracle Developer Tools: Enhancing Your Development Experience Oracle Developer Tools is a suite of software utilities designed to support the development, management, and deployment of Oracle applications. These tools provide a comprehensive environment for developers, making it easier to create, debug, and optimize applications that interact with Oracle databases. They cater to various development needs, ensuring a smooth and efficient workflow for developers and database administrators alike. Key Features and Benefits Integrated Development Environment (IDE) Oracle Developer Tools includes IDEs like Oracle JDeveloper and Oracle SQL Developer. These offer features like code editing, debugging, and profiling, supporting multiple programming languages and seamless integration with Oracle databases. Database Management These tools support creating, modifying, and managing database objects such as tables, views, and procedures. Visual aids like Entity-Relationship (ER) diagrams and SQL query builders simplify complex database tasks. Advanced SQL Editing The tools feature advanced SQL editors with syntax highlighting, code completion, and error detection, helping developers write efficient SQL code. SQL debugging is also supported for resolving script issues. Application Development Frameworks Frameworks like Oracle Application Development Framework (ADF) accelerate enterprise application creation, providing reusable components, a visual development environment, and integrated security features. Performance Tuning and Optimization Tools like SQL Tuning Advisor and Automatic Workload Repository (AWR) reports help identify and resolve performance bottlenecks, ensuring efficient application performance. Data Integration and Migration Tools like Oracle Data Integrator (ODI) facilitate data integration and migration, making it easy to move data between different systems and applications. Transition to SQL Connect While Oracle Developer Tools are comprehensive, businesses often need specialized solutions for data extraction and reporting. SQL Connect offers advanced reporting capabilities and seamless integration with Oracle databases SQL Connect: Enhancing Your Oracle Reporting Experience Streamlined Data Extraction SQL Connect simplifies data extraction from Oracle databases, reducing complexity and time for report generation. Advanced Reporting Features SQL Connect provides advanced reporting features not available in Oracle Developer Tools, allowing for detailed, customizable reports. Seamless Integration SQL Connect integrates smoothly with Oracle Developer Tools, leveraging existing SQL knowledge while enhancing reporting capabilities. User-Friendly Interface SQL Connect offers a user-friendly interface for easy report creation and management without extensive technical knowledge. Conclusion Oracle Developer Tools are essential for developing, managing, and optimizing Oracle applications, offering robust features for database management, SQL editing, application development, and performance tuning. For advanced reporting, SQL Connect complements these tools by enhancing data extraction and reporting, helping organizations streamline processes and make data-driven decisions effectively. - [Fusion ERP Queries](https://sqlconnect.com/glossary/fusion-erp-queries/): Oracle Fusion Enterprise Resource Planning (ERP) is a comprehensive suite designed to manage various business functions effectively. Oracle Fusion ERP queries are powerful tools that allow users to extract and analyze data across different modules, providing valuable insights for decision-making and business optimization. - [Fusion HCM Queries](https://sqlconnect.com/glossary/fusion-hcm-queries/): Oracle Fusion Human Capital Management (HCM) is a comprehensive suite of applications designed to manage an organization's human resources functions effectively. Oracle Fusion HCM queries are an essential tool within this suite, allowing users to extract valuable data, generate reports, and make informed decisions based on employee and organizational data. - [Oracle Fusion Financial SQL Queries](https://sqlconnect.com/glossary/oracle-fusion-financial-sql-queries/): SQL Connect is specifically crafted to access the extensive and intricate data stored within the Oracle Fusion Financial suite. These queries empower users to extract valuable insights from various modules, including General Ledger, Accounts Payables, Accounts Receivables, Cash Management, and Fixed Assets, seamlessly integrating them for reporting, analytics, and strategic financial operations. - [Oracle Fusion HCM SQL Queries](https://sqlconnect.com/glossary/oracle-fusion-hcm-sql-queries/): In the context of SQL Connect, Oracle Fusion HCM SQL Queries are crafted to access the rich and complex data held within the Oracle Fusion HCM suite. SQL Connect users can utilize these queries to draw insights from HR data, integrating them seamlessly for reporting, analytics, and strategic HR operations. - [Oracle Fusion SCM SQL Queries](https://sqlconnect.com/glossary/oracle-fusion-scm-sql-queries/): SQL Connect is designed to access the extensive and intricate data stored within the Oracle Fusion SCM suite. These queries enable users to extract valuable insights from various modules such as Order Management, Inventory, and Shipping, seamlessly integrating them for reporting, analytics, and strategic Supply Chain Operations. - [Oracle SQL Developer Tool](https://sqlconnect.com/glossary/oracle-sql-developer-tool/): The Oracle SQL Developer Tool is a powerful ally for SQL Connect users, offering an optimized environment that eases complex database tasks, particularly in writing and executing SQL queries. This tool is engineered to enhance the SQL Connect experience, making it a go-to resource for efficient database management. - [SQL developer](https://sqlconnect.com/glossary/sql-developer/): 3. Data Modeling and Design Oracle SQL Developer includes tools for data modeling and database design. Users can create and modify Entity-Relationship (ER) diagrams and generate SQL scripts for database creation. These features help design efficient and scalable databases that meet business needs. - [SQL Developer Download](https://sqlconnect.com/glossary/sql-developer-download/): Oracle SQL Developer is a powerful, integrated development environment (IDE) that simplifies working with SQL in Oracle databases. It provides a user-friendly interface for running queries, managing database objects, and performing various administrative tasks, making it an essential tool for developers, DBAs, and data analysts. # SQL Connect: Oracle Cloud Database Access Tool by SplashBI > SQL Connect is a state-of-the-art Integrated Development Environment (IDE) designed to enhance efficiency in connecting to multiple Oracle Fusion ERP/SCM/HCM Pods. It enables users to execute ad-hoc queries, export data to CSV or Excel formats, and navigate cloud database objects with ease, offering a seamless experience within a unified platform. ## Homepage - [SQLConnect - An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/) ## About - [About Us - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/about-us/): Our new website highlights the evolution of SQL Connect, emphasizing our commitment to enhancing SQL querying and data handling. ## Products - [SQLConnect - An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/product/comparing-otbi-and-sqlconnect/) - [SQLConnect - An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/product/database-access-in-fusion-cloud-applications/) - [SQLConnect - An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/product/how-to-connect-to-oracle-cloud-database-using-sql-developer/) - [SQLConnect - An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/product/how-to-connect-to-oracle-cloud-erp-database-using-sql-developer/) - [SQLConnect - An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/product/online-demo-request/) - [SQLConnect - An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/product/privacy-policy/) - [SQLConnect - An Oracle Cloud Tool by SplashBI!](https://sqlconnect.com/product/release-notes/) - [SQL Connect Enterprise Edition (Monthly) - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/product/sql-connect-enterprise-edition-monthly/) - [SQL Connect Enterprise Edition- (SQL01) - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/product/sql-connect-enterprise-edition-sql01/) - [Pricing - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/product/sql-connect-enterprise-edition/): Simple choices, powerful results — take your SQL to the next level! ## Features - [Features - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/features/): Say goodbye to inefficient workflows and complex tools. Discover features designed ## FAQ - [FAQ - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/frequently-asked-questions-faq/): SQL Connect is your trusted tool for efficient Oracle Fusion Cloud data querying. We’ve put together some of our most asked questions for you. Browse the FAQs below. ## Query Samples - [Covid-19 Reporting In Oracle HCM Cloud | SQLConnect Blog!](https://sqlconnect.com/query-samples/covid-19-reporting-in-oracle-hcm-cloud/): Here is a list and pre-built reports to help Human Resources with COVID-19 Reporting with Oracle HCM Cloud. Hope this helps. - [Direct And Indirect Reports For A Manager | SQLConnect Blog!](https://sqlconnect.com/query-samples/direct-and-indirect-reports-for-a-manager/): In this query, you can get the details of Managers and their direct/indirect reports from Oracle HCM Cloud. - [Goods Receipt Quantity Query In SCM Cloud!](https://sqlconnect.com/query-samples/goods-receipt-quantity-query-in-scm-cloud/) - [HCM Cloud – Time In Job, Time In Position Query!](https://sqlconnect.com/query-samples/hcm-cloud-time-in-job-time-in-position-query/): As you can see in the below screenshot from SQLConnect, this query provides Time in Job and Time in a particular position in YEARS. Copy this query and use it in SQLConnect – Get the data you want. - [On Hand Quantity Query In Oracle SCM Cloud | SQLConnect Blog](https://sqlconnect.com/query-samples/on-hand-quantity-query-in-oracle-scm-cloud/) - [Benefits Life Events In Oracle HCM Cloud | SQLConnect Blog!](https://sqlconnect.com/query-samples/oracle-benefits-life-events/): pil.creation\_date pil\_creation\_date, - [Oracle Cloud Source System IDs For All Business Objects!](https://sqlconnect.com/query-samples/oracle-cloud-source-system-ids-for-all-business-objects/): Oracle Cloud Source System IDs for all Business Objects - [Organization SQL Query In Oracle Cloud ERP | SQLConnect Blog](https://sqlconnect.com/query-samples/organization-sql-query-in-oracle-cloud-erp/): The main table for inventory organizations and parameters is called INV\_ORG\_PARAMETERS. The MASTER\_ORGANIZATION\_ID relates back to the same table listing the parent of the organization. - [Person And Assignment In Oracle HCM Cloud | SQLConnect Blog](https://sqlconnect.com/query-samples/person-and-assignment-in-oracle-hcm-cloud/): pps.date\_start hire\_date, - [Person Habits In Oracle HCM Cloud Benefits | SQLConnect Blog](https://sqlconnect.com/query-samples/person-habits-in-oracle-hcm-cloud-benefits/): hr\_general.Decode\_lookup('TOBACCO\_USER', pbh.tobacco\_type\_usage) tobacco\_usage, - [SQL Query To Find All Active Errors In Oracle SCM Cloud!](https://sqlconnect.com/query-samples/sql-query-to-find-all-active-errors-reported-on-orders-in-oracle-scm-cloud/): SQL Query to find all active errors reported on Orders in Oracle SCM Cloud ## Support - [Oracle BI Publisher Security Setup for SQLConnect - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/support/bipublishersecuritysetup/): When you are using a local connection and have the admin privileges, SQLConnect will automatically upload BI Publisher Objects for you. You will get following message. You can check if you have adm... - [SQLConnect Demo | SQLConnect - An Oracle Cloud Tool!](https://sqlconnect.com/support/sql-connect-demo/): Watch this video demonstration for basic functions of Oracle Cloud Tools – SQL Connect application. - [SQLConnect Shortcuts | SQLConnect - An Oracle Cloud Tool!](https://sqlconnect.com/support/sqlconnect-shortcuts/): Here is a list of shortcuts – keystroke combinations – that can help you do a number of tasks quickly in OracleCloudTools SQLConnect applications. ## Pricing - [Pricing - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/pricing/): Simple choices, powerful results — take your SQL to the next level! ## Contact - [Contact - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/contact-us/): You have questions, we have answers. Feel free to reach out! To contact us, simply select a category related to your inquiry, fill out the form using this link, and one our experts will contact you shortly! ## Downloads - [Downloads - SQL Connect](https://sqlconnect.com/downloads/) ## Oracle Cloud Tools Downloads - [Downloads - SQL Connect](https://sqlconnect.com/oracle-cloud-tools-downloads/) ## Sql Connect Downloads - [SQL Connect Downloads - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/sql-connect-downloads/): Stop wrestling with clunky web tools and slow XML exports. Get the powerful, intuitive IDE you’ve been missing for Oracle Cloud and start running queries in minutes. ## Installation Instructions - [Installation Instructions - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/installation-instructions/): You can download the latest software of SQL Connect using this link. ## Sqlconnect Installation Instructions - [Installation Instructions - SQL Connect | An Oracle Cloud Tool by SplashBI](https://sqlconnect.com/sqlconnect-installation-instructions/): You can download the latest software from the location below. ## Customer Stories - [Customer Success Stories | SQLConnect - An Oracle Cloud Tool](https://sqlconnect.com/customer-stories/)