Overview

This section shows the available API objects and provides more information on executing SQL to Oracle Fusion Cloud HCM Cloud APIs.

Key Features

• The add-in models Oracle Fusion Cloud HCM Cloud entities like jobs, tasks, and salaries as relational views, allowing you to write SQL to query Oracle Fusion Cloud HCM Cloud data.
• Stored procedures allow you to execute operations to Oracle Fusion Cloud HCM Cloud.
• Live connectivity to these objects means any changes to your Oracle Fusion Cloud HCM Cloud account are immediately reflected when using the add-in.

Views

Views are dynamically obtained to model Oracle Fusion Cloud HCM Cloud objects.

Stored Procedures

Stored Procedures are function-like interfaces to Oracle Fusion Cloud HCM Cloud. They can be used to create schemas from Oracle Fusion Cloud HCM Cloud views.