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 Persons, Roles, and Users as relational views, allowing you to write SQL to query Oracle Fusion Cloud SCM data.
• Stored procedures allow you to execute operations to Oracle Fusion Cloud SCM.
• 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 resequence operations and perform midpoint rescheduling.