Archives

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

Comparing OTBI and SQLConnect

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 then allow you to compare which one seems better. In order for me to make a fair comparison, I’ll assume that you are an Oracle EBS user, and going to […]

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

SQLConnect Data Security with Oracle Cloud SAAS

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 for analysis, or adhoc queries. 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 […]

SQLConnect 1 Month FREE Referral Program

[vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text] If you are on this page – someone who cares about you has […]

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. The results show them videos and links to articles on how to connect with Oracle cloud database, which is a […]