Author: admin

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 – And this is for Errors reported for imported orders:

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. Note that the _TL table is stripped by language so the example query just looks at the US […]

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. As you probably know by now, there are multiple ways to extract desired data out of Oracle Cloud SAAS applications including HCM/ERP/SCM cloud. These steps are a quick and easy way to extract data by running a SQL query in Oracle […]

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. Add any additional columns that you want and use Oracle Cloud Tools SQLConect database browser to learn more about each […]

Goods Receipt Quantity Query in SCM Cloud

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

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. 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 […]

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. This query uses following tables from ORacle HCM CLoud – PER_ASSIGNMENT_SUPERVISORS_F , PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M and PER_ASSIGNMENT_SUPERVISORS_F tables to get the manager information of an employee. And here is the output as it looks in HCM Demo environment, […]

SQLConnect Shortcuts

Here is a list of shortcuts – keystroke combinations – that can help you do a number of tasks quickly in OracleCloudTools SQLConnect applications. For example when running query against Oracle cloud saas applications, if you want to change a column’s date format and add to_Char to the query quickly, try ctrl-D…    # Function […]

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. Oracle realizes that many of HCM Cloud users are busy responding to the current COVID-19 Coronavirus pandemic. Hope that this series of reports will provide relevant content designed to save you time. Monitor Passport […]