Overview

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

Key Features

• The add-in models Oracle Fusion Cloud SCM entities like Shifts, Schedules, and WorkdayPatterns as relational views, allowing you to write SQL to query Oracle Fusion Cloud SCM data.
• Live connectivity to these objects means any changes to your Oracle Fusion Cloud SCM account are immediately reflected when using the add-in.

Views

Views are dynamically obtained to model Oracle Fusion Cloud SCM objects. These objects are presented as read-only tables.

Stored Procedures

Stored Procedures are function-like interfaces to Oracle Fusion Cloud SCM. They can be used to resubmit messages, reprocess message and more.