How do you connect to your Oracle Cloud ERP/HCM Database? If you are using the standard mechanism to do this using Oracle and BI tools…
Read More
Oracle Queries
SQL Query to find all active errors reported on Orders. This is the query to see errors reported for Orders entered from UI – And…
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….
Here is How to run a SQL Query in Oracle SAAS (Fusion) cloud environment. As you probably know by now, there are multiple ways to…
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…
--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" ,...
Read More
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…
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…
In this query, you can get the details of Managers and their direct/indirect reports from Oracle HCM Cloud. This query uses following tables from ORacle…
Here is a list of shortcuts – keystroke combinations – that can help you do a number of tasks quickly in OracleCloudTools SQLConnect applications. For…
Here is a list and pre-built reports to help Human Resources with COVID-19 Reporting with Oracle HCM Cloud. Hope this helps. Oracle realizes that many…
So you need some data out of your Oracle ERP/HCM Cloud? There are many ways of doing it. I’ll show you two simple ways, and…
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…
SQLConnect is one of the few ways to connect to your Oracle Cloud SAAS (Oracle Cloud ERP/ Oracle Cloud HCM/PPM) applications and get your data…
If you are on this page – someone who cares about you has sent you a link to this page. Welcome, to SQLConnect. Using Coupon…
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…
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
SQL to find all the potential and processed life events
Review Oracle Cloud Tools Report Security Following information must be reviewed from a data security point of view when deploying/using and adding new users to SQL Connect. OracleCloudTools' SQLConnect uses...
Read More
You can use the below SQL Query to retrieve Person and Assignment Information from Oracle HCM Cloud.
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…
