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
Covering Topics on Oracle Queries in a Detailed Way!
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…
