Overview

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

Key Features

• The cmdlet 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 cmdlet.

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.